populate Listbox with list of all Report in db

[Daniel]

Hello,

How can I populate a listbox with a listing of all the reports in the db
in an alphabetical order?

Thank you for the help,

Daniel

 

[fredg]

Hello,

How can I populate a listbox with a listing of all the reports in the db
in an alphabetical order?

Thank you for the help,

Daniel

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32764)) ORDER BY
MSysObjects.Name;

 

[Daniel]

I ended up finding the answer, if anyone else is looking goto this website:

http://members.iinet.net.au/~allenbrowne/ser-19.html