Hi
I've been creating a database for a client. They have two pc's running off a server. We've had two issues crop up on one pc that don't crop up on the other. I'm thinking it might be something do with the access installation or windows rather than the database but want to run it past someone to see if they agree.
One error happens when we try to print preview a report. The message is:
There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable.
Is there something I can do in Access to check/resolve this, or would it be at the printer end (and therefore for their IT guy)?
The second error is when I click a button to open a report. It works fine on my pc and on one of theirs but when I try on the problem one it takes be to the debug of VB. It doesn't like the DoCmd.OpenReport line. My code is as follows:
Private Sub cmdOpnFax_Click()
If DLookup("[FaxType]", "Suppliers", "[SupplierID] = Forms!OrderHeader!SupplierID") = 2 Then
DoCmd.OpenReport "OrderFaxHeaderDoors", acViewPreview, acEdit, "[OrderID]=Forms!OrderHeader!OrderID"
ElseIf DLookup("[FaxType]", "Suppliers", "[SupplierID] = Forms!OrderHeader!SupplierID") = 1 Then
DoCmd.OpenReport "OrderFaxHeaderComponents", acViewPreview, acEdit, "[OrderID]=Forms!OrderHeader!OrderID"
End If
End Sub
I can't see why that code should work fine on two pcs and not on another? I tried reinstalling the front end but it was the same.
Any suggestions greatly appreciated!
Thanks