Disable "REPLACE" IN FIND/REPLACE

L

Lisheen

Hi I was wondering if someone could possibly tell me if it is possible to
turn off the the find/ replace function. I have a database made up of
several forms and although on these forms I want to allow people to find
information I do not want them to be able to use the replace function.

I was also wondering if some one could point me in the right direction, I
have a database which is in use for at least 2 years now all of a sudden when
I go to open a form or search I get a message saying invalid arguement.

Any help would be appreciated.
 
A

Allen Browne

There is no provision to disable replace.

But Access doesn't offer the replace if the form is read-only. If you use
custom toolbar button (or a command button), you can therefore achieve it by
setting the form's AllowEdits to false before you RunCommand acCmdFind.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompt For Replace in Selection And More... 0
After Word 2013 crashed, the side panel with the Find Option and Chapter headings is missing 2
how can i change a sequence of numbers using find replace 2
VBA: Macro to find and replace multiple instances of text with form field 0
How to find and replace text in a document with changing variables 2
Automation of scanned file storage based on content 0
how can I use Word find and Replace to search inside a stringvariable (in a macro) 1
Find all instances of a certain word and replace with hyperlink of same word 4

Top