remove Macro Warning message

[Jerseynjphillypa]

How to remove all the Warning when the Macro run an click Yes,



some of the warning message are

You are about to run a delete query that will modify data in your table
You are about to delete 200 row(s) from the specified table
You are about to run an append query that will modify data in your table
Microsoft Office Access can't append all the records in the append query (150 fields to Null fue to a type conversion failure....)

[pbaldy]

Look at SetWarnings. Make sure to turn them back on after running the query. Also

http://www.baldyweb.com/SQLWarnings.htm

[Jerseynjphillypa]

thanks for the help pbaldy

[pbaldy]

No problem.