I need help in parameterization a query in msaccess without use of design view in MSaccess.
Can someone provide sample queries as how to parameterize the query.
I need help in parameterization a query in msaccess without use of design view in MSaccess.
Can someone provide sample queries as how to parameterize the query.
What do you mean by 'without use of design view'? How can you build a query without design view?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I guess you could use VBA and QueryDefs
In addition to June's questions what does your parameter consist of? Are you simply trying to add a WHERE clause to an existing Saved Named Query Object? There are a couple of approaches I use to do this. How it gets done depends on when and why it needs to be done.