Calendar before 1900

[LCalaway]

Next problem-
I would like to use the Calendar Control on a database that requires dates
beginning with 1870 and ends after 1900, but my computer limits me to a
start date of January 1, 1900. The calendar must work for each month. The
database will be used on computers running Windows 2000 or XP. MSAccess
will be both 2000 and 2002-2003.

Is this possible?
Thank you
L Calaway

 

[Douglas J. Steele]

In what way are you being limited to a start date of Jan 1, 1900? Are you
getting an error message? How are you attempting to supply the date?

The Date datatype in Access is capable of storing dates as far back as Jan
1, 100 (although it's questionable why you'd want to!)

 

[LCalaway]

When I try to push the date backward, the very first date that the calendar
will show is January 1900. Isn't that a System limitation? I do not have
any other mechanism created to pass a different date to the calendar.

The purpose of this calendar is for a project where the data entry people
have to be able to see the day of the week for time beginning in 1870 and
coming forward. There are no date calculations that need to happen at this
time in this database.

 

[John Vinson]

The purpose of this calendar is for a project where the data entry people
have to be able to see the day of the week for time beginning in 1870 and
coming forward. There are no date calculations that need to happen at this
time in this database.

There are alternative ways to provide this information without using a
Calendar control; a very simple one would be to use a textbox bound to
the date field with a Format of "dddd" to show the day name.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[LCalaway]

The calendar has to be a complete view of the month and be capable of being
moved to the prior month in the case where today is January 5, 1890 (day of
the week unknown) and two weeks ago last Friday is some other date.

 

[John Vinson]

The calendar has to be a complete view of the month and be capable of being
moved to the prior month in the case where today is January 5, 1890 (day of
the week unknown) and two weeks ago last Friday is some other date.

<shrug> Ok, that's a different question. I answered the one that you
asked:

The purpose of this calendar is for a project where the data entry
people have to be able to see the day of the week for time beginning
in 1870 and coming forward. There are no date calculations that need
to happen at this time in this database.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Douglas J. Steele]

What calendar control are you using? I encounter no such limitation using
the one Stephen Lebans has at http://www.lebans.com/monthcalendar.htm

Tony Toews lists other calendar options at
http://www.granite.ab.ca/access/calendars.htm

 

[LCalaway]

Please excuse the lack of clarity in my question.
L Calaway

 

[LCalaway]

I tried the built-in control in MSAccess. Haven't checked Stephen Lebans
yet. Thank you for the clue.
L Calaway

 

[Stephen Lebans]

Hey Doug,
Ms Publishes the following date limitations of the MonthCalendar common
control:
Note

Microsoft Windows does not support dates prior to 1601. See FILETIME for
details.
The month-calendar control is based on the Gregorian calendar, which was
introduced in 1753. It will not calculate dates that are consistent with
the Julian calendar that was in use prior to 1753.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.