How to create form warning or notice

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

Guest

Hello all,

I have performed a search on my need, but have not located anything. I have
intermediate Access skills and require assistance in a problem.

I am working with Access 2003. I have a form that frequently when I open it
the first entry has changed. This database is used to keep a log of
volunteers in our organization. Other users are inadvertently writing over
existing data. Currenly before a new entry is made, the person needs to
check the form to see if the entry exists. They do this by the generic
search by field.

What I would like to do is two fold. I would like to be able to perform a
search by first name and last name. This can retrieve all entries that fit
the criteria, then the person can select from the list. Secondly, I would
like the individuals not to arbitrarily change information without a yes or
no confirmation. If the confirmation is not to change the information that
is revert to the original text. If it is yes they are taken to a new blank
record.

Thanks to all who assist.
 
Glagon,
There are many solutions to this problem, but the real problem is
allowing untrained people to edit records.
Your proposed solution seems a bit complicated, and easily defeated by
those same users...

One simpler method is to lock all existing records from editing by
setting the AllowEdits for the form to NO. Place an custom EDIT button on
your form with a simple password Input Box that will set the AllowEdits to
YES and allow users who are properly trained (and therefore have the
password), to edit existing records.
AllowEdits = NO will not prevent untrained (volunteer type users) from
"adding" new records if they want.
-
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Thank you for your suggestion Al.

The dabase is not accessed by the volunteers though. It is by the AA's that
enter the application information. I think requiring a password will help
with others attempting to enter information without going through the correct
individuals.

I am still left with the problem of the AA's overwriting data in the first
record when the form opens. I did see in the form properties the events of
"before update" & "after Update" Can a code be written for one of these
events that before the change is saved that a dialogue box opens to ask yes
or no to keep changes?

Glagon
 
Back
Top