Program Access Reports

[macca18]

Hi,

I am currently using Visual C++ with Access to store my data.

I then extract the data,using input from user to build query, i want from Access and put it in an excel spreadsheet which i display to the end user.

My question is, can i remove the need to extract the data from the database and display it using excel and instead, use Access Reports some way from within my VC++ code to display the contents to the user?

Thanks In Advance
Macca

 

[dhookom]

If the user has Access loaded on their PC, you should be able to use automation to open an instance of Access and run the report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[macca18]

Duane

Thanks for the answer.

Do you know any good resources where i can find out about using automation with access?

I have used automation with excel from examples on the microsoft site but cant find much to do with access,

Regards
Macca

 

[dhookom]

Douglas J. Steele answered this question in public news groups on Mar 2:

I think it's covered somewhere in the following KB articles:

ACC: How to Use Automation to Print Microsoft Access Reports:

http://support.microsoft.com/?id=145707

ACC2000: How to Use Automation to Print Microsoft Access Reports

http://support.microsoft.com/?id=210132

ACC2002: How to Use Automation to Print Microsoft Access Reports

http://support.microsoft.com/?id=296586

ACC: Using Microsoft Access as an Automation Server

http://support.microsoft.com/?id=147816

ACC2000: Using Microsoft Access as an Automation Server

http://support.microsoft.com/?id=210111

--


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]