Msg Box saying that a table is open

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

Guest

I've searched the board for this ? and can't seem to find what I'm looking for.

I have a command button. Within this command button, I have several queries
that run. What I would like to do, is button a msgbox command within the
button restricting a user to click on the button if another user is in a
table. I want a message box to appear saying "Another User is currently is
another table." I know how to build the message box, but I'm not sure how to
write the VB code saying that a table is open by another user?

Does anyone know?

Thanks
AccessFitz
 
Why do you need that?
If another user is changing something in the table, the table will be locked
for his usage, you would not be able to change it anyway.
 
Salut,

When you have a make table in your command button. An Error will populate
saying
the table is already opened by an exclusive user. I want a build some code
into the button to know if someone is currently in that table. If the table
is opened.
 
You must log in or register to reply here.

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

Similar Threads

Access Automatically Send a notification email once a record is added 0
Control if a form updates table 3
can input msg box inputs data into table? 3
Command Button 5
Msg Box with Conditions and display a value from form on message 4
Excel Providing user message when RED X clicked & properly closing application. 2
Cannot open database ? 2
Populating a combo box.... 1

Back
Top