Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamic crosstab report totals are incorrect
I have set up a dynamic crosstab report from the sample in the Microsoft Solutions database. This works just fine while the report is less than one page in length. After that, the variables that hold the column totals and the grand total appear to be resetting themselves. Does anyone know how...- Carma
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Subreports won't print after code is changed from DAO to ADO
I have a report with two subreports containing dynamic crosstabs. These were originally run with DAO code. I have been converting the code to ADO. When the code was written in DAO, I could view the report and subreports and print these directly from Print Preview. However, when I converted...- Carma
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
-
Set ColumnHeadings Property of Crosstab Query for Subreport with VBA?
Does anyone know how to define the Column Headings property in a crosstab query with VBA in Access 2000? The code would need to change the column headings everytime a report is run so the included headings are only those that have data, according to the criteria that is set at the time. I have...- Carma
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
