disable popup message

A

Andrew Chan

I have use DoCmd.RunSQL to insert multiple record into Access table.
Everytime a popup message asking am I willing to insert it. Can I disable
this popup so I don't need to answer it.
Many Thanks
 
D

Dennis

Before your runSQL statement add the following
DoCmd.SetWarnings False
and then after your statement put
DoCmd.SetWarnings True
 
T

Tom Wickerath

Hi Andrew,

I have a Word document, which I will try sending to your indicated e-mail
address. This document shows several ways to deal with this issue.

Tom
________________________________________

:

I have use DoCmd.RunSQL to insert multiple record into Access table.
Everytime a popup message asking am I willing to insert it. Can I disable
this popup so I don't need to answer it.
Many Thanks
 
N

Nikos Yannacopoulos

Andrew,

Instead of:

DoCmd.RunSQL strSQl

you can use:

CurrentDb.Execute strSQL, dbFailOnError

which will execute the SQL without the prompts to confirm.

HTH,
Nikos
 
Top