Printing Problems

[AndyShuter]

Having a real problem today, cant seem to get my reports to print on the network printer!!!

1. When i try to view the report in design view, I get the following error message "There was a problem retrieving printer information for this object,The object may have been sent to a printer that is unavailble"

2. In my form, when I try to force the print job through a command button, I get the same message, but it is preceeded with "Run Time error 2213"

3 The code that forces the print is simply "DoCmd.OpenReport "rptetcetc"

Please help!!!!

PS Tables, queries & forms print fine

 

[Ukraine82]

2. In my form, when I try to force the print job through a command button, I get the same message, but it is preceeded with "Run Time error 2213"

3 The code that forces the print is simply "DoCmd.OpenReport "rptetcetc"

Try pasting this code below in a command button...OnClick

On Error GoTo Err_Command12_Click

Dim stDocName As String

stDocName = "YourReportName"
DoCmd.OpenReport stDocName, acNormal

Exit_Command12_Click:
Exit Sub

Err_Command12_Click:
MsgBox Err.Description
Resume Exit_Command12_Click

hth,

Michael

 

[nims]

Andy, what is the printer you are using and also the operating system?

I have spent all morning trying to solve this problem on one of our machines, and it turned out to be something to do with the printer driver.

We are using Windows Server 2003 (the client PC is running Win 2000) and a HP LaserJet 1300.

Everyone in the office could print except for one machine, which would print from any application except for Access. I got the same error message as you.

If the default printer was set to one other than the LaserJet, there was no problem.

I tried reinstalling Access, the printer, the printer driver, but could not get rid of the problem.

In the end I installed a different driver on the server from the one supplier by HP - I used the LaserJet 1150 driver from the HP website, and the problem was instantly corrected.

Just to make sure this was the cause of the problem, I installed the LaserJet 1300 driver again and the problem resurfaced. This driver was never any problem when we were using Windows Server 2000.

I'd advise anyone having a similar problem to try downloading either the latest driver, or an alternative one.

I hope that is of some use to anyone having this problem, it was really frustrating.