Cannot utilize find and replace, but only on this PC

[sephiroth2906]

Howdy all! I have a database I am working with that, on other users PCs, I can utilize the Find and Replace tool, either by clicking on the icon or using ctrl-f, as one would expect.

However, on this PC, that function on the same database does not work. If I try and click a field and use the search box on the bottom of the form, I get the following message:



So, I suspect there is a setting on this computer's Access or Office options that is not chosen (or is) on other user's PCs, but for the life of me, I cannot locate what it would be. Any suggestions?

ps, If I get out of database entry mode, I can use the search function. However, I will be putting this database on some neophytes computers who know less than I do about Access, and I am no rocket scientist here. I really appreciate the help!

[Missinglinq]

...If I get out of database entry mode, I can use the search function...

If you'll check closer you'll find that this same thing will happen on all PCs! When you have the DataEntry Property set to 'Yes,' the only Records contained in that Recordset, which is to say the only Records that can searched, are those that have been entered during that session. Previously entered Records are not included.

The first question to be answered, here, is why do you have the Form's Data Entry Property set to 'Yes?' Despite its name, it doesn't have to be set to 'Yes' in order to enter Records. All it does is to only allow New Records to be entered.

If you absolutely have to have the Data Entry Property set to 'Yes,' you'll have to use a custom 'search' button and set Data Entry to 'No' before invoking the Find command.

But tell us why you're currently using it.

Linq ;0)>

[sephiroth2906]

I looked closer, and, of course, you are correct. I have it on so it always pulls up a blank form, but I guess I am not married to it. So, new question. I still want a new record to pop up when the form loads. Is there a default setting for that? If not, I can always create a button. Thanks for the explanation!

[Missinglinq]

This will open the Form to a New Record and allow Find to work, with Data Entry set to 'No.'

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

Linq ;0)>

[sephiroth2906]

Perfect! Thanks so much!

[Missinglinq]

Glad we could help!

Linq ;0)>