473,467 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Auto Update Month in Calendar

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
4 2294
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: bb | last post by:
any way to prevent displaying the previous and next months in the calendar control? i have tried just blanking the text out in the dayrender IsOtherMonth and also dynamically changing the...
1
by: John Davis | last post by:
I am writing a program that allows user to select the date in a calendar, and it will update the text fields automatically. I created 2 forms. The first form has 2 text fields (start date and...
34
by: prosoft | last post by:
When I use Dim myDTFI As DateTimeFormatInfo = New CultureInfo("he-IL", True).DateTimeFormat Dim strhmon1 As String = (myDTFI.GetMonthName(hmon1)) MsgBox(strhmon1) I get the local name of the...
4
by: Jason Chan | last post by:
How can I get the month and year a calendar control current displaying? My problem is I want to load a list of event to a calendar so that it display difference style if there a event for a day....
0
by: larry | last post by:
I am in the process of rewriting one of my first PHP scripts, an event calendar, and wanted to share the code that is the core of the new calendar. My current/previous calendar processed data...
6
by: Zeba | last post by:
Hi, I have a page with a calendar and two datalist items - one containing month values and the other, year values. Depending on the month/year value chosen ( in text/string format ) I should be...
7
by: ajaydesai | last post by:
I have JavaScript code to dispaly two month calendar days at a time, but i have a problem both month that disaplay at a time have same days (for example May and June has same days, June and July have...
5
by: =?Utf-8?B?bWFib25k?= | last post by:
Hi Using a month calendar control so that my user can select a start and end date for a range that will be used in a SQL query. Problem.....if user selects a date in one month and then scrolls...
2
by: sirdavethebrave | last post by:
Hi guys - I have written a form, and a stored procedure to update the said form. It really is as simple as that. A user can go into the form, update some fields and hit the update button to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.