stop the "Can't append all records" message from showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm trying to make a query which appends records to a different database,
this database is a copy of the original, i want the user to be able to append
the new records they have created to go into this master database, however
all of the records from when the database was copied, are still present. this
database may need to be on 2 different workstations unlinked for long periods
of time, is there a way of stopping the can't append all records message from
showing, as i feel it may confuse users, and they also don't need to know
about it.
 
Not sure how you're running the query, but check out the SetWarnings
function in Help.
 
if you are running the query from code preceed the line of code with
Docmd.SetWarnings False
run query code here
Docmd.SetWarnings True

If you want to turn the message off completely I think Tools - Options -
Edit/Find and uncheck Confirm Action Queries should do it.

HTH
 
Back
Top