Can I allow a user to select the date/time from... e.g. clock face??

[neemi]

Access 2000 vba

I am writing an application for a college where the user will need to input Exam start times and end times into a form. At the moment I have used an input mask on the fields for when the user enters the times. I was wondering how it will be possible to write some clever code where the user can maybe click on a button which will bring up something like a clock face and they can select the time, which would then automatically be put into the relevant textbox.

Also when the user selects the date of the exam, is it possible to bring up a calender where the user can select the date in a similar way.

The effect I want to possibly achieve is that seen on many web pages. or even when we select dates on windows.

Any advice or comments will be appreciated.

Cheers,

Neemi

 

[RobBroekhuis]

I don't know about the clock. For the calendar, right-click on your controls toolbox in VBE (while editing a userform object), and choose "more controls", then select "Calendar" from the list of controls. You'll then have access to the familiar calendar control. It takes up a lot of space on your form, though, so be careful how you use it.
Rob

 

[neemi]

I can't find it... Don't know I am going to the right part.

Where exactly am I right clicking. In my form in design view? In the module?

 

[RobBroekhuis]

In the controls toolbox (where you pick up your buttons, textboxes, etc to put them on your userform). It's usually a little floating window whenever you have the userform object selected. If it's not there, use View - Toolbox to display it.
Rob

 

[neemi]

Thats great cheers...

But how would I store the value of what is selected here in another field.?

I want to allow the user to use the calender and press ok which I will add on the form. And the date selected from the calender will be stored in a coressponding text box>>

Cheers in advance.

Neemi

 

[likelylad]

You probably haven't the active x control actived.
On Access 2000
In the Form design view
Goto Insert/ActiveX Control.
Select Calendar Control 9.0

This will insert a calendar in your form

 

[neemi]

Its OK....

Thanks for all your help...

I've sussed it out know

Cheers again

Neemi