Re: How to Run an Access Report

From: M.L. Sco Scofield (Sco_at_ScoBiz.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 12:46:38 -0600

Well, if Access is installed and you want to use automation, article 296586
has everything you need.

Again, good luck.

Sco

"Kobeobo" <kobebus@erols.com> wrote in message
news:410A88C8.B17941A1@erols.com...
> Sco, first off - sorry for posting in this newgroup - this was in error, i
> thought i was in a vb group. Anyway, since you have responded and asked a
> question (your 4th para), i guess i am trying to use automation as all i
want
> to be able to do is print the access report from vb6... and yes Access is
> installed on the PC.
> Baz
>
> "M.L. Sco Scofield" wrote:
>
> > Baz,
> >
> > As you are trying to do something *from VB*, this is really a question
for
> > one of the 36 VB groups that all start with microsoft.public.vb.
> >
> > (If you were trying to run a VB program *from Access*, this might have
been
> > the right group to ask your question in.)
> >
> > With that advice out of the way, you can't use any "Access" objects in
an
> > mdb file outside of Access. Using an mdb file for data in VB is *NOT*
using
> > Access. You are using the "Jet" data portion of the mdb file.
> >
> > What you can do is use "automation" to control Access from VB and print
out
> > reports. This does require that Access is installed on the computer you
are
> > trying to do this.
> >
> > Take a look at the article at
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;296586.
> >
> > If you are trying to make a VB only solution, VB includes Crystal
Reports
> > for making and distributing reports.
> >
> > Good luck.
> >
> > Sco
> >
> > "Kobeobo" <kobebus@erols.com> wrote in message
> > news:41081DE4.FAB55537@erols.com...
> > > Hi guys, sorry if this has been covered before...
> > >
> > > I have a VB6 program using Access V2000 as the database. The Access DB
> > > has several reports,
> > > does anyone know how to execute (run) an Access report from within
VB6?
> > >
> > > Thanks
> > > Baz
> > >
>

Relevant Pages

  • Re: The manc reaction
    ... How many reports have you read that said we were lucky to get a point or ... We've had more than our share of luck so far this season - and whilst you ... that kind of behaviour will be the reason that so many ... We've had more lucky wins than anyone this season, ...
    (uk.sport.football.clubs.liverpool)
  • Re: How to Run an Access Report
    ... Sco, first off - sorry for posting in this newgroup - this was in error, i ... > If you are trying to make a VB only solution, VB includes Crystal Reports ...
    (microsoft.public.access.modulesdaovba)
  • Re: Too Many Fields - Reports and Queries
    ... I went through your list of fixing a corrupted database...no luck ... The only difference between the two queries is they filter ... work but both reports produce the "too many fields defined" error. ... what leads me to believe that the query itself ...
    (microsoft.public.access.reports)
  • Re: SCO Group
    ... On Sat, Sep 20, 2003, Timothy Luoma wrote: ... >I tried to find some information and had no luck. ... IANAL -- the critters at SCO probably wish that one would go away ... The difference between science and the fuzzy subjects is that science ...
    (freebsd-questions)
  • Re: Cant build threaded perl 5.8 on 6.2-RELEASE and 7-CURRENT
    ... have tried some option combinations with no luck, ... is specified then the build would fail with a coredump. ... I've got more reports about that. ...
    (freebsd-stable)