Printing Report Problem

[PaulT]

I also have a printing problem with Access 2000 reports. For some reason I am unable to print reports on a specific printer on the network. It works fine for other printers except this HP 1300n Laserjet.

There is no error message displayed but when I click to print the report - nothing happens!

Can anyone suggest any ideas why this might be happening? Do I need to adjust any specific printer settings etc? I have run a check with HP and the latest drivers are currently installed.

Thanks for your suggestions in advance.

Paul.

 

[KenHigg]

Can you print other stuff to the printer, say a word doc?

Ken

 

[PaulT]

Yes Ken, the printer is working fine for all other print jobs except from Access 2000.

 

[KenHigg]

Is it a problem with just one workstation or do others fail?

Ken

 

[PaulT]

Just tried it from a different workstation and it didn't work from there either Ken.

Any ideas?

 

[KenHigg]

Hum... Will it not print anything? Say if you went to Documentor and tried to print a table structure...

Ken

 

[PaulT]

Bizarrely it printed the table structure via the Documenter??!!

What does that mean then?

Thanks for your help by the way ken!!!

 

[KenHigg]

Hum...

Will a report show up in print preview?

Ken

 

[PaulT]

Yes preview works fine and it prints ok from the preview.

It just seems to be when it is I use the print button I have on forms.

example of print button code:

Private Sub Command35_Click()
On Error GoTo Err_Command35_Click

Dim stDocName As String

stDocName = "rptPCOS"
DoCmd.OpenReport stDocName, acNormal

Exit_Command35_Click:
Exit Sub

Err_Command35_Click:
MsgBox Err.Description
Resume Exit_Command35_Click

End Sub

 

[KenHigg]

Hum...

Well, it seems we've may have eliminated a lot of possibilities, but I'm still puzzled. Have you tried a plain vanilla no frills little report? Or maybe a new .mdb with just the report and a form with a print button?

Ken

 

[PaulT]

Tried a plain report on a new mdb and it printed no problem. Sounds as though it might be my main database that contains errors somewhere.

Ah well - thanks for your time and efforts Ken!! Much appreciated!

Paul.

 

[KenHigg]

Cool - You're welcome.


Ken

FYI - I would consider doing a new .mdb and copying all the stuff over.

 

[PaulT]

I've looked up the event viewer and found this in the error:

Document failed to print due to GDI/Driver error in rendering.