Disabling replace function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How should i disable replace function in form. I want users to use find only
but not replace.
 
How should i disable replace function in form. I want users to use find only
but not replace.
Click to expand...

Set the Allow Edits property of the form to No.

If that messes up your search, set each bound control's Enabled
property to No, and its Locked property to Yes.

John W. Vinson[MVP]
 
Let me be more precise..
While editing form, find fill help in locating desired information. But
replace may accidently corrupt datas. So i just wanted to disable replace but
at same time users have right to change fields individuallly..thanks
 
Let me be more precise..
While editing form, find fill help in locating desired information. But
replace may accidently corrupt datas. So i just wanted to disable replace but
at same time users have right to change fields individuallly..thanks
Click to expand...

I guess I don't understand the question.

You want users to be able to change fields individually.
You want to prevent users from changing fields.

This is a contradiction. You cannot possibly have both, as stated!

What is it that the users are doing to "corrupt" data? What do you
mean by "find fill help" - that phrase means nothing to me?

John W. Vinson[MVP]
 
How about building custom search tools and avoiding the Access "find"
feature all together?

just a thought...

Betsy
 
Apologise for mistatement..
I meant to say I dont want user to give replace option but want to give find
option. If suppose they are viewing form and someone gives replace function ,
so it will change all records with replace. But with find option they can
search for things.
Eg if they are searching for particular name. And someone gives replace
Roger with Harry, then it could happen wherever form finds Roger it will
overrite with Harry.
Thanks
 
Apologise for mistatement..
I meant to say I dont want user to give replace option but want to give find
option. If suppose they are viewing form and someone gives replace function ,
so it will change all records with replace. But with find option they can
search for things.
Eg if they are searching for particular name. And someone gives replace
Roger with Harry, then it could happen wherever form finds Roger it will
overrite with Harry.
Click to expand...

Not if your form is designed correctly, no. Searching for Henry WILL
NOT overwrite Roger.

How are the users trying to do this search? What search provisions
have you made on the form?


John W. Vinson[MVP]
 
Form is designed as follow :
pop up mode : YEs

Data Entry : No
User can scroll arround all records.
Editable : Yes


CTRL F will evoke search criteria. The next tab says Replace Tab. Am
assuming if user usses replace commance, then it may overrite data in all
records. Like if they give Replace X with Y, then it may happen that all
records would be changed.
 
Form is designed as follow :
pop up mode : YEs

Data Entry : No
User can scroll arround all records.
Editable : Yes


CTRL F will evoke search criteria. The next tab says Replace Tab. Am
assuming if user usses replace commance, then it may overrite data in all
records. Like if they give Replace X with Y, then it may happen that all
records would be changed.
Click to expand...


OK. Thank you. I think I understand now.

One solution would be... *don't use Ctrl F*.

Instead, put controls on the form itself, unbound ones, to do the
searching for the user. Or, open the form with its WhereCondition set
to the criteria that the user wants to see.

Or... train the users that replacing all the data in the database will
replace all the data in the database, and that they'll be required to
retype all the data since the last backup in punishment.

John W. Vinson[MVP]
 
Thanks a lot!

John Vinson said:
OK. Thank you. I think I understand now.

One solution would be... *don't use Ctrl F*.

Instead, put controls on the form itself, unbound ones, to do the
searching for the user. Or, open the form with its WhereCondition set
to the criteria that the user wants to see.

Or... train the users that replacing all the data in the database will
replace all the data in the database, and that they'll be required to
retype all the data since the last backup in punishment.

John W. Vinson[MVP]
Click to expand...
 
Back
Top