Home |
Search |
Today's Posts |
#1
|
|||
|
|||
List Box Input to query
I orchestrated my first VB yesterday... So I am a novice. I am not sure what you mean... I have used filter and wuto filter before, but how do I incoroprate it into my VB code so it is automated. Currently I manually pull data via ODBC For eg. select x from Y where z 1000 and dt = 20041231 What I want to be able to do is to input x and z 1000 and pass it to the query t run. I was able to this with the dt = part yesterday where I pass in the date. And that took a whole day. I am not sure how to do the rest.. like being able to select a item frm a list and have it represent x. Thanks in advance. -- Anusha ------------------------------------------------------------------------ Anusha's Profile: http://www.excelforum.com/member.php...o&userid=27119 View this thread: http://www.excelforum.com/showthread...hreadid=466406 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) |