Warning messages (1 Viewer)

[syedadnan]

Regards

I am looking to get solution for the warning messages that comes with append, delete, update query and more..

I want this to be done by VBA which i will do subjectively but wanna stop this query popups or message

 

[CJ_London]

sounds like you are using docmd.openquery etc. Instead use currentdb.execute

 

[Eljefegeneo]

You could also insert before the command:

DoCmd.SetWarnings False

and then after the command:

DoCmd.SetWarnings True

It is very important to set the warnings back to True after running the query.

 

[syedadnan]

You could also insert before the command:

DoCmd.SetWarnings False

and then after the command:

DoCmd.SetWarnings True

It is very important to set the warnings back to True after running the query.

Thanks work done !!!