"Find Record" button question

[TeresePamela]

I would like to use the "Find Record" button on one of my forms, but the users that will be using it only have read-only rights. Can I disable the "Replace" portion of this button in anyway? Or, if I set the network permissions on the drive containing the data to read-only will the replace actions be ignored? (thinking of using the database splitter so I can use the network permissions for the data security).

Thanks in advance for any and all advice/input.

Pam

 

[tinymind]

What version of Access are you using?

In Access 97 ...

I use this depending on what I am looking for:

DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

I ask the user to click in the column and then click a button with this line of code in it.

This brings up the Find prompt box and uses Access Find features and NO replace functions.

Tiny

Perfection is Everything
If it worked first time we wont be here!

 

[TeresePamela]

Hi Tiny,

Sorry I should have stated - I'm using Access 2000 and I guess there's a difference because the code you use is exactly the same as the code Access 2000 produces when creating a find record button with the Wizard, i.e. includes the replace functions.

Thanks anyway,
Pam