check out a record

[Pass-the-reality]

Our switchboard allows for 3 views. Button 1 allows you to create a record.
Button 2 allows you to view records that require ordering (missing order
number) and Button 3 allows you to view all records (orders with or without
order number). Multiple associates can be placing orders at the same time.
When entering Button 2, is there anyone to "check out" one record at a time
so that multiple associates are not working on the same record? Currently,
we have our associates put their name in the Order By field, but some
associates forget to do this and orders are placed in our ordering system
twice. Any suggestions on how to check out one record at a time to where no
one else can check out the record until it is submitted back in?

 

[Arvin Meyer [MVP]]

Checking out a record would require a server based database engine to
maintain control. Right now Access can only lock the record(s) so that only
1 will save at a time, if there are multiple users. But you can do better by
automatically entering the username without requiring the user to remember
to do so. Use the code at:

http://www.mvps.org/access/api/api0008.htm

to get the user's login name and automatically place it the table, then
change your form so that each user can only edit his or her own records.