Prev: #num!
Next: Query ask for parameter value?
From: Leo on 26 Apr 2010 23:40
Hi,

I posted the following more than 24 hrs ago. I know all the Microsoft MVPs
are volunteers. I am willing to wait for few more days.

But in the event that some of the MVPs have seen this post and think it is
not possible or advisable please let me know.

This is what was posted:
One of the control on the form is FldMon. It is a number field.
There is a calender on the form. It is ActiveX Control: Calender0
Class is MSCAL.Calender.7
I am using Access 2003 and the tables are Access 2000 format

Now when the user updates the field FldMon with a number (1 to 12) I want
the calender to switch the display to the corresponding month.

How do I go about this and what and where do I write the code?

Could someone please help?

Thanking in advance
Leo
From: PieterLinden via AccessMonster.com on 27 Apr 2010 00:17
Leo wrote:


> One of the control on the form is FldMon. It is a number field.
>There is a calender on the form. It is ActiveX Control: Calender0
>Class is MSCAL.Calender.7
>I am using Access 2003 and the tables are Access 2000 format
>
>Now when the user updates the field FldMon with a number (1 to 12) I want
>the calender to switch the display to the corresponding month.
>
>How do I go about this and what and where do I write the code?
>
>Could someone please help?
>
>Thanking in advance
>Leo

In the AfterUpdate event of your textbox.

Private Sub txtMonth_AfterUpdate()
Me.Calendar2.Month = Me.txtMonth

End Sub

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201004/1

 | 
Pages: 1
Prev: #num!
Next: Query ask for parameter value?