Report not Printing on all Printers

[instructorgirl]

I have an Access report with subreports in it and it prints fine on several different printers, but on one particular printer, it doesn't display the subreport information in print preview or when I send it to the printer. Is this a Access set up problem or a printer problem? I've never had this problem before, so I don't even know where to begin. Any help would be greatly appreciated. Thanks!

 

[dhookom]

Do you have any code that closes a form that contains controls used to filter a subreport or report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[instructorgirl]

No, I do not.

 

[dhookom]

Are you testing on printers from one PC?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[instructorgirl]

No, I have printed from two PCs to the same printer and received the same result. I have also printed from one PC and gotten good printing results on multiple printers.

 

[dhookom]

I expect you need to update the printer drivers for the printer that isn't working.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[instructorgirl]

We updated the printer drivers for the printer and it's still not printing the entire report. It's printing the data from the subreport just not the OLE object of the subreport.

 

[dhookom]

I don't understand your last sentence "It's printing the data from the subreport just not the OLE object of the subreport".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[instructorgirl]

This report is made up of several subreports. The original report was an Excel file with a lot of lines and boxes which I didn't want to recreate, so I copied the file and laid the data fields over the object. The top part of the Access report with the copied Excel file works just fine, but the lower portion of the report is printing the field names from the database minus the Excel object. I hope that this makes it more understandable. The reason I am so confused it that this report is working on several different types of printers, i.e. Canon, HP (2 different models), but not this particular HP printer. The printer is relatively new (less than a year old).

 

[dhookom]

I have no other solutions or suggestions other than to attempt to remove any Excel object.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]