Query runs right but....

[Sander]

I am trying to run an append query where I'm going from a table with no promary key to a table with a primary key. Now the query is doing exactly what I want it to do.

However, since there is a primary key in the receiving table, I am getting a pop up box stating that a whole bunch of reconds are no going to append because of key violations. That's fine but I want to turn it off. I have tried everything I can think of but it won't go away. Is there a way?

It's been so long since I've built a database my head is full of cotton balls.

Thanks....

 

[KenHigg]

If you're doing it from vba, try the SetWarnings = false line of code to turn these warning off. Then SetWarnings = True to turn them back on.

???
kh

 

[Sander]

After looking at yours, and knowing I did the same thing I looked again and realized what I did was misspelled it. Thank you very much; at least I know I wasn't losing my marbles!

 

[KenHigg]

Cool, Glad ya got it to work

ken

 

[modest]

i dont know if you left it off on purpose, but i normally type it as:

DoCmd.SetWarnings False
DoCmd.SetWarnings True