firemark1817
New Member
- Joined
- Feb 20, 2005
- Messages
- 6
I have an Excel Pivot report setup that runs a parameter query when the file is opened. It prompts for a File Number and then retrieves the data from a SQL source. Here's the code of the parameter query.
SELECT * FROM DI_Bronze.dbo.V_DIL212 V_DIL212 where V_DIL212.UDS_CLAIM = ?;
This works quite well as a standalone Excel Report.
The issue is that I also have an Access DB Form with details about each file where a user has to enter information. In many cases they need to review the Pivot Report for the current file displayed on the Access Form.
There's no problem using a URL link to open the Pivot Report. The issue is, how to also pass the current file number from the Access form to the Excel parameter query.
Everything I've searched for so far shows only half a solution. Our users are going to be doing this about 5,000 times so it's important to minimize the number of clicks to get the data. Copy/Paste works but will give people carpal tunnel with so much repetition.
I tried searching options for opening Excel via a command line but cannot get it to accept and retain the File number parameter. Any suggestions for doing so or finding another way to accomplish the same result are welcome.
SELECT * FROM DI_Bronze.dbo.V_DIL212 V_DIL212 where V_DIL212.UDS_CLAIM = ?;
This works quite well as a standalone Excel Report.
The issue is that I also have an Access DB Form with details about each file where a user has to enter information. In many cases they need to review the Pivot Report for the current file displayed on the Access Form.
There's no problem using a URL link to open the Pivot Report. The issue is, how to also pass the current file number from the Access form to the Excel parameter query.
Everything I've searched for so far shows only half a solution. Our users are going to be doing this about 5,000 times so it's important to minimize the number of clicks to get the data. Copy/Paste works but will give people carpal tunnel with so much repetition.
I tried searching options for opening Excel via a command line but cannot get it to accept and retain the File number parameter. Any suggestions for doing so or finding another way to accomplish the same result are welcome.