Openreport Action was cancelled problem

[panadoll]

I have a few users using a vb application with access reports. Right now, one of my users have encountered an error message when she tries to print one of the reports. This problem only happens to her own pc. When she print the same report from the same copy of the vb application at other users' pc, it works well. I do not know what was wrong with her pc or is there something wrong with my codes.

Appreciate your help. Thanks

The following are the codes for the printing of the report:

Private Sub cmdPrintJobCost_Click()
MousePointer = 11
On Error GoTo errmsg

Dim msaccess As access.Application
Dim s As Variant
Dim sql As String
Dim i As Integer, c As Integer

Set msaccess = New access.Application
'ReportPath = "G:\Newgui\Finance\FinanceReports.mdb"
With msaccess
.OpenCurrentDatabase ReportPath, False
s = .Run("This_OrderIdx", OrderIdx)
.DoCmd.OpenReport "rptJobCost", acViewPreview
.DoCmd.Maximize
.Visible = True
End With

Set msaccess = Nothing
MousePointer = 0
Exit Sub

errmsg:
msaccess.Quit acExit
Set msaccess = Nothing
MsgBox Err.Description, vbInformation, App.Title
Err = 0
Unload Me
End Sub

 

[scriverb]

See thread: thread703-376940

I think think this is a double-post Bob Scriver

 

[panadoll]

hi.. what do u mean by a double post?

 

[scriverb]

This same problem is posted twice under your name in this form. But, the Titles are different.

See Thread: Thread703-376940 Bob Scriver

 

[panadoll]

It is a different problem from the other one. This Openreport action problem only happen to one of my user. The rest of the users who are using the same report from other workstations do not have this problem.

As for the other problem, it happen to the other user, and the rest of the users have no problem opening that report, which is quite a mystery. I really do not know what happen to them. Does it got to do with their workstation??