Total elapsed time

[Craigind]

I am not sure if I am posting this in the right place but...

What I am doing is creating an Access database for SCUBA divers to log there dives. Since I am planning on making this a free open source program, I alredy posted it at
http://craigs.x10.mx/public_ftp/incoming/
the two things I am stuck on right now are

1. When the diver enters the elapsed time for the current dive in the form, I want the database to automatically add the current dive time to the total (lifetime) dive time.
2. allow the diver to attach a picture to each form using the "Brows" button.


3. I would like to set it up so it just automatically opens to the "form view", in fact it really only needs to open the form.

I am pretty new to Access so any help I can get would be great.

[June7]

Why don't you check this out http://www.scubaboard.com/forums/mak...-database.html

1. Aggregate data (like total lifetime dive time) usually should not be saved to table but calculated as needed.

2. You want to save embedded images in table? What 'browse' button? Review http://office.microsoft.com/en-us/ac...001213852.aspx

3. What do you mean? You want file to open to a default form? That can be set with project property settings. Click the Office button>Options>CurrentProject>set preferences