By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Is there a way to secure/locked data after submit?

P: n/a
Hello all

I have an Expense Report Interface

Users logon using Access security. They enter their expenses
information and then click on a button to display the report, print it
and sign it. What I want is, once the user finished filling the expense
report form and they click on the report button, then they will not be
able to change that information...they can of course go back and see
it, but not change/update it.

I tried uncheking the "Update" option for the tables under the
permissions for the groups but I dont quite like this, because if the
user is filling the form and move to another field and then wants to
change, for instance, the date (and have not press the button to
display the report) it wont let him change it. So, thats the problem
with that option.

Any ideas?

Thanks in advance

Aug 16 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
include a YesNo field in the form's recordsource. Set the value in the
BeforeInsert event of the form to No/False. In the Current event of
the form, set the form's AllowEdits property to that value.

Aug 17 '06 #2

P: n/a

pi********@hotmail.com wrote:
include a YesNo field in the form's recordsource. Set the value in the
BeforeInsert event of the form to No/False. In the Current event of
the form, set the form's AllowEdits property to that value.
Thanks for ur answer but I am kinda confused.

Let me give you some more details. I want the data to be locked once
the user press a button. This button is the "Send report by email"...So
the user can modify all the data in the report but once he hit the Send
report by email button the data is locked.

Can you give me some more details? please
What I understand is:
>include a YesNo field in the form's recordsource
1. I will add a field to my table, lets say the field's name is:
"YesNoLocked"
2. Then add that field in the query for my Form
3. Behind the form's BeforeInsert event I will put, [YesNoLocked] =
False
>In the Current event of the form, set the form's AllowEdits property to that value
I dont understand this part, the Current event I do...but not the rest,
can you please give me some more explanation in here?

Aug 17 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.