I have a macro created that has several different steps, some of which include Delete Queries and Append Queries.
As is natural, when the Delete Queries or Append Queries run, the end user has to click an answer in a dialog box that pops up asking if they want to do it. The answer is always "Yes".
Is there any way to automate that so that the macro just runs everything and the end user does not have to click anything?
I don't know VB, so if the answer lies in VB code, I won't be able to do it. This is something I need to be able to do within Access itself.
Thanks!
As is natural, when the Delete Queries or Append Queries run, the end user has to click an answer in a dialog box that pops up asking if they want to do it. The answer is always "Yes".
Is there any way to automate that so that the macro just runs everything and the end user does not have to click anything?
I don't know VB, so if the answer lies in VB code, I won't be able to do it. This is something I need to be able to do within Access itself.
Thanks!
