|
| 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
July 1st, 2004, 02:33 AM
|
|||
|
|||
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
July 1st, 2004, 04:14 AM
|
|||
|
|||
|
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
July 1st, 2004, 08:25 PM
|
|||
|
|||
|
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 |
Linear Mode
