If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Popup Calender
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 |
#2
|
|||
|
|||
Popup Calender
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. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Leo" wrote in message ... 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 |
#3
|
|||
|
|||
Popup Calender
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 Browne wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#4
|
|||
|
|||
Popup Calender
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "HNIM2010 via AccessMonster.com" u59744@uwe wrote in message news:a7f8f7b44f196@uwe... 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 Browne wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
#5
|
|||
|
|||
Popup Calender
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 Allen Browne wrote: 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] Thanking you in advance Leo -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|