Setup write permission for a user

[Guest]

Hi,
I have setup permission for my Microsoft access database users. For one of
my users, I just wanted write permission. I don’t want him to be able to
edit data after he saves it. So, I gave him New Data User permission. But
the point is without hitting save for entry, the data is saving automatically
and he can’t change anything after entering data. He is using ‘tab’ key to
add new field and that is very dangerous because by hitting the ‘tab’ key
accidentally after his last field, the data is saving and he can’t edit it
anymore. Is there anyway to prevent this problem?

Thanks

 

[Lynn Trapp]

You could add the following code to the BeforeUpdate event of your form.

If MsgBox("Do you wish to Save this record?, VbYesNo) = VbNo Then
Cancel = True
End If

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Thank you very much for the code. Should i use expression builder, macro
builder , or code builder for this? I used BeforeUpdate event of my form
(the main form and not the detail, or header page part of it) and i used
expression builder and it didn't work. If the answe is that i have to use
the code builder, then, how should i use this code in there?
Thanks in advance.