Date Picker 1

[AmritPaulSingh]

I need to create a control (probably a text box) with the calender popping up on it getting focus, something like a dat picker. Any suggestions?

 

[LarryDavidow]

I found this a couple of days ago. Haven't actually tried using it yet...

http://www.referee-assistant.com/calcontrol.htm

Let me know how you go...

Larry

 

[gusbrunston]

[tt]
Hi:

There is a Microsoft ActiveX calendar control that works for this. Add the control to your form, bind it to the appropriate date field, and your user can pick the date from the calendar as opposed to entering it from the keyboard.

Is that what you're looking for? Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[gusbrunston]

[tt]
Access 2000 also has a date picker control. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[sedgely]

I'm also using the Calendar control, on various forms.
I have it set so that when i click a button on a form a modal form pops up with the calendar control on it. My 'problem' is that i have had to create a number of these 'pop up' forms - one for each date control on the main form.
I would really like to be able to use the one calendar form that changes it's record source and control source depending on where it is called from.
Does anyone know if this is possible??
Craig

 

[AmritPaulSingh]

Thanks for your help guys. I did find the date picker active x control.
I didn't try your code, Larry, but I am sure it would have worked. It was just much more than what I needed.
Thanks

 

[gusbrunston]

[tt]
Hi, Sedgley:

I use the calendar control with a command button that makes the control visible or not visible...that is, it toggles it on and off.

There's no need, the way I use it, to make a pop up form. The calendar itself pops up and off.

If you need more stuff, let me know. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]

 

[sedgely]

Thanks for that Gus
i did start off using the same way as you suggested, the only problem is how do i get the calendar control to change which field it populates??

Craig

 

[gusbrunston]

[tt]
Hi:

The date selected on the calendar will update whatever field the calendar control is bound to...

The form is bound to a query or a table, the calendar control property, Data=>Control Source, is a field from the query or table. e.g.,

Calendar, Data, Control Source = TransactionDate

I hope this is helpful. Gus Brunston An old PICKer, using Access2000
[tt]Want solutions you can understand?
Post understandable questions.[/tt]