I'm supporting a small single user system that is deployed to various laptops.
Other than the faults and bugs I've introduced myself the things that give me most problems are printers.
They, the problems, don't always appear to be linked to the printers.
I have had many and varied problems that have resulted in it being a printer problem.
This is one that happened the other day...
For some reason, one user managed to 'lose' his default printer.
He rang me complaining that he got
1. some error message when accessing a report. I can't remember the actual error but t in no way suggested a printer problem.
2. On another report he got a spinning circle.
The code in each case was
1. DoCmd.OpenReport "A report", acPreview
Actually this line is processed if the user is a "power" user. If they are not a slightly different report is called. This is basically a copy of the 1st report with some fields not displayed. So in the code below the if bit produces the error and the else works.
If PenuserName = "PowerUser" Then
DoCmd.OpenReport "A report", acPreview
Else
DoCmd.OpenReport "2Copy of A report more or less", acPreview
End If
2. DoCmd.OpenReport strDocName, acViewPreview, , "[strOrderNumber]='" & Me.strOrderNumber & "'", , TYP
strDocName is a string set to the report name. This module also has this code in On Error GoTo Err_BT_PRINT_Click.
So how do I capture any printer problem whatever it may be?
Other than the faults and bugs I've introduced myself the things that give me most problems are printers.
They, the problems, don't always appear to be linked to the printers.
I have had many and varied problems that have resulted in it being a printer problem.
This is one that happened the other day...
For some reason, one user managed to 'lose' his default printer.
He rang me complaining that he got
1. some error message when accessing a report. I can't remember the actual error but t in no way suggested a printer problem.
2. On another report he got a spinning circle.
The code in each case was
1. DoCmd.OpenReport "A report", acPreview
Actually this line is processed if the user is a "power" user. If they are not a slightly different report is called. This is basically a copy of the 1st report with some fields not displayed. So in the code below the if bit produces the error and the else works.
If PenuserName = "PowerUser" Then
DoCmd.OpenReport "A report", acPreview
Else
DoCmd.OpenReport "2Copy of A report more or less", acPreview
End If
2. DoCmd.OpenReport strDocName, acViewPreview, , "[strOrderNumber]='" & Me.strOrderNumber & "'", , TYP
strDocName is a string set to the report name. This module also has this code in On Error GoTo Err_BT_PRINT_Click.
So how do I capture any printer problem whatever it may be?