How do you execute an Access Pgm?

[Jim Cassilly]

For simplicity sake, say I have built one Table (not normalized), one Query
to pull off the fields I want on my Report, and the Report. How do I then
execute the Query and produce the run-time Report? Do I execute the Query
and then the Report???? Or is there a simpler way (by executing just the
Report)????
This is a very basic question, but I am stumped!

Thank you. (Using Access 2007)

Jim Cassilly

 

[Gina Whipp]

Jim,

You can't *run* the query to *run* the report without opening Access and
double clicking or simulating that event. You could open your database via
Windows Scheduler and when it does a form would open that would run your
report... but then do you want it to save your report somewhere? That is
going to require some code...

Also, not sure what is the "..runtime report..." unless you mean the .SNP
report... or maybe you want to create a .PDF?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

For simplicity sake, say I have built one Table (not normalized), one Query
to pull off the fields I want on my Report, and the Report. How do I then
execute the Query and produce the run-time Report? Do I execute the Query
and then the Report???? Or is there a simpler way (by executing just the
Report)????
This is a very basic question, but I am stumped!

Thank you. (Using Access 2007)

Jim Cassilly

 

[John W. Vinson]

For simplicity sake, say I have built one Table (not normalized), one Query
to pull off the fields I want on my Report, and the Report. How do I then
execute the Query and produce the run-time Report? Do I execute the Query
and then the Report???? Or is there a simpler way (by executing just the
Report)????
This is a very basic question, but I am stumped!

Thank you. (Using Access 2007)

Jim Cassilly

If the report's Recordsource is the query....

Just open the Report.

You don't need to separately run the query, or even look at it.

I presume that the query has some sort of criteria - how are you specifying
which records should appear on the report?

 

[Arvin Meyer [MVP]]

Bind the query to the report. That is, using the query as a recordsource for
the report.

Open the report in design view and choose the query from the property sheet
as the recordsource. Then choose each field in the recordsource as the
controlsource of each control in the report. Now, when you open the report,
the query will fill it with data.