Previewing Reports through Visual Basic

[MrSR]

Is it possible to preview a report through automation without being able to get into the database. i just want the previewed report to show up without the user being able to get into the database. i know how to automate it i just cant find that part.

 

[MajP]

There are a few functions out there using API to hide the Application window
FAQ705-2562

You should be able to open the application, hide the application window, and show the report.

I have never done it with a report, but only with forms. I know with forms it looks as if the form is stand alone.

 

[MajP]

http://www.mvps.org/access/api/api0019.htm

 

[MrSR]

thanks i am going to give it a try

 

[traingamer]

You could also create a report snapshot and let them use the snapshot viewer.

You can find out a great deal about this by looking at the Access help for snapshot.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard