Prevent delete records question....

  • Thread starter Thread starter Moo
  • Start date Start date
M

Moo

Hi,

I am creating a lost/found property database for my workplace.

Currently I have two user logins - 'Admin' & 'User' the User and can add
records and save but not delete or edit.

My problem is that when an item is returned to the owner I want this to be
shown in the database somehow either by greying out the boxes or some other
method. How can I have it so the user can register the item as claimed yet
not edit or delete records (well the fields within the records)? Would a
macro button do the job, if so how would I go about greying out what I need.

It would also be nice if I could have some kind of a flag so that returned
items are not shown in a search, is this possible?

The reason for this is if a record is deleteable by the 'User' they could
make expensive items disappear or they could change the description to a non
expensive item.

Many thanks,

Rodney.
 
My problem is that when an item is returned to the owner I want this to be
shown in the database somehow either by greying out the boxes or some other
method. How can I have it so the user can register the item as claimed yet
not edit or delete records (well the fields within the records)? Would a
macro button do the job, if so how would I go about greying out what I need.

It would also be nice if I could have some kind of a flag so that returned
items are not shown in a search, is this possible?
Click to expand...

I think you will need to make the record editable - unless you can
record *somewhere* that an item was returned, there's no way for
Access to remove it from view or grey it out!

One suggestion: have a ReturnedDate field in the table (along with any
other information that you might want to record, e.g. by whom and to
whom). Make the record editable, but set the Locked properties of all
the textboxes to False *except* for these.

Or, create a Returns table related one-to-one to the Items table. Put
it on a Subform on the items form; the user could enter the date
returned and other information into this subform without the controls
on the mainform being editable.
 
Back
Top