Forum home » Delegate support and help forum » Microsoft Access Training and help » Using Macro to change Record Source in Reports
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Using Macro to change Record Source in Reports
Resolved · Low Priority · Version 2007
Reply Mon 30 Jan 2012, 10:48Delegate James said...
James has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Using Macro to change Record Source in Reports
This is a simple document / template retrieval system.
I have one report in one style which, when generated offers hyperlinks to the required document or template.
It can run many alternative queries (I'm interested in 123 permutaions)
I have a grid of command buttons on a single control panel.
Each button represents one query and the associated report.
How, with one click of the button, do I get the query to select the correct parameters, return the data for and become the link in the record source of the report that I want to view?
The idea is one click to see what is available, and one click to access the resource.
The simpler to understand the better please. I'm brand new at this.
For upcoming training course dates see: Pricing & availability
RE: Using Macro to change Record Source in Reports
Hi James
Thanks for your post. We may well be able to find a solution but we will need to see your files to investigate further.
As this falls outside the scope of this forum what we would ask is for you to email your files to us we can then let you know if a solution can be found, trainer development time required and any related costs.
Please drop me an email if you are interested in looking at this further.
Kind regards
Jacob
|