By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

MSCAL.Calendar.7

P: n/a
Good morning:

I created a data entry form that has been working well, and needed to
redesign it. The form is called, and now the first field to be filled
in is a date using the MSCAL.Calendar.7 ActiveXCtl. The calendar
presently displays the current date. The first time the user enters
the date on the form, the date resets to the current date, and the user
must re-enter the new date.

I also note that upon entering the form, the new record and delete
record buttons on the tool bar are greyed out, and remain so until the
date is entered the second time.

If I have another field take focus upon opening the form, a simple
macro (SendKeys) text will populate the text field, and tab to the
calendar allowing the user to enter the date correctly.
There has to be a better way to make the calendar take focus upon
opening the form, and allow the user to enter the date the first time.

Any assistance is greatly appreciated.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Personally, I find Stephen Lebans' calendar class a heck of a lot
better then the MSCAL ActiveX file. But that's me. (Nothing to
install!)

Anyways, the trick to having a "sticky" is to make a form level
variable. In the "Exit" event of the control you want to be "sticky",
set the form level variable to the control. In the Form's "Current"
event, check for "Me.NewRecord". If that's true, set the control to be
= form level variable.

Simple, cheap, works. What more could you ask for? (And it doesn't
use the problematical "SendKeys" function either!)

ji************@yahoo.com wrote:
Good morning:

I created a data entry form that has been working well, and needed to
redesign it. The form is called, and now the first field to be filled
in is a date using the MSCAL.Calendar.7 ActiveXCtl. The calendar
presently displays the current date. The first time the user enters
the date on the form, the date resets to the current date, and the user
must re-enter the new date.
I also note that upon entering the form, the new record and delete
record buttons on the tool bar are greyed out, and remain so until the
date is entered the second time.
If I have another field take focus upon opening the form, a simple
macro (SendKeys) text will populate the text field, and tab to the
calendar allowing the user to enter the date correctly.
There has to be a better way to make the calendar take focus upon
opening the form, and allow the user to enter the date the first time.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.