Queries

[jonamua1971]

Hay
You People Have Been So Good And Helpful.thank You All In Advance For Your Response.
My Question Is? How Can I Put All My Queries Under A List Box In Forms So That I Can Just Highlight The One I Want And Run The Query.
Can I Do The Same For The Reports??
Thanks To You All.

 

[WayneRyan]

J,

Base a ComboBox (or ListBox) on the MsysObjects tables. The queries have
type = 5.

You might have to go to Tools --> Options and unhide the system tables.

Wayne

 

[jonamua1971]

J,

Base a ComboBox (or ListBox) on the MsysObjects tables. The queries have
type = 5.

You might have to go to Tools --> Options and unhide the system tables.

Wayne

i didnt quiet get you . how do i do that? still new with the database

 

[WayneRyan]

J,

First, go to Tools --> Options
Ensure that on the View Tab, system objects is checked.

Then start a new query and select the MSysObjects table is selected.

Then double-click on the Name column.

Then double-click on the Type column.
For this column, in the Criteria section, put 5.
Then on the visible checkbox, uncheck it.

Save the query.

On some form, make a new combo-box with the wizard and make your
new query the RowSource.

Then in the AfterUpdate of the combobox put:

DoCmd.OpenQuery Me.YourCombo

It sounds complicated, but give it a try.

Wayne