If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you execute an Access Pgm?
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 |
#2
|
|||
|
|||
How do you execute an Access Pgm?
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 "Jim Cassilly" wrote in message ... 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 |
#3
|
|||
|
|||
How do you execute an Access Pgm?
On Mon, 15 Mar 2010 21:06:30 -0400, "Jim Cassilly"
wrote: 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? -- John W. Vinson [MVP] |
#4
|
|||
|
|||
How do you execute an Access Pgm?
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. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Jim Cassilly" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|