Time Picker

sahil

Registered User.
Local time
Today, 09:27
Joined
Jan 12, 2004
Messages
19
Hi,

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?
 
Thanks,, but how do I construct it?
 
i was looking for the same kind of thing i think.

i stumbled acrodd this, there is a function on there that allows you to select a time and the figure is the transfered to a text box. don't know how good it is, but hope it helps.

the file was too large to add

so here is the link

Time Picker

Andy
 
Last edited:
Andy,

I could download the attachment from the link you had suggested, it looks perfect but is there anyway I can add this control to my form which has some other controls/fields.

Thanks
 
sahil said:
is there anyway I can add this control to my form which has some other controls/fields.
Try this. Much the same as the example from Oldsoftboss only a little simpler.

HTH
 

Attachments

Thanks all for your help and guidance, the attachments were helpful, and I was able to customize the time picker according to me requiremnents.

Thanks
 
Good afternoon,
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"

Exit_CmdOK_Click:
Exit Sub

Err_CmdOK_Click:
MsgBox Err.Description
Resume Exit_CmdOK_Click

End Sub

Any thoughts ?

Thanks
Jerry
 
On reflection the code

Forms!frmScottBottleService!AirfilTime.Value = Me.txtTime.Value

may be incorrect

Forms!frmScottBottleService.Form!AirfilTime.Value = Me.txtTime.Value

may be closer.

Dave
 
Problem Solved

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.


Forms!Assets!frmScottBottleService.Form!AirfilTime.Value = Me.txtTime.Value

Where Assets = Main form

frmScottBottleService = subform
AirfilTime = control

Thanks again for responding.

Cheers

Jerry
 
Why re-create the wheel.

Dave

Hello,
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.
 

Attachments

Users who are viewing this thread

Back
Top Bottom