Search results
-
K
SQL result into an Array
VB newbie, hope you can help My objective is to query a table for distinct values in PhyState, then use the resulting list to pass each state to another query where the results will be exported to Excel Steps: 1. Get list of states 2. Loop through list of states passing the state code to a...- kschuster
- Thread
- Replies: 2
- Forum: Modules & VBA
-
K
Import SELECTED text file
I tried the Macro route and came to a screeching halt when asked for the file name. I think I need to use code instead of macro - looking for help. Knowns 1. Import Fixed Width 2. Specification Name 3. Table Name How would I code this to use the Specification already created and PROMPT the...- kschuster
- Thread
- Replies: 1
- Forum: Modules & VBA
-
K
This has to be easy
New to Access2002 I have created an unbound seach form. I'm using ADO to query a table. I want to display the results, if any, on the same form then allow the user to click into the result list for more detail. What I can't figure out is how to display the result set. I have read the way to...