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

Use the Shell command. See VBA Help for details.
--
Dave Hargis, Microsoft Access MVP


"bbmuggs" wrote:

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

can you be more specific when you enter shell command you get 100 options
--
bb


"Klatuu" wrote:

> Use the Shell command. See VBA Help for details.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "bbmuggs" wrote:
>
> > Can someone provide me the code to automate running a crystal report from
> > access 2007.
> > --
> > bb

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.

--
Dave Hargis, Microsoft Access MVP


"bbmuggs" wrote:

> can you be more specific when you enter shell command you get 100 options
> --
> bb
>
>
> "Klatuu" wrote:
>
> > Use the Shell command. See VBA Help for details.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "bbmuggs" wrote:
> >
> > > Can someone provide me the code to automate running a crystal report from
> > > access 2007.
> > > --
> > > bb

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?
--
bb


"bbmuggs" wrote:

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

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.
--
Dave Hargis, Microsoft Access MVP


"bbmuggs" wrote:

> 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?
> --
> bb
>
>
> "bbmuggs" wrote:
>
> > Can someone provide me the code to automate running a crystal report from
> > access 2007.
> > --
> > bb

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


"Klatuu" wrote:

> 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.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "bbmuggs" wrote:
>
> > 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?
> > --
> > bb
> >
> >
> > "bbmuggs" wrote:
> >
> > > Can someone provide me the code to automate running a crystal report from
> > > access 2007.
> > > --
> > > bb

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.
--
Dave Hargis, Microsoft Access MVP


"bbmuggs" wrote:

> It is the miscrosoft object lbrary that acces uses.
> verion8 but I have tried it with 11 and 2008
> --
> bb
>
>
> "Klatuu" wrote:
>
> > 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.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "bbmuggs" wrote:
> >
> > > 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?
> > > --
> > > bb
> > >
> > >
> > > "bbmuggs" wrote:
> > >
> > > > Can someone provide me the code to automate running a crystal report from
> > > > access 2007.
> > > > --
> > > > bb