disable popup message

[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

 

[Guest]

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

 

[Guest]

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

 

[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

 

[Andrew Chan]

Million thanks to all
done ^^