Time picker

[Guest]

I am pulling my hair out looking for a time (not date) picker to add to a
form in Access. My one hope - Oscorp - seems to resist registration on my
machine. I would love something free, but can pay for a product depending on
licensing. A pop up control would be ideal.

 

[Guest]

Hi,
have a look at this sample:
http://www.utteraccess.com/forums/s...e=m&olderval=&oldertype=#Post413286&bodyprev=
It allows you to either chose date and time or just time or just the date!
HTH
Good luck

 

[Jeff Conrad]

http://www.referee-assistant.com/calcontrol.htm

Look for the ReturnDate MDB file in the samples

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Guest]

Oliver, Thanks for your quick reply. I downloaded the form, but I do not see
any way to modify how the calendar is shown. What am I missing?

 

[Guest]

It's a little large, but i think it will be just the ticket. Thanks for your
help Jeff.

Regards,
Dan

 

[Jeff Conrad]

No problem, glad to help.
You could manually resize and move the controls to make it smaller.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Guest]

Still need help Jeff. I can copy over the form alright, but i am not sure
how to tie the right code to the command button. Any ideas?

 

[Jeff Conrad]

Hi Dan,

Follow these steps:

1. Import the form frmReturnTime *and* module modReturnDateTime
into your database. Immediately compile your code.

2. Open the form you wish to enter a time in Design View.

3. Put a small command button called cmdTime next to the text
box that will hold the time. I'll assume the text box is called txtTime.

4. Code the command button's click event like so:

Private Sub cmdTime_Click()
Me.txtTime = ReturnTime(Nz(Me.txtTime, ""))
End Sub

5. Compile your code, save and close the form.

Now test. Open the form and click on the command button.
Selecting a time will fill in the text box after you hit OK.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: