Access 2007

[Paul W Smith]

I have created a macro that runs a series of queries one after the other.

I want to avoid have to answer all the dialog boxes warning of deletions
etc. In previous version of Access I believe it was SetWarnings = True, and
this was able to be selected from the Actions list on when in design mode of
the macro.

How do I achieve the same thing in Access 2007?

 

[Jerry Whittle]

That is strange! I have a macro converted from Access 2003 and it has Set
Warnings in it and works. However Set Warnings is no longer in the dropdown
list nor will Access allow me to type it into a new or existing macro.

The best that I can suggest is to run the Macro from code like below:

Public Function fRunMacro()
DoCmd.SetWarnings False
DoCmd.RunMacro "Macro1"
DoCmd.SetWarnings True
End Function

 

[Clifford Bass]

Hi Paul,

You can still use the SetWarnings. To be able to select it you will
need to click on the Show All Actions item in the Show/Hide section of the
Macro Tools' Design ribbon.

Clifford Bass

 

[Jerry Whittle]

Wow. Why would the hide a commonly used action? And why can't you manually
type it in? Also the number of actions hidden by the button isn't all that
many.

Thanks for the tip.

 

[Clifford Bass]

Hi Jerry,

You are welcome.

They chose to hide the macro actions that will not run when the
database is not trusted (or not in a trusted location). I suppose the idea
being to help you in your creation of macros in some strange way. Frankly, I
do not need that kind of nanny. Fortunately, it appears to remain active for
each macro once you choose to show all actions for that macro (and save).

It uses a combo box that limits to list, which is why you cannot just
type it in when those actions are not showing.

Clifford Bass