Macro in VB - SetWarnings = No

[Guest]

I am using VB to run a macro running several update queries. If I turn
SetWarnings to No, the macro does not run. Is there a way to suppress the "ok
to update" message and still run the macro in VB?

 

[Ken Snell [MVP]]

I know of no reason why the macro wouldn't run just because you set
SetWarnings to No. There must be some other reason. Post the VBA code that
you're using, and post the macro's actions.