Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Combo Box Values to Access Table
Hello,
I am trying to create a combo box and link it to values in an access table. The access table has a list of well names, dates, rates and hours and several other columns that I am not interested in. I need the combo box to be populated with the well names, and when I select one I would like it to return 3 columns with the Date, Rate and Hours. I have already tried DataExternal Data ... but the problem is that there are too many columns for excel and therefore I am missing a lot of my data, so I need it to pull directly from Access. To summarize 1) Create combo box linked to Well Name Column in Access Table 2) When Well name is selected in combo box fill out columns in Excel with Date, Rate and Hours from Access Table Thanks a lot, ALaw |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Combo Box Values to Access Table
ALaw,
If the data in Access table is relatively static (meaning unlikely to change during Excel session), then you can populate a Range on a hidden worksheet with the values from your Access table on Workbook_Open event. Then populate your combo with the values from the range, and have the corresponding lookup cells use VLookup on the range - this way the values will automatically display after updating the combo Hope this helps "ALaw" wrote: Hello, I am trying to create a combo box and link it to values in an access table. The access table has a list of well names, dates, rates and hours and several other columns that I am not interested in. I need the combo box to be populated with the well names, and when I select one I would like it to return 3 columns with the Date, Rate and Hours. I have already tried DataExternal Data ... but the problem is that there are too many columns for excel and therefore I am missing a lot of my data, so I need it to pull directly from Access. To summarize 1) Create combo box linked to Well Name Column in Access Table 2) When Well name is selected in combo box fill out columns in Excel with Date, Rate and Hours from Access Table Thanks a lot, ALaw |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Combo Box Values to Access Table
Thanks Sergey,
I have thought of doing this but my data in excel does not fit into an excel worksheet. I am still using Office 2000 at work, and excel will only let me fill in ~65000 cells. Thanks though! On Dec 9, 4:02*pm, Sergey Poberezovskiy wrote: ALaw, If the data in Access table is relatively static (meaning unlikely to change during Excel session), then you can populate a Range on a hidden worksheet with the values from your Access table on Workbook_Open event. Then populate your combo with the values from the range, and have the corresponding lookup cells use VLookup on the range - this way the values will automatically display after updating the combo Hope this helps "ALaw" wrote: Hello, I am trying to create a combo box and link it to values in an access table. The access table has a list of well names, dates, rates and hours and several other columns that I am not interested in. I need the combo box to be populated with the well names, and when I select one I would like it to return 3 columns with the Date, Rate and Hours. I have already tried DataExternal Data ... but the problem is that there are too many columns for excel and therefore I am missing a lot of my data, so I need it to pull directly from Access. To summarize 1) Create combo box linked to Well Name Column in Access Table 2) When Well name is selected in combo box fill out columns in Excel with Date, Rate and Hours from Access Table Thanks a lot, ALaw- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to Access table | Excel Discussion (Misc queries) | |||
Linking to Access Table | Excel Programming | |||
Combo Box Values from Access Table? | Excel Discussion (Misc queries) | |||
Linking Combo box to pivot table? | Excel Discussion (Misc queries) | |||
Linking a table in Access to a table in Excel using MS Query | Excel Programming |