Reports are only printing the first subform.

N

-Nick

First of all I am not an access guy. I am trying to help someone resolve a
problem. When they print a report from one computer everything looks fine.
But there are a few computers that when they print only the first subform
prints out. there are just blank spaces where the other ones should print. \

Any ideas?
 
J

John Vinson

First of all I am not an access guy. I am trying to help someone resolve a
problem. When they print a report from one computer everything looks fine.
But there are a few computers that when they print only the first subform
prints out. there are just blank spaces where the other ones should print. \

Any ideas?
Click to expand...

Are you printing a Report? or a Form? Forms aren't designed for
printing, and subforms in particular may not print as desired. More
details please!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
N

-Nick

We are trying to print reports. The thing is that it prints fine on most of
the computers.
 
J

John Vinson

We are trying to print reports. The thing is that it prints fine on most of
the computers.
Click to expand...

The blank subreport sounds like the Query upon which it is based might
not be returning any records. A couple of things to try:

-Open the database on one of the computers that is giving the blank
reports and check the References. To do so, type Ctrl-G to get into
the VBA editor; on the menu select Tools... References. If any of the
boxes are marked MISSING, uncheck and recheck that checkbox, close and
open Access, and check it again. If it's still missing, see if the
..DLL file referenced is in fact installed on your machine, and if
necessary, reregister it.

- If that's not helpful, or if there are no missing references, please
post a description of the report that's failing. Indicate its
Recordsource property, the Master/Child Link Fields of the subreport,
and the Subreport's Recordsource. If either Recordsource is a Query,
click on the ... icon, open it in SQL view, and post the SQL here. You
may also want to open the query itself in datasheet view and check
whether it's returning any records.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top