K
Ken Warthen
I recently upgraded to Access 2007 and am having some trouble with the
changes. I have a form with a listbox in which I would like to display the
names of all the reports in the database. I've tried using the following as
the rowsource for the listbox, but in form view nothing is displayed. Does
anyone know how to do this?
TIA,
Ken Warthen
(e-mail address removed)
"SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;"
changes. I have a form with a listbox in which I would like to display the
names of all the reports in the database. I've tried using the following as
the rowsource for the listbox, but in form view nothing is displayed. Does
anyone know how to do this?
TIA,
Ken Warthen
(e-mail address removed)
"SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;"