Date Control

  • Thread starter Thread starter Chris D
  • Start date Start date
C

Chris D

I have a text box that holds data for a date field. I would like to use the
Date Callender Control so the user can pick a date but since I new to Access
I don't understand how the object is attached to a control source and thus I
can not apply the results to a text box or to a field in the form.

How do I change the control source or how to I apply the selection to the
record.
 
Chris D said:
I have a text box that holds data for a date field. I would like to use the
Date Callender Control so the user can pick a date but since I new to
Access
I don't understand how the object is attached to a control source and thus
I
can not apply the results to a text box or to a field in the form.

How do I change the control source or how to I apply the selection to the
record.
Click to expand...

A sample file that shows how to do it with an Access form is at:

http://www.datastrat.com/Download/Calendar2K.zip

One using an ActiveX control is at:

http://www.datastrat.com/Download/XCalendar2K.zip

and the one in Access 2007 is built in to a date field.
 
ActiveX controls can be prone to problems with versioning. Your application
may work fine with version 8.341, but when some other application installs
version 8.353, your application can stop working. And the worst part is that
when there is a versioning problem, it can affect more than just the part of
the application that uses the calendar: regular VBA functions such as Left
and Date can stop working!
 
Thanks again. I went ith the "Microsoft Date and Time Picker 6.0"

It's int he ActiveX list but it's microsoft so I don't know how that applies
to your concern about versioning. Any concerns here?
 
Chris D said:
Thanks again. I went ith the "Microsoft Date and Time Picker 6.0"

It's int he ActiveX list but it's microsoft so I don't know how that
applies
to your concern about versioning. Any concerns here?
Click to expand...

Yes, version can be a problem no matter whose control you are using. I do
sometimes use ActiveX controls so let me give you a tip that has worked well
for me. Make a copy of the control you are using and put it in the same
folder as the database. Register it there and replace the control in your
database with the one that you've just registered. If you do that, you
maintain your own copy, and it should work as long as the OS system supports
COM. I've had some working for the last 9 years.
 
Back
Top