Helen has attended:
Access Advanced course
Access
I have a highly customised report which currently runs for one record at a time
i.e. it prints the required data (company number, location, turnover etc) about 1 company. I have to call up each record individually and then go to the report and then print it.
I would like to be able to run this report for all companies that meet a particular criterion e.g. all companies listed as active.
How do I do this?
RE: Access
Hi Helen
Thanks for your enquiry. This is beyond the scope of being addressed by the forum, however we may be able to assist in a consultative process.
If you can provide more detail, sample files and key objectives you want to acheive we can review and if we can help then provide you with a quote.
Please contact us if you would like to explore this further.
Regards
Jacob
RE: Access
Then I probably didn't explain it right.
It seems like this should be pretty simple.
I was thinking it should be something that could get done using a macro - using some sequence of cycling through the records on a query and opening the report for each one.....
RE: Access
Hi Helen
Thank you for your question
Could you check two things for me about the form in question?
Please open the form in design view and bring up the form's property sheet. Then click on the data tab
Please check the entries for the "Filter Property" and the "Filter on load property"
Please let me know what if anything is entered there
Thanks
Stephen
