Group:  Microsoft Access ยป microsoft.public.access.macros
Thread: Combo Box that retirieve queries or reports

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Combo Box that retirieve queries or reports
lordjeffj 06.07.2006 21:33:02
Hello,

Could someone tell me how I can list the queries of an access database in a
combo box in my access form?
Re: Combo Box that retirieve queries or reports
Nikos Yannacopoulos <nyannacoREMOVETHISBIT[ at ]in.gr> 07.07.2006 08:02:59
You need to set the RowSOurce property of the combo box to:

SELECT Name FROM MSysObjects WHERE Type = 5 AND Name Not Like "~sq*"

for queries, or:

SELECT Name FROM MSysObjects WHERE Type = -32764

for reports.

HTH,
Nikos

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net