Printing Crystal Report in Access 2003

[1897]

In Access 2000 i was using the ActiveX Plugin Object to print Crystal Reports. I have just moved to Access 2003 and am getting the Error 'Microsoft Office Access doesn't Support this ActiveX Control'.
Basically i have about 20 different letters set up as Crystal Reports. I open a recordset which has two fields OrderNo and LetterTemplate (LetterTemplate being what letter i need it to print).
It opens the required letter then passes the OrderNo as a parameter which the letter then print with this OrderNo on.
This is the code i have which works great in Access2000 with an ActiveX Plugin Object(CrystalReport1).

Do
Do While rst.EOF = False
With rst
StrOrderNo = rst![OrderNo]
strLetter = rst![TemplateRef]
CrystalReport1.ReportFileName = "C:\Path\" & strLetter & ".rpt"
CrystalReport1.ParameterFields(0) = "OrderNo;" & StrOrderNo & ";true;"
CrystalReport1.PrintReport
rst.MoveNext

End With
Exit Do
Loop
Loop Until rst.EOF = True



Any idea on how to get rid off this error or can anyone suggest another way i should be doing it.

Thanks

 

[MrBillSC]

You could either recreate the letters as Access reports or you could create them a Word documents and mail merge with the Access table or an Access query. You can select any table or query defined in an Access data base as your data source for a mail merge.

MrBill