Calendar Control

[jereece]

I am using Access 2003. I have a form with two text fields that I have configured as "Short Date". I set up Calendar Control as a new popup form (frm_Calendar) and set up the date fields to popup the Calendar on double click. I have 2 problems.

1. The calendar does not want to default to today's date. I tried entering "=Date()" into the "Value" field of Calendar Control, but it removes that code after I click off of it. So how can I get Calendar Control to default to today's date?

2. When I double click on a calendar date, I want that date to be posted into the date field. How do I get it to do that? I looked at all the properties, but did not see a way to tell the date field to accept the calendar entry.

Thanks for your help.

Jim

 

[mhartman]

Hello:
The enclosed file may be a better solution. Try it!
'
Regards
Mark

 

[jereece]

Hello:
The enclosed file may be a better solution. Try it!
'
Regards
Mark

I exported the Calendar form and Module to my database, then called it from the date field like you did in your demo. It seems to work except when you single click on a calendar date, it does not highlight that date. It does in your demo, so I am not sure what the difference is.

Thanks,
Jim

 

[mhartman]

Hello

On the DoubleClick of your date control do you have the following entered?
'
=PopupCalendar(Screen.ActiveControl)
'
Regards
Mark

 

[jereece]

Hello

On the DoubleClick of your date control do you have the following entered?
'
=PopupCalendar(Screen.ActiveControl)
'
Regards
Mark

Yes and when I double click the date field, the calendar does pop up as it should. However in my project that I imported your calendar and modules, it does not highlight the date when clicked on by making it look sunken. Here's a link to an image capture of your calendar and your calendar in my project so you can see what I am talking about.

Other than this it seems to work fine. But I would like to solve this because users will think the click is not working properly.

Thanks for your help.

Jim

 

[mhartman]

Hello

Well, that is strange because I cannot duplicate the problem here. In the mean-time here is another link to calendar solutions:

http://home.bendbroadband.com/conradsystems/accessjunkie/calendars.html
'
These all work well.
Regards
Mark

 

[jereece]

Just to make sure, how do you recommend getting your calendar and module into my project? I know you can export it from yours or import it from mine. I tried import first but import did not see your calendar or module so I had to export from your file.

Also, other than the module and calendar form, is there anything else I should need?

One last thing, I am using Access 2003. Did you develop this in this version?

Thanks,
Jim