Date Format Problems

  • Thread starter Thread starter Rich McMillan
  • Start date Start date
R

Rich McMillan

I've used MS Access for many years and have learned to
expect the unexpected. I recently built system for a
nonforprofit local company. The database was built in
Access 2000 on my home machine. When I transfered via CD
to my customer's machine all code and expressions using
the standard Date() format gets a unreconized error
message. The customer machine has the exact setup as mine.
(Windows 98/Office 2000 Professional). If I create a new
form within the database and use the Date() expression it
works fine. I can rebuild all the forms that use the
expression but would like to save the time. Ever run into
this one?
Any help would be much appreciated.

Thanks Rich
 
When I transfered via CD
to my customer's machine all code and expressions using
the standard Date() format gets a unreconized error
message.
Click to expand...

Do you mean the Date() *function*? or the date *formats*?

The most common reason for the Date() function to fail is missing
references. To cure this very common problem, open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

If it's a format property, please post some more information.
 
Rich said:
I've used MS Access for many years and have learned to
expect the unexpected. I recently built system for a
nonforprofit local company. The database was built in
Access 2000 on my home machine. When I transfered via CD
to my customer's machine all code and expressions using
the standard Date() format gets a unreconized error
message. The customer machine has the exact setup as mine.
(Windows 98/Office 2000 Professional). If I create a new
form within the database and use the Date() expression it
works fine. I can rebuild all the forms that use the
expression but would like to save the time. Ever run into
this one?
Any help would be much appreciated.

Thanks Rich
Click to expand...

I have never seen it do this, but having different regional data format
setting in the Windows control panel can cause some interesting problems.
 
Back
Top