eliminate message from append query to eliminate duplicate record.

S

Sandi G

How can I keep the error message "...cannot append all the records..." from
appearing to users when running a append query to eliminate duplicate
records. The query is running from a switchboard menu item and users are
afraid to accept continuing with the action.
 
A

Allen Browne

Execute the query without the dbFailOnError.

Details in:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

The article suggests using:
db.Execute strSql, dbFailOnError
but you want just:
db.Execute strSql
 
Top