If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A Dropdown List that lists the queries in the database
Hi, I've been searching the help directory but to no avail...
Is there a way I can easily create a dropdown list in a form that shows the queries I've made in the database? Any help is greatly appreciated! |
#2
|
|||
|
|||
A Dropdown List that lists the queries in the database
Danny,
Enter the following into the combo's RowSource property: SELECT [Name] FROM MSysObjects WHERE [Type] = 5 AND Flags = 0 Regards, Graham R Seach Microsoft Access MVP Sydney, Australia Microsoft Access 2003 VBA Programmer's Reference http://www.wiley.com/WileyCDA/WileyT...764559036.html "Danny B" Danny wrote in message ... Hi, I've been searching the help directory but to no avail... Is there a way I can easily create a dropdown list in a form that shows the queries I've made in the database? Any help is greatly appreciated! |
#3
|
|||
|
|||
A Dropdown List that lists the queries in the database
Fantastic!!! Thanks Graham.
"Graham R Seach" wrote: Danny, Enter the following into the combo's RowSource property: SELECT [Name] FROM MSysObjects WHERE [Type] = 5 AND Flags = 0 Regards, Graham R Seach Microsoft Access MVP Sydney, Australia Microsoft Access 2003 VBA Programmer's Reference http://www.wiley.com/WileyCDA/WileyT...764559036.html "Danny B" Danny wrote in message ... Hi, I've been searching the help directory but to no avail... Is there a way I can easily create a dropdown list in a form that shows the queries I've made in the database? Any help is greatly appreciated! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Print List of Queries | Tod | Running & Setting Up Queries | 1 | June 16th, 2004 03:09 PM |
change height dropdown list box | Toos | Worksheet Functions | 2 | June 6th, 2004 04:34 PM |
Data Validation - Allow List - In-cell Dropdown not showing up | Patrick Gibbons | Setting up and Configuration | 10 | May 15th, 2004 08:10 PM |
Data Validation - Allow List - In-cell Dropdown not showing up | Patrick Gibbons | Worksheet Functions | 10 | May 15th, 2004 08:10 PM |