ActiveX Calendar Control (Access 2000)

Topic

New Reply

I am attaching a sample db…if someone could take a look at it, I would appreciate it.

The problem….if I open frmSelectDate normally, it works just fine. However, if I open frmSelectDate using frmCode and Selecting either Employee or Benefits, I can’t make a DAY selection from the calendar.

FYI…I have OpenArgs in the OnOpen event of frmSelectDate.

I would sure appreciate it if someone could provide the solution.

Hair is almost gone….lol

Thanks

Reply | Quote

Replies

Roberta,

In you code you open your form Readonly.
Remove Readonly and you can select a day.

Hope this is what you want.

Reply | Quote

Francois,

I checked the properties for ReadOnly and they are Enabled=yes and Locked=No.

I also checked to see if they were changing if the form was opened via a control button, but they are still correct.

That doesn’t seem to be the problem.

Any other suggestion?
Thanks

Reply | Quote

Roberta,

In the code of the form frmCode for Command7_Click event you have a line :
DoCmd.OpenForm “frmSelectDate”, acNormal, , , acReadOnly, , “Employee”
and for Command8_Click event :
DoCmd.OpenForm “frmSelectDate”, acNormal, , , acReadOnly, , “EmployeeBenefits”

These two lines should be :
for Command7_Click
DoCmd.OpenForm “frmSelectDate”, acNormal, , , , , “Employee”
and for Command8_Click
DoCmd.OpenForm “frmSelectDate”, acNormal, , , , , “EmployeeBenefits”

If you are not familiar with VBA, open you frmCode in design mode and press ALT+F11, you will see the code and be able to modify it.

Reply | Quote

Francois,

Thank you so much…duh…I feel soooooo dumb…It works perfectly now.

Reply | Quote