Access Reports in VB6

[Altair Brito]

Hello everyone,

I am programming a simple VB6 program to add data to an Access DB and
retrieve reports from it depending on the criteria.

I was trying to create the reports inside VB6 using the DATAREPORTS but I
was unsuccessful because I realized it was hard to create the print outs and
group them. I was not able to group them.

So I then used the Access Reports to create the reports I needed, which
worked beautifully. It gave me all the data I needed, but I don't want users
to open the Access DB and go to reports in order to see them because they
just might mess with other parts of the DB. The problem I'm having right now
is how to printout or show those reports I made from Access in my program.

1. Is there any way you guys can tell me how to do this, or is there another
method to simplify what I plan on doing.? How do I printout Access Reports
from VB6.

2. Is there a way I can create these reports in VB other than in Access.?

3. Using this connection how would I go about grouping it by NAME because
every time I try it gives me an error saying that I tried to use an
operation that did not include ³one of the fields below²:
rs.open "SELECT FROM name, dateadded, credit, debit, paid FROM
customers"

Thank you in advanced for all you help.

Best regards,
Altair Brito

 

[Altair Brito]

Access Reports in VB6You could use Access automation to open access and run
the reports, however most people using VB would use another reporting tool
like ActiveReports or Crystal reports.

You could think about changing your program to be in Access instead of VB6 and
use the access runtime if needed. If you go this route of course you would
use Access for the reporting.

My two cents,
Mark Andrews
RPT Software
http://www.rptsoftware.com

Hello everyone,

I am programming a simple VB6 program to add data to an Access DB and
retrieve reports from it depending on the criteria.

I was trying to create the reports inside VB6 using the DATAREPORTS but I
was unsuccessful because I realized it was hard to create the print outs and
group them. I was not able to group them.

So I then used the Access Reports to create the reports I needed, which
worked beautifully. It gave me all the data I needed, but I don't want users
to open the Access DB and go to reports in order to see them because they just
might mess with other parts of the DB. The problem I'm having right now is how
to printout or show those reports I made from Access in my program.

1. Is there any way you guys can tell me how to do this, or is there another
method to simplify what I plan on doing.? How do I printout Access Reports
from VB6.

2. Is there a way I can create these reports in VB other than in Access.?

3. Using this connection how would I go about grouping it by NAME because
every time I try it gives me an error saying that I tried to use an operation
that did not include "one of the fields below":
rs.open "SELECT FROM name, dateadded, credit, debit, paid FROM
customers"

Thank you in advanced for all you help.

Best regards,
Altair Brito

Thank you for your quick response. So how would I go about creating Crystal
reports in VB6.?

A.Brito

 

[Mark Andrews]

I'm more of an Access guy. You use some kind of Crystal control that serves
as the report viewer and you use the Crystal product to write the report
itself. There should be lots of examples of creating a crystal report
in VB6. However VB6 is getting kinda old, perhaps you should be using .net?

Try this to start:
http://www.google.com/search?source...z=1T4GGLL_en&q=using+crystal+reports+with+vb6

Mark