PDA

View Full Version : Access Filter Criteria from Excel



MMQQ
06-28-2008, 11:56 PM
Hello,

This is my first posting and I hope I'm clear enough to explain my situation. I work with a lot of Access (backend) and Excel (front end).

Currently I have a mdb with various queries (ie...)

1) Select Query with 20+ possible fields for filtering
2) Make table query based on 1
3) Append query to tbl 2

This information is then read by Excel through Pivot tables.

Current situation:
Need to train users to go to mdb to open the select query and filter for desired data. Then press macro in mdb to run the make/appends. Then go to excel to press refresh.

Desired situation:
Pivot table in excel that will show all 20+ fields. Allow user to use simple ranges, wildcards to identify required info (this part is somewhat).
Pass this info back to (1) above.
In Excel, run the mdb make/append macros
In Excel, press refresh.

How can I pass filters such as 1 to 5, or like "Vancouver*", all to the select filter? and how can I run mdb macros through Excel?

Thanks,
MM