Access 2003 won't print reports in "user mode"

  • Thread starter Thread starter Steve C
  • Start date Start date
S

Steve C

Hello,

I havea database that is split into a BE and FE. I have
the frontend setup with all the forms, reports and macros
in. I have 2 "modes" the "user mode" that doesn't allow
access to the database window or anything like that, only
my forms (via a custom menubar), and the other mode that
is the normal interface with the database window.

When I try to print from "User mode", I get 1 page, and
it is blank, no matter what data I have told it to print.
If I do this from normal mode, the report prints out fine.

I am telling it to print using a macro, with the
runcommand action selected, and Print selected in the
properties section. This is assigned to a button on a
custom menubar.

What is wrong with it?
 
I seen this happen if you have a form with a timer event.

The report looses focus...and some other form gets printed.

So, you might try using actual code for the menu bar to print.

In the custom menu print option, you can call code by placing

=MyPrint()

So, place the above in the menus on-action setting.

Then, in a standard public code module, you can place the following code:

Public Function MyPrint()

On Error Resume Next
DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdPrint

end function
 
Back
Top