DateTime Pick control

[Aniz Asaria]

I am novice to Access 2000 and am designing a DB. On the
Date field I would like to add Date/Time Pick control
(mscomct2.ocx). However, from the Toolbox menu I do not
have this control option. How do I add Date/Time Pick on
a field.

Also, when the end user starts the db, the switchboard
appears upon launch but I would like ot hide the designer
screen so that end users cannot make any changes to
tables, forms etc.

 

[Tony Toews]

I am novice to Access 2000 and am designing a DB. On the
Date field I would like to add Date/Time Pick control
(mscomct2.ocx). However, from the Toolbox menu I do not
have this control option. How do I add Date/Time Pick on
a field.

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month
Calendar derived directly from the Common Control DLL. There are
links to several downloadable calendar forms at my website. As these
are forms you can also do anything with them you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm