Disable Type conversion Error messages

[Geoff]

When running a query I get the message "cannot update one field due to a
type conversion failure" using the DoCmd.RunSql in code. I would like to
suppress this message and am unsure how. The on error resume next doesn't
stop the message. Any suggestions would be greatly appreciated.

 

[Allen Browne]

Try turning SetWarnings off.

Alternatively Execute the query without the dbFailOnError switch, i.e.:
dbEngine(0)(0).Execute "MyActionQuery"

An advantage of the 2nd method is that you can get the number of
RecordsAffected.