Excel user enter a store # to query Access data base

L

liem

I have a file when the user enter a store # 13315 and hit a update button
the marco will go to access data base to query this store and bring back
data. we found out if there was more than 5 users from 5 different location
the error will cause the spread sheet do not return data.
How can I write a message to pop up warn the user if more than 5 user query
the data base they have to wait for a minute before they try to update


thank you

liem pho
 

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