Access Make table quiries problem

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

Guest

Hello,

Can someone tell me how to suppress the pop up (yes/no) messages that appear
if you run a make table query?

Jai
 
You can turn off SetWarnings.

However, that will also prevent you being notified if the query does not
complete as expected.

A better solution would be to use the Execute method. This example assumes
the string strSql contains your query statement. It gives on confirmation
message, but does notify you if there is an error:
dbEngine(0)(0).Execute strSql, dbFailOnError
 
Thanks

I will give that a go , when it comes down the coding I'm a bit rusty

Jai
 
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

Using one calculation in another 1
Get the value from a post 1
How to hide the message box when making a table? 4
Make table query: [Enter 1] AS Test 1
Make-Table query simple question 1
Make Table Query Popups 9
adding a field in a make table query 5
Delete Query: Could not delete from specified tables 0

Back
Top