Search results for query: *

I have been having some slow down problems as well, so I checked the link listed above to Microsoft support. It looks like they released a patch on May 28, 2003. I still need to try it out, though.

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...

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...

I got it to work! The only problem is I had to set up 7 queries, 5 of which create tables, to get it to do what I wanted. The unique query did help to get my Columns on both of the subreports to stay the same, and I set up a macro to first delete the existing temporary tables and then run the...

I went ahead and modified the query. I set the PIVOT clause of the query in SQL view to the new column (PIVOT tablename.[fieldname]). However, I'm still getting the same error. Is there somewhere I need to use this new column as the column heading field that I haven't tried? Thanks for...

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...