Programmaticaly execute stored report?

[Wolfie7873]

Working in Visual C++.NET 2003. Want to programmatically execute a stored report. Basic question is "is it possible?" If so, is someone willing to share a reference title or code snippet that could help?

Thanks in advance,
Ed

 

[dhookom]

Check out this MS KB article "HOW TO: Use Automation to Print Microsoft Access Reports in Access 2000"

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

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]

 

[Wolfie7873]

OK, i'm going to ask a dumb question now. Will an end-user of an application that uses these tricks be able to succesfully run the program if they don't have MS Access stored on their computer?

Here's what I'm trying to do. I'm writing a piece of database management software using Visual C++, and I want to exploit as much of what's already built into Access as I can to cut out my overhead. My intention is to have basically a fancy user-controlled front-end on an *.mdb file that contains all the tables, relations, queries, and reports that the user would need. But, it needs to be a standalone application. I'm not well versed in Basic, but willing to learn. So what I need is someone to tell me if I can exploit Access without the actual program resident on the end-user machine (again, i know, a dumb question). The finished product will also have a great deal of serial port I/O, so I'd rather stick to a language I already know. But, if Basic is what I need, I'm willing to learn.

Any thoughts?

 

[dhookom]

In order to run Access reports (through automation or whatever) the PC must have Access installed.

The referenced article explains running/calling/opening an Access report with either the retail or run-time version installed.

You can access the data from an MDB without a version of Access being installed. However, you must have some version of Access installed in order to open forms or reports in Access.

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]