Re: MonthCalendar

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 03/22/05 

Date: Mon, 21 Mar 2005 21:06:37 -0600

Did you follow the "Step by step installation instructions" at this link?

http://www.lebans.com/monthcalendar.htm#Step%20by%20Step%20instructions%20for%20how%20to%20use%20the%20MonthCalendar%20in%20your%20own%20applications. 

-- 
Wayne Morgan
MS Access MVP
"Jane" <Jane@discussions.microsoft.com> wrote in message 
news:791BCE53-A2EC-4368-9A26-DDADA09CEEC1@microsoft.com...
> Thanks for your help - although I was able to get rid of the issues below, 
> it
> still
> does nothing when I double click on my control box. No Monthcalendar pops 
> up.
> I have an "event procedure"  on "dbl click"  I have an "event procedure" 
> on
> "before update"  both events lead to code I copied and pasted from the 
> Lebans
> site.
> I am sorry that I just might be biting off more than I can chew but I 
> wanted
> to give it a whirl and see if I could be a hero!  Any suggestions on where 
> to
> check would be
> appreciated!
>
> "Wayne Morgan" wrote:
>
>> I'm guessing that you wrote the code before you renamed the control. Open
>> the code for the form and look for the sub that uses the old name for the
>> control:
>>
>> Private Sub OldControlName_DblClick
>>
>> and change OldControlName to txtSelectDate. Next, make sure that on the
>> Properties ***, Event tab for the control, that the box next to Double
>> Click says [Event Procedure].
>>
>> -- 
>> Wayne Morgan
>> MS Access MVP
>>
>>
>> "Jane" <Jane@discussions.microsoft.com> wrote in message
>> news:20CB6B0E-0249-492F-A3CF-BB7A0D308FE7@microsoft.com...
>> >I am attempting to use the Monthcalendar and have hit a snag.  I am not 
>> >a
>> >VB
>> > coder but thought I could handle this since the instructions are so 
>> > good.
>> >
>> > This is the message I received after following the instructions and
>> > attempting to view the month calendar by double clicking in the text 
>> > box.
>> > I renamed my control "txtselectdate" to fit Jeff Conrad's as I thought 
>> > it
>> > would be easier.
>> >
>> > "microsoft Access can't find macro 'Private Sub txtselectdate_dblclick
>> > (cancel as Integer)
>> > Dim blRet As Boolean
>> > Dim dtStart As Date dtEnd As date
>> > dtStart = Nz(me'
>> >
>> > any help would be greatly appreciated
>>
>>
>>