Time Picker (1 Viewer)

sahil

Registered User
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?
 

sahil

Registered User
Joined
Jan 12, 2004
Messages
19
Thanks,, but how do I construct it?
 

Chimp8471

Registered User
Joined
Mar 18, 2003
Messages
353
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:

sahil

Registered User
Joined
Jan 12, 2004
Messages
19
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
 

___

¯¯¯¯¯
Joined
Nov 27, 2003
Messages
595
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

sahil

Registered User
Joined
Jan 12, 2004
Messages
19
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
 

jneirinckx

Registered User
Joined
Feb 28, 2004
Messages
133
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
 

Oldsoftboss

AWF VIP
Joined
Oct 28, 2001
Messages
2,504
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
 

jneirinckx

Registered User
Joined
Feb 28, 2004
Messages
133
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
 

Steve_T

Registered User
Joined
Feb 6, 2008
Messages
96
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 (Users: 0, Guests: 1)

Top Bottom