in and enter pertinent information about how their shops ran
throughout the day so that my boss (and theirs) could report out to
his boss at the end of the day about how things went. Each shop has
its own form to enter their information. I gave them separate forms
bound to 4 separate tables because the information gathered from each
shop is unique. Each form opens with the following code:
Expand|Select|Wrap|Line Numbers
- Private Sub Form_Open(Cancel As Integer)
- DoCmd.Maximize
- DoCmd.OpenForm "ShopDailyfrm", , , "txtDate = Date()"
- End Sub
times throughout the day to add and update data / comments. The
database then creates one report containing the information
for all 4 shops that my boss uses to report out to his boss.
Problem is that there are multiple users adding information to the
tables. I have told the users within each shop that there should
only be one person in the shop specific form at a time. I have one
shop that does not always adhere to this and some days I end up
with multiple records. My hope is to prevent this by "locking-out"
the form to one user at a time. I thought by checking the "Edited
Record" radial on the advanced Options tab would elminate multiple
records, but it hasn't.
Can anyone assist me in locking the form to one user at a time?
I am running Access 2003 on Windows XP.