Delete Button

Haynesey

Registered User.
Local time
Today, 00:13
Joined
Dec 19, 2001
Messages
190
Hi,

Is there any way to stop users of a database deleting records once created?

Thanks in advance

Lee
 
Yes they are called object permissions, do you have user logins?

Also form properties are worth looking at too, like 'Allow Deletions'
 
Why even put a delete button ?????

Why even put a delete button if you dont want user to delete records ?

Assuming you are controlling your data via Forms, not tables.

I have a delete button on my form and it's only for managers. You can use delete button and password protect it.

Regards
Dianna Goldsberg
 
Did you disable the forms Allow Deletions property? If not, then the user can delete the selected record just by pressing the delete key on their keyboard [unless you have also trapped for the pressing of the Delete key].

Code:
Me.AllowDeletions = False
Keyboard commands:

Select current record: Ctrl + Shift + Space Bar
Select all records : Ctrl + A

Press the Delete key to delete the selected record(s).
Press the Ctrl + X key to delete the selected record(s).
 
Last edited:

Users who are viewing this thread

Back
Top Bottom