Access2000 VB6 Project

[Thebrads]

Hi,
My daughter has a college project which involves making a relatively simple
database for orders and invoicing. We can make all the reports and queries
etc fine in access. This twist however is that it has to be controlled by a
VB6 front-end. I can use the VB6 datacontrol and get it to input and show
data and with a bit of code make it validate OK, but can anybody tell me how
to make it print access reports etc.

Regards

Ray Bradshaw

 

[Cheryl Fischer]

You and your daughter might want to review the following MS Knowledge Base
article:

Using Microsoft Access as an Automation Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;147816

The article was written for Access 97 but in principle should work the same
for Access 2000.

 

[Douglas J. Steele]

The Access 2000 version is http://support.microsoft.com/?id=210111 (but as
Cheryl says, there's really no difference from Access 97).

You might also want to check http://support.microsoft.com/?id=210132

Note that you must have Access installed on the workstation for this to
work. And no, there's no way to use an Access report that doesn't have this
restriction.

 

[Thebrads]

Thankyou to Cheryl and Doug for your invaluable help.

Regards

Ray Bradshaw