Warning (Access 2003)

Topic

New Reply

I have a button that you click and it appends rows to a table. The message always comes up that “this will append 3 rows to the table…”. How can I stop the message and still have it populate the table.

Reply | Quote

Replies

Insert a line

DoCmd.SetWarnings False

at the beginning of the code behind the command button, and

DoCmd.SetWarnings True

at the end.

Reply | Quote

Thanks!

Reply | Quote

Hello Hans,

From Access 2000 help:[indent]

---

When the macro finishes, Microsoft Access automatically turns the display of the system messages back on.

---

[/indent]Is it really necessary to add the final DoCmd.SetWarnings True line?

Thanks

Reply | Quote

[indent]

---

at the end.

---

[/indent]Re-reading your post, I believe that’s meant to be “at the end of the code behind the command button“, not “at the end of the code of the whole sub”. Sorry, my bad.

Reply | Quote