How to eliminate the popup from DoCmd.RunSQL£¿

[Min]

Hi£¬When execute DoCmd.RunSQL, if it contains update query, it is always
ask for confirm. Is there anything can avoid those popups?
Thanks!

 

[Allen Browne]

See help on SetWarnings

Better idea is to Execute the query statement. That way you can receive a
warning only if things go wrong:
dbEngine(0)(0).Exeucte "UPDATE ...", dbFailOnError

 

[Min]

Thanks for reply!
I do need error information. I am afraid if set "DoCmd.SetWarnings False", I
will miss error message.I would like to use:
dbEngine(0)(0).Exeucte "UPDATE ...", dbFailOnError

But this line got a complie error: user definition or type not find.
What reference should I set to use dbEngine(0)(0)?

Thanks!

 

[Allen Browne]

Include a reference to the library:
Microsoft DAO 3.6

More details on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

The ultimate is to wrap the entire thing in a transaction so you get an
all-or-nothing result. Example and tips on how to avoid the pitfalls:
http://members.iinet.net.au/~allenbrowne/ser-37.html

 

[sithiha]

how to export tables from Msaccess2000 t0 Msaccess 1997 version in vb?

When i try to export the tables from Msaceess 2000 t0 Msaccess 1997 version using the
following syntax in vb
docmd.transferdatabase acexport,"Ms Access", Filename,actable,TableNamefrom ,tableNameto
I got an error message like "It requires an open database",
Please guide me to overcome this problem.
Thanks in advance