Set Calendar To Today

[George]

I inserted the MSCAL.Calendar.7 in my form and
I am trying to get it to always open to todays date.
How can I make this happen ?

Thanks - George

 

[Jeff Conrad]

Assuming you are talking about the ActiveX Calendar control
that ships with Access, then just add this one line of code to
the Form's Load event:

Private Sub Form_Load()
Me.MyCalendarNameHere.Today
End Sub

Just insert your actual control name where it says,
"MyCalendarNameHere"

Compile the code, save and close the form.
When you open the form the calendar will
default to the current date.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message:

 

[George]

Thanks - That works

Sorry to post twice, received error message post didn't go thru.

George

 

[Jeff Conrad]

You're welcome George, glad to help.
Good luck with your projects.

No worries on the double post, it happens a lot with the web interface.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message: