Manipulate values in report using VBA

B

Brian Paddock

I am having trouble looping through the report collection. I have to do this at the reporting stage as the actual data values cannot be changed. The problem lies in using VBA to analyse each report value.
Just cant seem to get this right.
Please help, many thanks
Brian
 
J

Jeff Boyce

Brian

No data, no SQL, no way to help.

By the way, in Access, the "report collection" is the collection of report
objects... do you mean you are trying to iterate through a recordset that
you'll use in a report?

And, from your description, I can't tell why you are using "VBA to analyze
each report value", rather than a query.

More info, please...

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Drop down list control value in vba 2
Access 2007,reports,VBA 2
Using VBA to manipulate Reporting 5
How to modify and updte specific styles for specific paragraphs across the document 0
Macro for manipulating data 0
Report prints extra page on one computer 3
Grabbing Info from a TextBox on a Report 2

Top