creating a switchboard?

[rkelly95]

How can I create a screen to come up immediately, (switchboard) with a list of the available queries that I created? I have seven queries, I just want them to be in a list when the program is run
thanks alot

 

[Junior1544]

I use access 2k so these directions are for that...

To make your switchboard, click on Tools->Database Utilities->Switchboard Manager

In there you can create your switchboard...

To make it startup on db load, click on
Tools->Startup
and in the top right part there is a drop down with the title of starting form... select your newly created switchboard from there...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[MazeWorX]

Create a new form and add a list box to it called lstQuery

On the forms Load event enter the following code:

Private Sub Form_Load()

Dim objAO As AccessObject
Dim objCP As Object
Dim strValues As String

Set objCP = Application.CurrentData

For Each objAO In objCP.AllQueries
strValues = strValues & objAO.Name & ";"
Next objAO

lstQuery.RowSourceType = "Value List"
lstQuery.RowSource = strValues


End Sub

----------

Next you need to set the form to open at startup. Goto "Tools" Startup and set the form "Display Form/page"

you'll still need to add code to have the queries execute
Remember amateurs built the ark - professionals built the Titanic