drop down calander to fill in date

[Ralph Gregory]

Anybody tell me how to fill in a date in a combobox by picking it from a dropdown calendar?

 

[Parra]

I think that you can add the =date() formula as teh default value in the properties of the combo box.

You do want the current date?

Parra

 

[Ralph Gregory]

Thanks Parra,
I just tried that but it fills in the combo box with todays date. What I was after is an actual calendar which you can move around with the mouse to choose a date, click on and the box is filled. in excel there is an active x calendar that you can get to show on top of the spreadsheet but I dont Know how to get a date out of it, and I dont know if theres something similar in Access.

 

[Waldi]

You can use ActiveX function "Date and Time Picker Control " however, this has a major drawback if you are creating multiuser application as ActiveX is flaky but it works fine for stand alone apps.. To do that you have to make sure that you have ActiveX Date and Time Picker registered under ActiveX controls (if you do not have it you have to find file on the net by serching for Microsoft Date and Time ... - file type should be .ocx) so select from Inset menu ActiveX Contols and scroll down to Date and Tme Picker and here you go.
There are some other shareware calendar modules that you can implement right into your application and they work great but require little bit of programming.

 

[Ralph Gregory]

You can use ActiveX function "Date and Time Picker Control " however, this has a major drawback if you are creating multiuser application as ActiveX is flaky but it works fine for stand alone apps.. To do that you have to make sure that you have ActiveX Date and Time Picker registered under ActiveX controls (if you do not have it you have to find file on the net by serching for Microsoft Date and Time ... - file type should be .ocx) so select from Inset menu ActiveX Contols and scroll down to Date and Tme Picker and here you go.
There are some other shareware calendar modules that you can implement right into your application and they work great but require little bit of programming.

Thanks,
I tried that over the weekend and the calander is nice but I still couldn't get the result into my field in the database. I'm probably missing something fairly ovious here. I have a job list and the 4th field is DoneDate where I wanted a drop down calendar 5th field is interval and 6th field is DueDate (worked out by adding interval to DoneDate. I've put the calendar on a form but cant link it with DoneDate. I can work out the interval bit once ive populated the field

 

[Tanis]

You need a command button on your form. Behind the button put this code.

DoneDate = YourActiveXControlName.Value

 

[Ralph Gregory]

that looks simple enough, I'll work on it
Thanks once again for your help

 

[bat17]

You should be able to do it with the exit event of the control
Me.DoneDate = YourCalendar
But this will not give you an opertunity to cancel out!

Peter

 

[bat17]

There is a demo database using calendars on the Access Web site that you might find intresting

Peter