By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 975 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Auto Update Month in Calendar

P: n/a
I am currently using the Active X Calendar object in a form to select
the dates. The problem I am having is when the month changes the
calendar continues to display the previous month. How can I set this
to change automatically? Access 2000.
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi Rudy,

Set the value of the calendar to today's date in the Form Load event
Private Sub Form_Load()
MyCal.Value = Date

End Sub

Don

"rudy" <rc******@satx.rr.com> wrote in message
news:8b*************************@posting.google.co m...
I am currently using the Active X Calendar object in a form to select
the dates. The problem I am having is when the month changes the
calendar continues to display the previous month. How can I set this
to change automatically? Access 2000.

Nov 12 '05 #2

P: n/a
I am new to adding code, can you tell me if the code you provided is
simply copied or additional references to form names or object names
need to be included? I copied the code as indicated and I get an
error that highlights the 'MyCal.Value = Date' section.

Thanks,
Rudy

"Don Leverton" <le****************@telusplanet.net> wrote in message news:<4qWqc.3964$g71.3524@clgrps13>...
Hi Rudy,

Set the value of the calendar to today's date in the Form Load event
Private Sub Form_Load()
MyCal.Value = Date

End Sub

Don

"rudy" <rc******@satx.rr.com> wrote in message
news:8b*************************@posting.google.co m...
I am currently using the Active X Calendar object in a form to select
the dates. The problem I am having is when the month changes the
calendar continues to display the previous month. How can I set this
to change automatically? Access 2000.

Nov 12 '05 #3

P: n/a
Hi Rudy,

You'll have to either rename your ActiveX Calendar from the default (usually
something like "ActiveXCtl3") to "MyCal" or substitute that default name of
the calendar into the code.

i.e.
Private Sub Form_Load()
ActiveXCtl3.Value = Date

End Sub

"rudy" <rc******@satx.rr.com> wrote in message
news:8b**************************@posting.google.c om...
I am new to adding code, can you tell me if the code you provided is
simply copied or additional references to form names or object names
need to be included? I copied the code as indicated and I get an
error that highlights the 'MyCal.Value = Date' section.

Thanks,
Rudy

"Don Leverton" <le****************@telusplanet.net> wrote in message

news:<4qWqc.3964$g71.3524@clgrps13>...
Hi Rudy,

Set the value of the calendar to today's date in the Form Load event
Private Sub Form_Load()
MyCal.Value = Date

End Sub

Don

"rudy" <rc******@satx.rr.com> wrote in message
news:8b*************************@posting.google.co m...
I am currently using the Active X Calendar object in a form to select
the dates. The problem I am having is when the month changes the
calendar continues to display the previous month. How can I set this
to change automatically? Access 2000.

Nov 12 '05 #4

P: n/a
Thanks alot Don, it worked!

"Don Leverton" <le****************@telusplanet.net> wrote in message news:<Je7rc.850$gx1.830@clgrps12>...
Hi Rudy,

You'll have to either rename your ActiveX Calendar from the default (usually
something like "ActiveXCtl3") to "MyCal" or substitute that default name of
the calendar into the code.

i.e.
Private Sub Form_Load()
ActiveXCtl3.Value = Date

End Sub

"rudy" <rc******@satx.rr.com> wrote in message
news:8b**************************@posting.google.c om...
I am new to adding code, can you tell me if the code you provided is
simply copied or additional references to form names or object names
need to be included? I copied the code as indicated and I get an
error that highlights the 'MyCal.Value = Date' section.

Thanks,
Rudy

"Don Leverton" <le****************@telusplanet.net> wrote in message

news:<4qWqc.3964$g71.3524@clgrps13>...
Hi Rudy,

Set the value of the calendar to today's date in the Form Load event
Private Sub Form_Load()
MyCal.Value = Date

End Sub

Don

"rudy" <rc******@satx.rr.com> wrote in message
news:8b*************************@posting.google.co m...
> I am currently using the Active X Calendar object in a form to select
> the dates. The problem I am having is when the month changes the
> calendar continues to display the previous month. How can I set this
> to change automatically? Access 2000.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.