A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Popup Calender



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 02:30 AM posted to microsoft.public.access.queries
leo
external usenet poster
 
Posts: 236
Default 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  
Old May 14th, 2010, 04:06 AM posted to microsoft.public.access.queries
Allen Browne
external usenet poster
 
Posts: 11,706
Default 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  
Old May 14th, 2010, 04:26 AM posted to microsoft.public.access.queries
HNIM2010 via AccessMonster.com
external usenet poster
 
Posts: 2
Default 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  
Old May 14th, 2010, 06:46 AM posted to microsoft.public.access.queries
Allen Browne
external usenet poster
 
Posts: 11,706
Default 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  
Old May 20th, 2010, 03:06 AM posted to microsoft.public.access.queries
HNIM2010 via AccessMonster.com
external usenet poster
 
Posts: 2
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.