| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass Parameter to Access Query
I'm using the following code to open a query in Microsoft
Access. Sub Test() Dim appAccess As New Access.Application appAccess.OpenCurrentDatabase "c:\reports\test.mdb" appAccess.DoCmd.OpenQuery "query3" End Sub I've made the query, query3 a parameter query and i would like the query to pick up a parameter value from my Excel worksheet. How might I do this? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pass parameter to access query | Links and Linking in Excel | |||
| Pass date parameter into MS Query | Excel Discussion (Misc queries) | |||
| Is it possible to pass a parameter into IN operator in Query? | Excel Discussion (Misc queries) | |||
| MS query--can it handle parameter queries from Access? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
