Microsoft KB Archive/296048

= ACC2002: Server Filter By Form Incorrectly Converts Date Criteria =

Article ID: 296048

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q296048



Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you enter a date range in a Server Filter by Form window, search for records, and then return to the Server Filter by Form window, date criteria is incorrectly converted to Microsoft Jet syntax.

For example, if you enter the date criteria > 1/1/2001 in the Server Filter by Form window, before applying the server filter, it correctly converts this to > '1/1/2001'.

However, after the server filter is applied, if you then try to enter a new date range, it is incorrectly converted to the Jet-based syntax of > #1/1/2001#.



RESOLUTION
Edit the ServerFilter property and change the number sign (#) to an apostrophe (') before you re-apply the server filter. Or, when you enter date criteria, enclose the dates in apostrophes.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Access.



Steps to Reproduce the Behavior
 Start Access. On the Help menu, point to Sample Databases, and then click Northwind Sample Access Project. Open the Employees form in Design View. Set the ServerFilterByForm property to Yes, and then close and save the form. Open the form. Note that the form is in server filter mode.</li> Enter the following filter for the Hire Date field

> 1/1/1993

and then press the TAB key.</li> Note that the date is correctly converted to > 1/1/1993.</li> Apply the server filter by clicking Apply Server Filter on the Filter menu.</li> Switch back to filter mode by pointing to Filter on the Records menu, and then clicking Server Filter By Form.</li> Enter the following filter for the Hire Date field

> 1/1/1992

and then press the TAB key.</li> Note that when you press the TAB key, the filter is incorrectly converted to the following:

>#1/1/1992#

</li></ol>

Additional query words: server filter date

Keywords: kbbug kbnofix KB296048

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.