Info Boxes?

[Klo]

When I import data to a table I will get an info box that states (among other things), "Access was unable to append all the data to the table.". This is due to primary key violations which means that access is doing just what it is supposed to do. The problem is that I want this proceedure to run at nite and no one will be there to click OK. How do I bypass this box?

 

[batteam]

Just before your command that runs the append query, you have to put:

DoCmd.SetWarnings False

Do your query here

DoCmd.SetWarnings True

Hope this helps.

 

[Klo]

It's just amazing when you know what you are doing! Works great. Thanks so much!