Hi Everyone,
Hopefully this is a simple question for all you gurus out there...
1. The code below populates a report, but nothing except the last record is displayed. So at the moment I have a report 12 pages long displaying only one record. How do I make sure the other records are also...
I can't believe I didn't think of that. I was trying to add things into the report as I generated them, but adding them to a table, and using the table to generate the report is an excellent idea... Not that I've got the report behaving itself just yet, but it's on it's way.
Thanks again!
Hi Everyone,
I have a program that uses a loop to generate information.
Here is an overview
Outer Loop (using counter X)
Inner Loop (using counter y)
generate query using variables X & Y
execute query
call report function
End Inner Loop
End Outer...
Dhookom??????
Hi Darude, I don't mean to hijack your thread, but Dhookom alluded to a solution that would fix my problem.
My problem would be solved by using the same report and inserting page breaks between the sections of the report.
At the momment, my code generates all the info, and...
Hi,
I think my question may not have been clear enough.
I am dealing with Reports and Subreports (not forms)- I have been able to set the recordsource using VBA with the following code in the open action of the subreport
me.recordsource = rst_roles1.name
I want to display the returned info...
Ken,
Thanks a lot for your quick reply!
The field count works perfectly!
I am however, still confused by the recordsource solution you gave. I have put the line of code
Me.MySubFormControl.FORM.RecordSource = YourSQLStatement in the open action of my subreport, it reads...
Hi,
I have created a parent report which is based on a standard query. In the text field of the report I specified the control source to be "userID". However, the subreport is based on a query which is dynamically generated by VBA (it uses a loop which compares as below
table A field 1 with...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.