Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Error 20520: Job Already Started

Error 20520: Job Already Started

Error 20520: Job Already Started

I am writing a VB5 app that has an MS Access 97 back-end and Crystal Reports 4.6.1 for the reporting tool.

One of my reports runs fine the first time, but--after I run it and then run a different report and then come back the the first report to run it again--I get the following error: 20520: Job already started.

How do I keep this malady from occuring?


RE: Error 20520: Job Already Started

I face this problems too but manage to solve it by:

1. create only 1 crystal report object in throughout the whole application ie. the main     menu.
2. create 1 global function to print report and handle the error handler there.
3. initialise all report fomulas before .printreport it.

->this will also solve the formula error.

Function PrintReport() As Boolean
   mMain.MousePointer = vbHourglass
   mMain.CReport.ReportFileName = RptPath + RptName
   mMain.CReport.SelectionFormula = gString
   mMain.CReport.Formulas(0) = gFormula0
   mMain.CReport.Formulas(1) = gFormula1
   If mMain.CReport.LastErrorNumber <> 0 Then
      PrintReport = False
      mMain.MousePointer = vbDefault
      MsgBox mMain.CReport.LastErrorNumber & " : " & mMain.CReport.ReportFileName & " : " & mMain.CReport.LastErrorString,  vbInformation + vbOKOnly, "Attention"
   End if
   PrintReport = True
End Function

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close