If Exclusive, dont run

R

Ryan Tisserand

My form "UpdateForm" has a command button "Update" that runs make table
queries that will only run if the database is exclusive to the user updating.
I would like a run a small code before the update starts instead of using
the On Error GoTo event of the "Update" control to have a message box pop to
let them know they cant update at this time. I'm not sure how it would look,
but this is what im thinking.

If "ChartTracking.mdb" = exclusive Then
run "update"
Else
MsgBox "My messege to the user to let them know they cant run update at this
time"
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top