Warning Message in Access 97

[eriel3]

I have a warning message that appears every time I update a query. I did go to Options and deselected all query messages, but this one is different. it says:

"Microsoft can not append all records in the append query"

I know this because I told the query not to accept duplicates, but I do not care about the message. Is there any other way that I can take this warning message out.

 

[eriel3]

Okay i think I figured out one way to take this off, here is my SQL.


INSERT INTO AppendTable
SELECT DISTINCTROW [Daily Activity-Millennium].*
FROM [Daily Activity-Millennium], AppendTable
WHERE ((([Daily Activity-Millennium].ActualForecast)="Actual"));

How do I tell it to only append records that are not found in the AppendTable. The uniquie field is called DailyID and I have that set up in the AppendTable as (No Duplicates)

 

[scottian]

docmd setwarnings false
before your code then
docmd setwarnings true

to switch the warnings back on again