Text Box Refresh

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

Guest

My database is shared. When it is opened the "TrackingNumber" stored in
table "TblTransactionsdata" is automatically sequenced using DMax on the
form. The operator then keys in information and saves the file. The
TrackingNumber is written down on paper for later reference. If two or more
people have the database open at the same time they all will have the same
"TrackingNumber". How can I prevent this?

=DMax("TrackingNumber","TblTransactionsdata")+1
 
One method would be to immediately save the record after you get the
tracking number.
Another would be to get the tracking number as the record is saved.

Both of these have the potential for getting duplicates, but the potential
is small unless you have a large number of people entering data at the same
time. The first does have the potential for dropping a number of the user
begins creating a record and then cancels (deletes) the record..

Beyond that I have no suggestions as I don't know your process.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top