B
bbmuggs
Can someone provide me the code to automate running a crystal report from
access 2007.
access 2007.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Klatuu
Use the Shell command. See VBA Help for details.
B
bbmuggs
can you be more specific when you enter shell command you get 100 options
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.
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?
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.
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
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.
Access uses depends on the relationships established in VBA.
Crystal is a totally different and non Microsoft product.