Entering Time

[AmberO]

I am creating a page where the user needs to enter a time that will get stored in an access database. I can get it to work fine if I have the user key the time into a text box (and I have the form send the results to database). However, I would rather use drop down boxes for the hour, minute and Am\Pm. Does anyone know how I can get this to work?

Thanks in Advance!

 

[Noconi]

Any reason you can't have a field in the database for hour, minute, am/pm separatly? For any displays of the data - you can make it appear all on one line, but this way you could use the drop downs like you wish.

Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com

 

[AmberO]

Thanks for the response,

I could store the data in three separate columns. If I did that, how would I work with time calculations? (I am going to need to calculate the number of hours between two times).

 

[Noconi]

I am sure it could be done, but would certainly complicate things don't have any great advice for you on that. Sorry.

Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com

 

[TXRUSS2]

It sounds like you can get as far as entering the times... As far as calculating the time between, you could do this:

Create a query against the table that contains the numbers selected in the form. Then combine the numbers like this:

=[txtHour] & ":" & [txtMinute]

Then you can format that using Format([txtTime],'hh:nn')

The inputs would look like txtHour=3, txtMinute=5
Using =[txtHour] & ":" & [txtMinute] will give you 3:5
Finally, Format([txtTime],'hh:nn') will give you 03:05

That will give you the ability to calculate the time between two entries. I tried it in Access and it worked for me, but I had to play around with it for a while.

Good Luck!

 

[rollout369]

A simple way to do it is to create a separate drop down for the hour, minute, AM/PM. Then, in your ASP page, you would combine those three fields before entering them into the date field of your database. For example, in the ASP page:

strTime = Request.Form("hour") & ":" & Request.Form("minute") & " " & Request.Form("ampm")

Then just insert strTime into the time field.

=========================
rollout
=========================

 

[WWinter]

Why make the user insert the time? Give the date/time field a default value, so when the user appends or saves the data it suffs the time in.