| | |
|
|
|
Combo Box Query Value |
|---|
| message from =?Utf-8?B?TWF0dA==?= on 3 Jun 2004 |
I was wondering if there is a way to be able to choose which queries I want in the drop down box instead of all of them. The code is below that I have to receive all queries in the drop down box.
Thanks,
-Matt
|
| John Vinson replied to =?Utf-8?B?TWF0dA==?= on 03 Jun 2004 |
If you have a naming convention for queries, you can put a criterion
on the [Name] field to limit it to those that match the desired names.
Alternatively, and less restrictively, you could just create a table
of query names and maintain it separately.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| =?Utf-8?B?TWF0dA==?= replied to John Vinson on 3 Jun 2004 |
Thanks John, here is what I did.
SELECT MSysObjects.Name FROM MSysObjects WHERE (((Left([Name],1))<>"~") AND ((Left([Name],10))<>"CountyName") AND ((Left([Name],12))<>"Agribusiness") AND ((Left([Name],6))<>"County") AND ((Left([Name],16))<>"employment_naics") AND ((Left([Name],3))<>"EST") AND ((Left([Name],4))<>"Food") AND ((Left([Name],3))<>"Ind") AND ((Left([Name],3))<>"Man") AND ((Left([Name],5))<>"NAICS") AND ((Left([Name],3))<>"non") AND ((Left([Name],9))<>"wholesale") AND ((MSysObjects.Type)=5)) ORDER BY MSysObjects.Name;
ya it's a little sloppy but it got the job done. thanks again!!
|
| Graham R Seach replied to =?Utf-8?B?TWF0dA==?= on 4 Jun 2004 |
Matt,
So rather than continue with your original thread, you abandon it to begin a
new one! Not very impressive!
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
"Matt" <anonymous@discussions.microsoft.com> wrote in message
news:82E9FB9B-F486-4796-A763-FB17F35DC115@microsoft.com...
want in the drop down box instead of all of them. The code is below that I
have to receive all queries in the drop down box.
button/report from
|
|
Archived message: Combo Box Query Value (Microsoft Access Forms)
