I need to create Access Reports using VB6 code. The database is
Access. The idea is to use query to get a recordset, then create a report
using code, then pass the dataset data to the report for display or print.
How do I do that? Thanks.

You'll have to have Access installed on the workstation as well, then you
should be able to use Automation to do it.

Lookup CreateReport in the Help file for how to create a new report.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"codeater" <(E-Mail Removed)> wrote in message
news:5DB28AD7-78D0-4905-BE2B-(E-Mail Removed)...
> I need to create Access Reports using VB6 code. The database is
> Access. The idea is to use query to get a recordset, then create a
report
> using code, then pass the dataset data to the report for display or
print.
> How do I do that? Thanks.
>

Could you provide some sample codes for createreport? Thanks.

"Douglas J. Steele" wrote:

> You'll have to have Access installed on the workstation as well, then you
> should be able to use Automation to do it.
>
> Lookup CreateReport in the Help file for how to create a new report.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "codeater" <(E-Mail Removed)> wrote in message
> news:5DB28AD7-78D0-4905-BE2B-(E-Mail Removed)...
> > I need to create Access Reports using VB6 code. The database is
> > Access. The idea is to use query to get a recordset, then create a
> report
> > using code, then pass the dataset data to the report for display or
> print.
> > How do I do that? Thanks.
> >
>
>
>

Sorry, no I can't, as I don't see the point of developing reports in code.
I always develop my reports in Access.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"codeater" <(E-Mail Removed)> wrote in message
newsBAEFCF0-374B-481F-ACDE-(E-Mail Removed)...
> Could you provide some sample codes for createreport? Thanks.
>
> "Douglas J. Steele" wrote:
>
> > You'll have to have Access installed on the workstation as well, then
you
> > should be able to use Automation to do it.
> >
> > Lookup CreateReport in the Help file for how to create a new report.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no e-mails, please!)
> >
> >
> >
> > "codeater" <(E-Mail Removed)> wrote in message
> > news:5DB28AD7-78D0-4905-BE2B-(E-Mail Removed)...
> > > I need to create Access Reports using VB6 code. The database is
> > > Access. The idea is to use query to get a recordset, then create a
> > report
> > > using code, then pass the dataset data to the report for display or
> > print.
> > > How do I do that? Thanks.
> > >
> >
> >
> >