Warning messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

I can't seem to find a solution to the following problem. I've made a form to call up some data from several queries and tables. And in this form I encoded a small auditing function so that whenever the form is started a record is added to a hidden table with the networkusername and current date. Now, the problem is that Access always displays a confirmation warning: "You're about to paste 1 row blablabla..." whenever the form is started which is normal because of my code. Nevertheless, this message has to disappear, because it's annoying for the users.

I know I can disable these warnings in tools => options. But that only helps for my pc and the access database is used over the entire company. These confirmation/warning messages are default always enabled in Access. Is there some code for my form to shut down these messages? Or some option that I seem to have missed to permenantly disable them regardless which pc you use?

Thanx in advance!!!!
 
add the following before the line of code that updates the table
docmd.setwarnings false

and then
docmd.setwarnings true

after the line of code that updates the table

HTH
Pain said:
Hi everyone,

I can't seem to find a solution to the following problem. I've made a form
Click to expand...
to call up some data from several queries and tables. And in this form I
encoded a small auditing function so that whenever the form is started a
record is added to a hidden table with the networkusername and current date.
Now, the problem is that Access always displays a confirmation warning:
"You're about to paste 1 row blablabla..." whenever the form is started
which is normal because of my code. Nevertheless, this message has to
disappear, because it's annoying for the users.
I know I can disable these warnings in tools => options. But that only
Click to expand...
helps for my pc and the access database is used over the entire company.
These confirmation/warning messages are default always enabled in Access. Is
there some code for my form to shut down these messages? Or some option that
I seem to have missed to permenantly disable them regardless which pc you
use?
 
Back
Top