Welcome to ScubaBoard, an online scuba diving forum community where you can join over 205,000 divers from around the world discussing all things related to Scuba Diving. To gain full access to ScubaBoard (and make this large box go away) you must register for a free account. As a registered member you will be able to:
Participate in over 500 dive topic forums and browse from over 5,500,000 posts.
Communicate privately with other divers from around the world.
Post your own photos or view from well over 100,000 user submitted images.
Gain access to our free classifieds marketplace to buy, sell and trade gear, travel and services.
Use the calendar to organize your events and enroll in other members' events.
All this and much more is available to you absolutely free when you register for an account, so sign up today!
If you have any problems with the registration process or your account login, please contact the ScubaBoard Support Team.
After downloading a couple of the dive logs people have posted to the forum, I modified the format and put it into excel. The form will auto calculate the air pressure used and the RNT+ ABT. I would like it to calculate the Total Dive Time to Date but I haven't worked out the calc for that yet. Feel free to use and modify.
To do what you want, with the slick interface I would suggest Access instead of Excel. I may play around with it if I have time (I'm no Access guy though). You can create "forms" that would put the data in "tables". From there you can run queries on the data in the tables. Things like "Total Dives in water between 45 and 55F" or "Total dives at quarry 1". Once you get the data in the tables, you can do lots of cool stuff with it. Anybody already have / seen / know of such a beast so the wheel doesn't havfe to be reinvented?
Calculating Total Dive Time to Date is a *****, but it can be done. I've worked it out, but it's not pretty. There has to be a better method. PM your e-mail address to me and I'll send you what I've worked out.
To do what you want, with the slick interface I would suggest Access instead of Excel. I may play around with it if I have time (I'm no Access guy though). You can create "forms" that would put the data in "tables". From there you can run queries on the data in the tables. Things like "Total Dives in water between 45 and 55F" or "Total dives at quarry 1". Once you get the data in the tables, you can do lots of cool stuff with it. Anybody already have / seen / know of such a beast so the wheel doesn't havfe to be reinvented?
Rhad
Rhad,
I like your idea. I can do some things in Access but sadly building forms isn't one of them. With a small bit of work I think the data could be inported from the excel spread sheet into acess to accomplish the query possiblities though. If I had the time I could build a web interface for the form to dump the data in Access since I have done this kind of thing before.
Rhad,
I like your idea. I can do some things in Access but sadly building forms isn't one of them. With a small bit of work I think the data could be inported from the excel spread sheet into acess to accomplish the query possiblities though. If I had the time I could build a web interface for the form to dump the data in Access since I have done this kind of thing before.
I think that the form part is the easiest part of the database. Once the tables are setup I think you can just use the form wizard. It is just the device for getting the data in. You can them make them as fancy or simple as you like.
With that said, I think you can D/L DataTrack for free from the Uwatec site. Though it is lacking in some areas, it will give you total dive time and some other neat statistics...
I modified the excel file to calculate the new total dive time. I also have it set up to print 2 logs per sheet and if you have a double sided capable printer you can print 2 logs on each side and cut the sheet in half for a smaller log book.
Here is a Log I just started working on....Any Access gurues out there??
Let me know what you all think and feel free to change any/everything!!
Does anyone know how to have a button that saves the log and clears it
for another entry?
After spending 3 hours building a web page and then this for
a couple more, I am spent!!
When you open it go to FORMS, Then dive log. It will allow you to enter the info but not save and then add another.....Saw the post took a shot..
Once again I would like your feed back..I get past that small save and clear issue
and I can add anything anyone would like.
Thanks,
Coz
Last edited by cozdiver2001; October 30th, 2004 at 08:39 PM.
To add a Record command button:
1) Design View on the form
2) Select Command Button on from the Toolbox and add the command button to the form. Once placed, the "Command Button Wizard" will pop-up and you can configure the command button to do what you want.
3) In the "Command Button Wizard", select Category: Record Operation and Action: Add New Record. Select [Next].
4) Name the button or add image. Select [Next].
5) Name button, and select [Finish].
LinkBack URL
About LinkBacks
Reply With Quote
Originally Posted by rhadamanthus
