access default messages 1

[Lhuffst]

using the select into statement which works fine but I receive these 2 messages when I run the docmd.runsql portion:
1. The existing table "tblname" will be deleted before you run the query
2. You are about to paste 3 rows into your new table.

While the messages are accurate, the users do not want to see them. How can I get around them?

 

[Remou]

You can use Execute:

CurrentDB.Execute

Or you can set warning off before you run the SQL and on afterwards:

DoCmd.SetWarnings True