Hello:
I have a form based on append queries. There are 7 append queries.
Each time when I runthe form, it is asking for confirmation messages 7 times.
Could someone give me the code in VBA to stop this confirmation message from appearing.
I know I can stop this if I go to TOOLS-OPTIONS-CONFIRM.... I am looking for the codes here.
I tried ACCESS help but nothing worked out so far.
Thanks for the help.
I have a form based on append queries. There are 7 append queries.
Each time when I runthe form, it is asking for confirmation messages 7 times.
Could someone give me the code in VBA to stop this confirmation message from appearing.
I know I can stop this if I go to TOOLS-OPTIONS-CONFIRM.... I am looking for the codes here.
I tried ACCESS help but nothing worked out so far.
Thanks for the help.