Allen Browne Popup Calendar - Calendar Button Problem

[Guest]

I downloadedd the above named calendar, and because I could not figure out
where the calendar button was, on my form I used a command button>open
form>frmCalendar instead.
Q:Since I need to put this on a form for the office staff, does anyone
forsee any problems with the way I have done this?
I did import the form and module as instructed. The calendar2k appears as
a.mdb file. Is that correct?
Help appreciated.

 

[Allen Browne]

A command button is find for opening the calendar.
That's what the demo database uses. It is an ordinary mdb.

 

[Guest]

After I pop up the calendar I have a problem when I click on the arrow to
view the next month. It skips to 3 months away. Can this be solved?
Also, the staff at work will use the calendar to view it rather than a
start/stop action. For example, when one of the attorneys is on the phone
and needs to look at a calendar to find out what day a date falls on.
How would I code it? =Calendar????
[I found out how to copy and past the button, but get an error message
because I don't know how to code it. Also, I only have one calendar not two
samples.
Help appreciated.

 

[Guest]

P.S. to previous reply:
I copied the frmCalenar onto my form and the calendar is able to click to
the next month without a problem.
Should I do something with the code or is it ok as is?
Love the calendar.

 

[Allen Browne]

Good, you have it working.

As set up, the calendar does expect a text box to pass a value back to.
Perhaps you could use an unbound text box with properties:
Name txtDummy
Format Short Date
Visible No

You could then call the calendar as:
=CalendarFor([txtDummy], "Select a date.")

 

[Guest]

Every so often when I click on the calendar button and click on the arrow to
proceed to the next month it skips to two or three months away. I don't mind
for myself because I just click back and forth a couple of times for it to
work, but I am installing this for work and the staff gets frustrated if the
p/c does not work properly. If they don't get the correct response they
start clicking like crazy which often makes matters worse.
Also, about your suggestion am I to access the properties of the calendar
button to make changes: format, name etc.?
Thanks again for your help.
--
Joan

Good, you have it working.

As set up, the calendar does expect a text box to pass a value back to.
Perhaps you could use an unbound text box with properties:
Name txtDummy
Format Short Date
Visible No

You could then call the calendar as:
=CalendarFor([txtDummy], "Select a date.")

 

[Allen Browne]

Have not seen it behave like that, Joan. Could be the mouse perhaps? Or
maybe you have the button's AutoRepeat property set to Yes?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Every so often when I click on the calendar button and click on the arrow
to
proceed to the next month it skips to two or three months away. I don't
mind
for myself because I just click back and forth a couple of times for it to
work, but I am installing this for work and the staff gets frustrated if
the
p/c does not work properly. If they don't get the correct response they
start clicking like crazy which often makes matters worse.
Also, about your suggestion am I to access the properties of the calendar
button to make changes: format, name etc.?
Thanks again for your help.
--
Joan

Good, you have it working.

As set up, the calendar does expect a text box to pass a value back to.
Perhaps you could use an unbound text box with properties:
Name txtDummy
Format Short Date
Visible No

You could then call the calendar as:
=CalendarFor([txtDummy], "Select a date.")

P.S. to previous reply:
I copied the frmCalenar onto my form and the calendar is able to click
to
the next month without a problem.
Should I do something with the code or is it ok as is?
Love the calendar.
--
Joan


:

A command button is find for opening the calendar.
That's what the demo database uses. It is an ordinary mdb.

I downloadedd the above named calendar, and because I could not
figure
out
where the calendar button was, on my form I used a command
button>open
form>frmCalendar instead.
Q:Since I need to put this on a form for the office staff, does
anyone
forsee any problems with the way I have done this?
I did import the form and module as instructed. The calendar2k
appears
as
a.mdb file. Is that correct?
Help appreciated.