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 to refer report's recordset ?
I create a crosstab query and use it as my report recordsource. Because I
can not predict which column (return from query) will be exist, So I think I will create enough unbound text boxes in report to display return columns. Afer try, I found problem that I can not refer to those columns in term Me.Recordset!ExpectedColumnName within Detail_Print event. Actually Recordset is not available. How to solve this problem ? TIA Malee |
#2
|
|||
|
|||
There are several examples of crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. If your columns are date intervals then there is a much easier method. -- Duane Hookom MS Access MVP -- "Malee" wrote in message ... I create a crosstab query and use it as my report recordsource. Because I can not predict which column (return from query) will be exist, So I think I will create enough unbound text boxes in report to display return columns. Afer try, I found problem that I can not refer to those columns in term Me.Recordset!ExpectedColumnName within Detail_Print event. Actually Recordset is not available. How to solve this problem ? TIA Malee |
#3
|
|||
|
|||
Malee wrote:
I create a crosstab query and use it as my report recordsource. Because I can not predict which column (return from query) will be exist, So I think I will create enough unbound text boxes in report to display return columns. Afer try, I found problem that I can not refer to those columns in term Me.Recordset!ExpectedColumnName within Detail_Print event. Actually Recordset is not available. In the versions before the Recordset property was introduced, I used the ugly and sometimes slow technique of opening a recordset on the recordsource, which won't work with some types of filtering: Set rs = db.OpenRecordset(Me.RecordSource) -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Shifting Weeks for Quarterly Reports | setoFairfax | General Discussion | 1 | September 8th, 2004 05:43 PM |
list boxes in reports | Mia_placidus | Setting Up & Running Reports | 1 | August 1st, 2004 10:35 PM |
limiting access to reports | JMorrell | General Discussion | 3 | July 28th, 2004 03:52 PM |
Need help w/ reports | Tom | Setting Up & Running Reports | 0 | June 25th, 2004 05:59 PM |
ACCESS Reports | Steve | Setting Up & Running Reports | 2 | June 7th, 2004 02:58 PM |