Append Query

  • Thread starter Thread starter Access Beginner
  • Start date Start date
A

Access Beginner

i have an append query that requeries a main database every 15 minutes and
pulls any new information through, however i constantly get an error stating
that x records couldnt be addeed due to ket violations, which is what i want,
however i do not wish to see the error message is there any way to disable
this???
 
I have good news and bad news...<g>

Yes, it is possible to disable that warning.

Yes, it is possible to disable that warning.

I don't know how you are "requerying ... every 15 minutes" but I'm guessing
via a macro or via a procedure. Take a look at the SetWarnings command --
turning off the warnings means you won't see that warning ... and you won't
see ANY warnings, until you turn it back on.

Do you feel lucky? Well, do you?! (hint: ALWAYS turn warnings back on at
the end of your macro/procedure).


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top