Disable Type conversion Error messages

  • Thread starter Thread starter Geoff
  • Start date Start date
G

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.
 
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.
 
Back
Top