| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter Access query results based on selected information
I am a newby to VBA, but I could use some help with some code to filter data
imported from Access based on selected information from a cell within Excel. For example, in cell A1 I have a drop-down list of vendor names, when I select Acme from this list, I would the queried information (from Access) for purchases ("Purchase" tab) to be updated with only purchases from Acme (or what ever vendor I have chosen). Any thoughts? Thanks! -- Drew |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access Database based on user selected parameters in Excel | Excel Programming | |||
| Filter query results with a cell value | Excel Programming | |||
| Run SQL against Access DB/Filter Results | Links and Linking in Excel | |||
| Why are access query results different in Excel | Excel Discussion (Misc queries) | |||
| Getting Information from a query in ACCESS | Excel Worksheet Functions | |||
Threaded Mode
