you are about to run an append query that will modify data in your table

mad-q

Registered User.
Local time
Today, 14:49
Joined
Feb 14, 2010
Messages
61
Hello,

I have the above message box appear. No problems to get rid of it. The main problem is that when I do it then messes with my code and asks for input data which it collects from various fields. If I turn the message boxes back on then it is able to find the data and continue.

Please can someone help with removing the message boxes but still allowing my query to function?

Many Thanks
 
Perhaps you can post your code, and the method you use to avoid the warnings? Off the top of my head, I'd use the Execute method rather than RunSQL, but of course that's just a guess at what your method is.
 
How did you disable the warning message?

please post your VBA code.
 
To disable the message I click on Access Options>advanced> and under the confirm it has action queries. Untick this and they stop.
 
You will find that both pbaldy and HiTechCoach have asked that you post your code so they can examine it and advise accordingly.
 

Users who are viewing this thread

Back
Top Bottom