| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Link form to Access query result
Is it possible to have the rowsource of a list box in a form be the result of
an access query. Same question regarding a TextBox. Many thanks, Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link form to Access query result
List box: Yes. Just go to the properties of the List Box, Data tab, Row
Source. Click the dropdown box near the end of the line to select an existing query or use the ellipsis (...) at the end of the line to build the query. Text Box does not have a Row Source; perhaps you meant Combo Box? If so, same procedure as above. "Dan" wrote: Is it possible to have the rowsource of a list box in a form be the result of an access query. Same question regarding a TextBox. Many thanks, Dan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link form to Access query result
Oops. Sorry. I thought I was in the Access programming forum, not the Excel
forum when I posted my response, so my comments were Access-related. "Dan" wrote: Is it possible to have the rowsource of a list box in a form be the result of an access query. Same question regarding a TextBox. Many thanks, Dan |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Link form to Access query result
It's ok, I'll post it again, thanks anyway
"Brian" wrote: Oops. Sorry. I thought I was in the Access programming forum, not the Excel forum when I posted my response, so my comments were Access-related. "Dan" wrote: Is it possible to have the rowsource of a list box in a form be the result of an access query. Same question regarding a TextBox. Many thanks, Dan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel link to access query not working | Excel Discussion (Misc queries) | |||
| Link to MS-Access Query | Excel Discussion (Misc queries) | |||
| User Form Link to Query | Excel Programming | |||
| Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
| Removing Link to Access Query | Excel Discussion (Misc queries) | |||
Hybrid Mode
