O
Opal
I have a database that was created so that 4 separate shops could go
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:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
DoCmd.OpenForm "ShopDailyfrm", , , "txtDate = Date()"
End Sub
So that they always see each day's information and can go in multiple
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?
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:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
DoCmd.OpenForm "ShopDailyfrm", , , "txtDate = Date()"
End Sub
So that they always see each day's information and can go in multiple
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?