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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problem using Allen Browne Calendar



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 10:52 PM posted to microsoft.public.access
Judi
external usenet poster
 
Posts: 135
Default Problem using Allen Browne Calendar

Hi, I am using Access 2003.

I am trying to use Allen Browne's amazing pop-up calendar to enter dates
into my forms. I have done all I could according to the instructions. I have
imported the form and the module and copied the button to my form.

When I click on the button, it opens the calendar and all appears to be
working, but when I select a date and click OK, there is no change in the
textbox which I am using to keep my date info.

The textbox in question is selected and the default date (today's date) is
highlighted, but no changes are made.

Can anyone please tell me what I am doing wrong?

Here is the code in the On Click for the button:
=CalendarFor([txtPODate],"Select PO Date")

txtPODate is the name of the destination textbox.

Thank you for your help.
  #2  
Old May 28th, 2010, 05:43 AM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Problem using Allen Browne Calendar

I know Allen's Calendar works, but I have yet to use it. If you import this
one into your application along with the accompanying module, all you need
to do it add this to the Double-Click event of any text box that you want to
receive a date:

=popCalendar()

simple enough? Here's the link:

http://www.datastrat.com/Download/Calendar2K.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley


"Judi" wrote in message
...
Hi, I am using Access 2003.

I am trying to use Allen Browne's amazing pop-up calendar to enter dates
into my forms. I have done all I could according to the instructions. I
have
imported the form and the module and copied the button to my form.

When I click on the button, it opens the calendar and all appears to be
working, but when I select a date and click OK, there is no change in the
textbox which I am using to keep my date info.

The textbox in question is selected and the default date (today's date) is
highlighted, but no changes are made.

Can anyone please tell me what I am doing wrong?

Here is the code in the On Click for the button:
=CalendarFor([txtPODate],"Select PO Date")

txtPODate is the name of the destination textbox.

Thank you for your help.



 




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 09:24 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.