Time Picker

[sahil]

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?

 

[llkhoutx]

You've got to contruct it.

 

[sahil]

Thanks,, but how do I construct it?

 

[Oldsoftboss]

Why re-create the wheel.

Dave

 

[Chimp8471]

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

 

[sahil]

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

 

[___]

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

 

[sahil]

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]

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]

Since posting this thread, I have "changed calendars" (you old tart)

I now use this one (to avoid the exact problem you mention)

http://www.access-programmers.co.uk/forums/showthread.php?t=85918

Dave

 

[Oldsoftboss]

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]

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

 

[Niniel]

In case somebody looks for something like this again - here's a little time picker tool I made based on the form posted by ___, and a pop-up calender by Allen Browne http://allenbrowne.com/ser-51.html

 

[Steve_T]

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.

 

[Oldsoftboss]

Gee's that was over 4 years ago

Dave

 

[Steve_T]

Gee's that was over 4 years ago

Dave

Thank you kind sir.