Popup Calender

[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

 

[Allen Browne]

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.

 

[HNIM2010 via AccessMonster.com]

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

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

[quoted text clipped - 12 lines]

Thanking you in advance
Leo

 

[Allen Browne]

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.

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

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

[quoted text clipped - 12 lines]

Thanking you in advance
Leo

 

[HNIM2010 via AccessMonster.com]

Thanks again Allen.
No did not blank it with zero string.
But I realized my mistake. I was typing [VisitDate] ...where the data will be
stored instead of typing the name of the text box which was Text68. Once I
corrected the mistake it is working well.

Once again
Thanking you
HNIM2010

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.

Hi Allen,
Thanks for your response.

[quoted text clipped - 28 lines]