Find & Replace not working on Access 97 - some machines only 1

[amwmsh]

I have an Access 97 Database on a shared network drive. Generally 4 people access this database and make changes.

One of these machines works with the find and replace action. What the user does: 1-open database and table 2- filter records by date 3-find and replace to replace old date with date checks are posted 4-unfilter records to return data to table.

Other users: Same procedure but when they do find and replace it says no matching records found even when we are looking right at the record. The find and replace works in other columns just not this particular date column.

Also this column is date/time formatted with an input mask of 99/99/00. The user who works the date displays as 03/13/03 on her machine. On the other machines it displays as 03/13/2003 or 3/13/2003. I don't know if this has something to do with why it doesn't find the date when we try to do find replace but since this file resides on the network shouldn't it display (input mask/format/etc.) the same no matter which user opens it. I just figure it must have something to do with this formatting which is why FIND will not find the date to replace it.

Any help would be appreciated...
Amanda

 

[AccessNerd]

As to the date format differences between machines, the date display is controlled by the Windows Regional Settings not Access. Go to Control Panel/Regional Settings/Date. There are settings for Short Date and Long Date. Make sure all PC are set the same.

I'm not sure if the Regional Settings are causing the problem with Find and Replace. Make them all the same and try again.

 

[amwmsh]

To AccessNerd(Programmer) thanks so much for the info regarding the date format under the regional settings. I checked that and the one user who was working had one format for short date while the other users had different formats. Once I changed their short date format to match hers then the Find & Replace worked like a charm.

I can't believe it was that simple. When I was changing my user was telling me that couldn't be all there was to it until he saw it in action.

I appreciate your help. You helped me keep some users happy for at least another day. Thanks.