Prev: test
Next: Multiple selection filter - any help appreciated
From: Judi on 27 May 2010 17:52
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.
From: Arvin Meyer [MVP] on 28 May 2010 00:43
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<><" <Judi(a)discussions.microsoft.com> wrote in message
news:9CFF3362-6264-4BA0-B195-9F2A3D3CA0A2(a)microsoft.com...
> 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.


 | 
Pages: 1
Prev: test
Next: Multiple selection filter - any help appreciated