| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Parameter Query
I was able to make Excel pop-up a parameter dialogue box by creating macro and changing the "SELECT ... " statement by adding the "WHER field = ?" clause. However, it does not give a descriptive prompt something like "Enter the branch code". In MS Query, it work something like this: "SELECT ... WHERE branch = [Enter the branc code] -- bcha ----------------------------------------------------------------------- bchan's Profile: http://www.excelforum.com/member.php...nfo&userid=827 View this thread: http://www.excelforum.com/showthread.php?threadid=27008 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Macro for Parameter Query | Excel Programming | |||
| Parameter Query executed from a Macro | Excel Programming | |||
![bchan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
