Time Picker (1 Viewer)

sahil

Registered User.
Local time
Today, 14:06
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.
Local time
Today, 14:06
Joined
Jan 12, 2004
Messages
19
Thanks,, but how do I construct it?
 

Oldsoftboss

AWF VIP
Local time
Tomorrow, 01:06
Joined
Oct 28, 2001
Messages
2,504
Why re-create the wheel.

Dave
 

Attachments

  • datetimepicker.zip
    69.9 KB · Views: 568

Chimp8471

Registered User.
Local time
Today, 14:06
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.
Local time
Today, 14:06
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
 

___

¯¯¯¯¯
Local time
Today, 14:06
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

  • SelectTimeA2k.zip
    17 KB · Views: 483

sahil

Registered User.
Local time
Today, 14:06
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.
Local time
Today, 07:06
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
Local time
Tomorrow, 01:06
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.
Local time
Today, 07:06
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
 

Niniel

Registered User.
Local time
Today, 09:06
Joined
Sep 28, 2006
Messages
191
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
 

Attachments

  • Popup TimePicker.zip
    30.6 KB · Views: 310

Steve_T

Registered User.
Local time
Today, 14:06
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

  • Sample01.zip
    84.3 KB · Views: 168

Oldsoftboss

AWF VIP
Local time
Tomorrow, 01:06
Joined
Oct 28, 2001
Messages
2,504
Gee's that was over 4 years ago :eek:

Dave
 

Attachments

  • Sample02.zip
    70.4 KB · Views: 208

Users who are viewing this thread

Top Bottom