Do we have an exclusive Time Picker only, I am using the Calendar control for selecting date, Is there any similar control which will help the user to select a particular time instead of manually entering it?
I have applyed your time picker which works really well when used on the stand alone form but when I try to use it as a subform it gives me an error that it can't find the form "frmScottBottleService"
Here is the code:
Private Sub cmdOk_Click()
On Error GoTo Err_CmdOK_Click
Forms!frmScottBottleService!AirfilTime.Value = Me.txtTime.Value
DoCmd.Close acForm, "frmTime"
Thanks for the help (you young tart)
By looking through Allen Brownes site there was a tip about referring to controls on sub forms so what I was missing was the ref to the sub form so the line should have looked like this.
I have just come across your DateandTimePicker posting which is exactly what i need. I have imported the form to my database but i am having problems asigning the calendar to a button i have on the form and also once the date and time is selected i cant get the Textbox to update with the selected time and date from your posted calendar. I am new to Access and i understand this is most likely me being stupid but i wonder if you could help? I have attached a sample of my Database so you can see what i mean.