General discussion

Locked

Find & replace in Access not cooperating

By been there ·
I am not savy with programming or VBS

I am having a problem with Access 2000. This problem also occurred in Access 97.
I have a table and it works OK for a long time using the find and replace function.
Then either I change something or it changes on its own, because the find function
only works on the field selected rather than the whole table. I have select each of the
three choices Start of field, Whole field, and any part of field in the Find box. Alas no success.

So what I have done is copy my table and paste to an Excel Spreadsheet.
Then I start a NEW database and Import/ Export to/from Excel.
I then set up my form through the form wizard to complete the new table.
Then the find replace works great.

(This takestime and I want to avoid doing this in the future if possible.)

I have had the Computer support people
stymied by this, as we have done a complete reinstall of Access to no avail.

What the heck is going on? Do you have any solutions that mayshed
some light on this? Maybe it's a setting or property change?
Any help would be appreciated.

Thanks

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

Find & replace in Access not cooperating

by Karpi In reply to Find & replace in Access ...

Hello,

in the Search/replace dialog alter the entry for "Search in". This will be valid for the session. To make it persistent set Extras/Options/Edit-Search Find Options.


HTH
Karpi
<fluctuat nec mergitur>

Collapse -

Find & replace in Access not cooperating

by been there In reply to Find & replace in Access ...

I found the answer that if any field is indexed other than the key field this problem may arise.

Collapse -

Find & replace in Access not cooperating

by been there In reply to Find & replace in Access ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums