R rblivewire May 18, 2006 #1 Is there any way to put a button on the switchboard to tell it to open the whole list of queries for a user to choose from?
Is there any way to put a button on the switchboard to tell it to open the whole list of queries for a user to choose from?
F fredg May 18, 2006 #2 Is there any way to put a button on the switchboard to tell it to open the whole list of queries for a user to choose from? Click to expand... Add a combo box to the switchboard. Set it's RowSource property to: SELECT MSysObjects.Name FROM MSysObjects WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY MSysObjects.Name; Code the combo box AfterUpdate event: DoCmd.OpenQuery Me!ComboName
Is there any way to put a button on the switchboard to tell it to open the whole list of queries for a user to choose from? Click to expand... Add a combo box to the switchboard. Set it's RowSource property to: SELECT MSysObjects.Name FROM MSysObjects WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY MSysObjects.Name; Code the combo box AfterUpdate event: DoCmd.OpenQuery Me!ComboName
R rblivewire May 18, 2006 #3 It gives me the list of queries, but I can't get them to run. It doesn't let me click on any of the queries. (I put the Afterupdate event in the code)
It gives me the list of queries, but I can't get them to run. It doesn't let me click on any of the queries. (I put the Afterupdate event in the code)
J Jeff Conrad May 18, 2006 #4 See this page on my site for any and all SBM questions: http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html In your particular case, this specific area (question #14): http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#combobox (Watch out for possible line wrapping on those links) -- Jeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conradsystems/accessjunkie.html http://www.access.qbuilt.com/html/articles.html rblivewire wrote in message:
See this page on my site for any and all SBM questions: http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html In your particular case, this specific area (question #14): http://home.bendbroadband.com/conradsystems/accessjunkie/switchboardfaq.html#combobox (Watch out for possible line wrapping on those links) -- Jeff Conrad Access Junkie - MVP http://home.bendbroadband.com/conradsystems/accessjunkie.html http://www.access.qbuilt.com/html/articles.html rblivewire wrote in message:
