disabling editing after records are uploaded

  • Thread starter Thread starter mon
  • Start date Start date
M

mon

I have seperate databses for users (Mainly because I
haven't got into the login security bit, but also so that
they can data enter on their laptops at home) So when the
records are loaded onto our main database, I do not want
them to edit their local records. There is a field which
is set to true when the records are uploaded. Thanks
Mon
 
Why you posted this to the reports group is a good question but....

OK, if you haven't set up security there's no way to really ever stop this
because they can always open the tables directly, instead of using the form
and have at it in terms of editing. Notwithstanding that, if you add a
simple little piece of code to the On Current event of your forms like this
it will stop them from changing the record using a form:

If Me!UpLoadedFlag = True Then
Me.AllowEdits=False
Me.AllowDeletions = False
Else
Me.AllowEdits = True
Me.AllowDeletions = True
End if
 
Back
Top