Code to autmate run crystal report from access 2007

B

bbmuggs

Can someone provide me the code to automate running a crystal report from
access 2007.
 
K

Klatuu

Have you read VBA Help on using the Shell command?
It is just a way to start another application in Windows from Access. You
just have to write the command line of the program you want to start and its
options. The only other option available in the Shell command is the window
style.
 
B

bbmuggs

the report is now runningbut only the first letter of a text field printson
the report. ibelieve the olb for 12 is the prblem because 2003 uses 11. is
there a fix for thi?
 
K

Klatuu

what is an olb?
Have you checked with Crystal or searched the MS Newsgroups regarding this?
You may get some info there. I know that at least through VB6, it shipped
with a version of Crystal.
 
B

bbmuggs

It is the miscrosoft object lbrary that acces uses.
verion8 but I have tried it with 11 and 2008
 
K

Klatuu

Sorry, what I meant to say was what olb? There are several. What olbs
Access uses depends on the relationships established in VBA.

Crystal is a totally different and non Microsoft product.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make report 0
Crystal reports 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access-Crystal Report 3
HELP PLEASE with Crystal Report 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Access 2002 change report header text 0
Crystal Report SQL Conversion 1

Top