Callng Cyrstal from Access Form

[GotFish]

Is it possible (relatively simple?) to call a crystal report (not .exe, but .rpt) from a MS Access 2000 form button? Can someone give me a short starter code example on how/where to do this?

 

[kenhamady]

Do you have the developer edition of CR? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[GotFish]

No, Professional Edition...

 

[ucsjimj]

I believe all you need do is use the add-in feature and include Cr. This will allow you to write the necessary vba code to run a Source file of a Crystal Report from Access.

 

[GotFish]

Could you walk me through this, I click on add-in manager in MODULES, and there is nothing there....

 

[kenhamady]

What version of CR do you have?

If you have v8.x, I don't think that you get any integration features (like the VBA control) unless you get the Developer edition.

If you have v9 developer I think they only give you RDC integration, which may not work outside of Visual Basic.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[kenhamady]

I have confirmed that you can use the RDC in VBA.
The following article explains how:

http://support.crystaldecisions.com/library/kbase/articles/c2009907.asp

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com