add a pop-up calendar & time together?? (1 Viewer)

[alhabkk]

Hi. Does anybody know how to add a pop-up calendar & time (see attachment) to a form so that when I enter a date & a time, I can also click on some icon for a calendar to pop-up?

Any help is appreciated. Thanks!

 

[AlexHedley]

In newer versions of Access you can make a textbox show a DateTime picker by formatting as a Date or binding it to a DateTime Field and the little Date Picker control will show up.

Or add

Private Sub TEXTBOXNAME_GotFocus()
DoCmd.RunCommand acCmdShowDatePicker
End Sub


If you wanting to have full control over the DateTime picker you could look into using the following:
http://www.599cd.com/templates/access/calendar-control/?key=AlexForum

 

[alhabkk]

In newer versions of Access you can make a textbox show a DateTime picker by formatting as a Date or binding it to a DateTime Field and the little Date Picker control will show up.

Or add

Private Sub TEXTBOXNAME_GotFocus()
DoCmd.RunCommand acCmdShowDatePicker
End Sub


If you wanting to have full control over the DateTime picker you could look into using the following:
http://www.599cd.com/templates/access/calendar-control/?key=AlexForum

This is what i mean..I have a wonderful Calendar function that pops-up when I add a date field to a form. Is there a similar Clock function that I can use? I would like to automate this to make it an easier entry.
note: im using access2007

 

[AlexHedley]

Another useful Seminar might be:
http://www.599cd.com/site/courselist/seminars/access-calendar/?key=AlexForum

There is a "Microsoft Access ActiveX Calendar control." that works in 2007 but not later.

You can change "Format =2 dtpTime"

You could also add a textbox and set it to NOW() so it has the Date and Time then create buttons to make the hours/mins/secs increase/decrease.

 

[alhabkk]

I’m looking for easier way