print macro

G

Guest

Macro done in command button on a form intending to print a report gives error message that database is locked. Macro was set up in ACCESS 2002 to 1)open report; then 2) printout. Are there any other steps?
 
S

Steve Schapel

Macro,

I presume you mean that the report first of all is opened in Print
Preview, and then supposed to Printout. This is not really a good plan.
For one thing, what the Printout macro does is tries to print the
"active object", which you have no way of ensuring that this is your
report at the time. If all you want is the printed report, just use an
OpenReport action, with the View argument set to Print.

Having said this, I do not know whether this is related to your database
locked problem.
 

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

Similar Threads

Call a macro from commandline with existing autoexec 1
Type Mismatch with Option Group 1
Use Macro to Print Reports 2
print multiple reports 1
Access 2007 Macro Condition 1
Help! My Macro is Freezing my Database! 6
Create Macro to print current record in form only 2
Macro fails from button, runs when selected directly 5

Top