Popup Calender

  • Thread starter Thread starter Leo
  • Start date Start date
L

Leo

I am trying to incorporate a pop up calender from Allen Browne. Downloaded
the file (for Access 2000 and later) from the address below and unzipped it.
http://allenbrowne.com/ser-51.html
I followed the instructions and also pasted the calendar button, changed
the name of the field to [VisitDate] in the onclick event as required. The
[VisitDate] is a date field and formatted for short date.

But when I click the button a type mismatch error occurs. The [VisitDate]
has some after update events already written. Is that the problem? Should I
paste the button first and then re-write the after update events?

Any help will be greatly appreciated.
Thanking you in advance
Leo
 
The bottom of the page at:
http://allenbrowne.com/ser-51.html
has a comment about the type mismatch error.
It indicates that your text box has a non-date value in it.

If you have other code you want to use in the same event, you can use:
Call CalendarFor(Me.[VisitDate], "Select the visit date")
in your existing event procedure.
 
Did you blank the text box by setting its value to a zero-length string?
That's not a valid date. Set it to Null instead.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


HNIM2010 via AccessMonster.com said:
Hi Allen,
Thanks for your response.
I say the notes at the bottom of the page earlier. But the VisitDate is
blank
prior to I click the button to update it. And it is a date field formatted
for short date. I dont have to enter anything more than what is there in
the
onclick event of the button. But there are some after update events for
the
field [VisitDate].

Perhaps there is something wrong the way I imported the module. After the
module is imported am I supposed to do anything like Debug etc?

Thanks
HNIM2010



Allen said:
The bottom of the page at:
http://allenbrowne.com/ser-51.html
has a comment about the type mismatch error.
It indicates that your text box has a non-date value in it.

If you have other code you want to use in the same event, you can use:
Call CalendarFor(Me.[VisitDate], "Select the visit date")
in your existing event procedure.
I am trying to incorporate a pop up calender from Allen Browne.
Downloaded
the file (for Access 2000 and later) from the address below and unzipped
Click to expand...
[quoted text clipped - 12 lines]
Thanking you in advance
Leo
Click to expand...
Click to expand...
Click to expand...
 
Back
Top