Append Qry In Access 2000
Execute the SQL statement with dbFailOnError, i.e.:
Currentdb().Execute "Insert ...", dbFailOnError
dbFailOnError generates an error if there's a problem.
There's no need for a temp qdf.
The other issue is whether your WHERE statement returns any records.
Quote:
> I want to append some data, (select fields only) from one Access 2000 tbl to
> another and where two unique IDs match, (one in ea tbl). I was trying to
> use a docmd.RunSQL "Insert Into..." statement. However, no data is appended
> over and the temp qrydef I created, (QBE) screen is blank.
> Should I use the recordsetclone, or some other method? I could really use a
> push in the right direction.
> Thank you for your help.
> -Chris
--
Perth, Western Australia
Tips for MS Access users at:
http://odyssey.apana.org.au/~abrowne
