DoCmd.PrintOut, Subreports & OLE

  • Thread starter Thread starter Luke Bracegirdle
  • Start date Start date
L

Luke Bracegirdle

I've just upgraded to Access 2003 and have found a problem
with some vb code used to printout a report which has
subreports with OLE objects embedded in them.

The code is a simple DoCmd.PrintOut command on the onClick
event of a button. It prints out the report ok, and prints
out the contents of a subreport that are not OLE objects.
However, any OLE object on the subreport is omitted.

I've checked to see if it is hardware related, but if I
use a structured Access macro to print the report &
subreports it prints OLE objects OK - which leads me to
think its not hardware.

I've searched throught technet and google groups but
cannot seem to see anything. Has anyone had a similar
problem?

Luke
 
Problem solved. In the code the report was opened in design view. When
this was changed to open in preview, the OLE objects were printed ok.
It's strange as you didn't need to do this in Access 97 as opening the
report in design view worked ok - but I guess I'll put it down to
experience.

Luke
 
Problem solved. In the code the report was opened in design view. When this was changed to open in preview, the OLE objects were printed ok. It's strange as you didn't need to do this in Access 97 as opening the report in design view printed OLE objects ok - but I guess I'll put it down to experience

Luk

----- Luke Bracegirdle wrote: ----

I've just upgraded to Access 2003 and have found a problem
with some vb code used to printout a report which has
subreports with OLE objects embedded in them

The code is a simple DoCmd.PrintOut command on the onClick
event of a button. It prints out the report ok, and prints
out the contents of a subreport that are not OLE objects.
However, any OLE object on the subreport is omitted

I've checked to see if it is hardware related, but if I
use a structured Access macro to print the report &
subreports it prints OLE objects OK - which leads me to
think its not hardware

I've searched throught technet and google groups but
cannot seem to see anything. Has anyone had a similar
problem?

Luk
 
Back
Top