Report Output Errors

From the db, I can run any one of 60 reports individually and the report
outputs are error-free. I set up a macro to automate the process and the
reports are coming back with missing information. Seems like a very simple
process but I cannot locate any errors in syntax or with the tables/queries
generating the reports. Any help is GREATLY appreciated.

can you provide any information about the process used to run the reports
individually? Are there parameters, criteria, user interaction,...?

--
Duane Hookom
Microsoft Access MVP


"Simms" wrote:

From the db, I can run any one of 60 reports individually and the report
outputs are error-free. I set up a macro to automate the process and the
reports are coming back with missing information. Seems like a very simple
process but I cannot locate any errors in syntax or with the tables/queries
generating the reports. Any help is GREATLY appreciated.

Simms wrote:

From the db, I can run any one of 60 reports individually and the report
outputs are error-free. I set up a macro to automate the process and the
reports are coming back with missing information. Seems like a very simple
process but I cannot locate any errors in syntax or with the tables/queries
generating the reports.


I've seen that effect when trying to open the same report
object repeatedly.

--
Marsh
MVP [MS Access]

I have a form using a combo box with a drop down menu. After selecting an
item in the drop down, The output is built from a report and sub report
running off two separate queries. The subreport uses 4 union queries. The
data used to populate the queries is based on the selection in the drop down
and a cross reference between 4 tables.



"Duane Hookom" wrote:

can you provide any information about the process used to run the reports
individually? Are there parameters, criteria, user interaction,...?

--
Duane Hookom
Microsoft Access MVP


"Simms" wrote:

From the db, I can run any one of 60 reports individually and the report
outputs are error-free. I set up a macro to automate the process and the
reports are coming back with missing information. Seems like a very simple
process but I cannot locate any errors in syntax or with the tables/queries
generating the reports. Any help is GREATLY appreciated.

This sounds fairly complex. Are all 60 reports different or are you printing
some reports more than once with different criteria? If you are using
different criteria selected from a combo box, how did you automate this?

It seems you are not telling us nearly enough significant information.
Please be more complete.

--
Duane Hookom
Microsoft Access MVP


"Simms" wrote:

I have a form using a combo box with a drop down menu. After selecting an
item in the drop down, The output is built from a report and sub report
running off two separate queries. The subreport uses 4 union queries. The
data used to populate the queries is based on the selection in the drop down
and a cross reference between 4 tables.



"Duane Hookom" wrote:

can you provide any information about the process used to run the reports
individually? Are there parameters, criteria, user interaction,...?

--
Duane Hookom
Microsoft Access MVP


"Simms" wrote:

From the db, I can run any one of 60 reports individually and the report
outputs are error-free. I set up a macro to automate the process and the
reports are coming back with missing information. Seems like a very simple
process but I cannot locate any errors in syntax or with the tables/queries
generating the reports. Any help is GREATLY appreciated.