Calendar in a form to display current day and date

[jh]

I have a switchboard that I would like to have a calendar
with the current month and date display on it. I'm able
to put the calendar on it, but the date will never
change. It always stays on the date that I created the
calendar.

I created the calendar from the Toolbox Calendar Control
9.0.

Is there a way to have the calendar display the current
month and date when I open the switchboard? I also would
like to be able to move the arrows and go to other months
also.

Thanks in advance for any help.

 

[PC Datasheet]

Jane,

Put the following code in the OnActivate event of your switchboard form:

Me!NameOfClaendarControl.Value = Date()

Also, FYI, if you want the current date on your form, add a textbox and put this
in the control source property:

= Date()

The textbox will contain the current date.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel