Microsoft Office Access Doesn't Support This ActiveX Control

[1897]

I've just moved to Office 2003 from Office 2000 and on my Access Form have an ActiveX Control that links to a Crystal Report and Prints from Access2003, but i am getting the error 'Microsoft Office Access Doesn't Support This ActiveX Control'.

Thanks
Beth

 

[lupins46]

Do you have any reason to doubt that the message is true? Maybe you need a later version of CR. What version have you got?

 

[1897]

I'm using Crystal Report 10. In Access 2000 i was using the ActiveX Plugin Object to print these reports.
Maybe if i explain what i'm trying to acheive you can point me in the right direction. 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

 

[lupins46]

Don't have v10 here so can't test.
You might also consider posting the Q in a Crystal forum.

 

[ZmrAbdulla]

these may help you
Google Groups
Image Handling Activex


Zameer Abdulla
Visit Me