Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Call & print a report from Access

Status
Not open for further replies.

StephHansen

Programmer
Dec 26, 2001
87
IN
Can I open a saved CR report via a button in Access, refresh the values in it, and tell it to print (and hopefully close CR?

Thanks!


Stephanie Nicholas
Software Engineer
i-Net Strategy
 
We are using CR 9, will this work there?

Thank you for your response! Stephanie
 
I don't believe the OCX is supported in CR 9.0
You can probably use the RDC though.
For a good introduction on these topics, see Ken Hamady's VB Guide:

If you are not comfortable writing this type of code yourself, consider using a commercially available utility
(see list of Third Party Add-Ons at:

My Visual CUT software ( can easily do what you are looking for if you simply issue a RUN command (with command line arguments specifying the report and optionaly parameter values, specific printer destination(s), etc.) from your Access button.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Anyone have any ideas for printing in CR9?

Thank you for your help! Stephanie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top