Print Macro Definitions

G

Guest

How do you stop the "Pring Macro Definitions" dialog box from appearing when
printing reports from a macro?
 
S

Steve Schapel

LGropel,

I am not sure what you are referring to, but maybe if you give details
of the macro you are using, i.e. all actions and relevant arguments,
someone will be able to spot the problem.
 
G

Guest

I have created a report. Then I created a macro where the first command is
to open the report. The second command is the "Print Out" command. The
report prints as expected. However, when the printing is complete, a dialog
box pops up. The title for the dialog box is "Print Macro Definition".
Within this dialog box is a frame titled "Include For Macro". The frame then
contains three options; Properties, Actions and Arguments, and Permissions by
User and Group.

My ultimate goal here is to have the Windows scheduler to open Access,
execute a macro to print a report, and then shut down Access. It appears
that Access won't shut down because the "PrintOut" command will not complete
until the dialog box is dealt with.
 
S

Steve Schapel

LGropel,

There is no need for the PrintOut action in your macro. The OpenReport
action prints the report. What appears to be happening is that you are
printing the report, via the OpenReport action in the macro, following
which the report is closed, following which the PrintOut action is
applied to the currently active object, which apparently is the macro.
Just remove the PrintOut action form the macro.
 
G

Guest

aaaaahhh!!! That makes sense. I'll give that a try and let you know.
Thanks a ton !!
 
G

Guest

I am using the PrintOut Action in my macro because I need to print more than
1 copy of a report BUT I do not want the Users to have to deal with Print
Macro Definition window. How can I disable it?

TIA
 
G

Guest

Thanks, it worked
And after giving it some thought Print Preview rather than Print (the
default) makes sense before using the PrintOut action
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top