ACC97: QBE Grid and Property Sheet Save Date Values as String

Article translations Article translations
Article ID: 221478 - View products that this article applies to.
This article was previously published under Q221478
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.

Expand all | Collapse all

SYMPTOMS

When you specify a two-digit date as a criteria in the QBE grid or an object's property sheet, the way the date is resolved as a four-digit date may differ depending on the system settings of the computer on which you run the query.

CAUSE

Microsoft Access 97 stores criteria values from the QBE grid and property sheet settings as strings. These values are evaluated at run time. In the case of dates, your system settings will determine how a two-digit year will be resolved to a four-digit year.

RESOLUTION

To Resolve this problem, install the Microsoft Jet 3.51 Service Pack 2.

-or-

You can ensure that date criteria and property sheet settings are interpreted the same way on all computers by entering them with four-digit years instead of two-digit years. For example, type #1/1/1999# in the QBE Criteria row to ensure that the query will look for records on January 1, 1999, regardless of the system settings of the computer running the query.

STATUS

This problem was corrected in Microsoft Jet 3.51 Service Pack 2.

MORE INFORMATION

For additional information about Microsoft Jet 3.51 Service Pack 2, please see the following article in the Microsoft Knowledge Base:
172733 ACC97: Updated Version of Microsoft Jet 3.5 Available for Download
Microsoft Access resolves two-digit years into four-digit years differently, depending on the operating system you are using. If you are using Windows 95 or Windows NT 4.0, dates are converted based on the version of OLEAUT32.DLL that is installed on the computer.

When Access is run on a Windows 98 computer, the way dates are resolved into four-digit years is dependent on the date window that is set by the user on the Date tab of the Regional Settings dialog box. The following is a list of properties that you might enter a date into:

Table Properties

  • ValidationRule

Table Field Properties

  • DefaultValue
  • ValidationRule

Form Control Properties

  • ControlSource
  • DefaultValue
  • ValidationRule

Report Control Properties

  • ControlSource

Properties

Article ID: 221478 - Last Review: October 20, 2013 - Revision: 4.2
APPLIES TO
  • Microsoft Access 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbpending KB221478

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com