Populating a ComboBox from System report table instead of creating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm developing a report filter that chooses existing reports, applies a
filter (dates) to it and prints it out.
My report-selector is a comboBox that reads from tblReports where title is
the report string manually entered.

There must be a system table or query where I can get a list of all reports
in Access without the need of a separate table.

Thanks in advance.
Chuck
 
I'm developing a report filter that chooses existing reports, applies a
filter (dates) to it and prints it out.
My report-selector is a comboBox that reads from tblReports where title is
the report string manually entered.

There must be a system table or query where I can get a list of all reports
in Access without the need of a separate table.

Thanks in advance.
Chuck
Click to expand...
As Combo box rowsource:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32764)) ORDER BY
MSysObjects.Name;
 
Thanks - that it.
Does anyone have a list or link of how to query other objects in access ?

Thanks,
Chuck

fredg said:
I'm developing a report filter that chooses existing reports, applies a
filter (dates) to it and prints it out.
My report-selector is a comboBox that reads from tblReports where title is
the report string manually entered.

There must be a system table or query where I can get a list of all reports
in Access without the need of a separate table.

Thanks in advance.
Chuck
Click to expand...
As Combo box rowsource:

SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32764)) ORDER BY
MSysObjects.Name;
Click to expand...
 
Thanks - that it.
Does anyone have a list or link of how to query other objects in access ?

Thanks,
Chuck

fredg said:
I'm developing a report filter that chooses existing reports, applies a
filter (dates) to it and prints it out.
My report-selector is a comboBox that reads from tblReports where title is
the report string manually entered.

There must be a system table or query where I can get a list of all reports
in Access without the need of a separate table.

Thanks in advance.
Chuck
Click to expand...
As Combo box rowsource:

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

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

Forms:
SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE
(((MSysObjects.Type)=-32768)) ORDER BY MSysObjects.Name;

Tables:
SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],4))<>"MSys") AND ((MSysObjects.Type)=1)) ORDER BY
MSysObjects.Name;
 
thanks Fredq - you've opened me to a new world of data.
Chuck

fredg said:
Thanks - that it.
Does anyone have a list or link of how to query other objects in access ?

Thanks,
Chuck

fredg said:
On Tue, 9 Nov 2004 09:07:07 -0800, Chuckf201 wrote:

I'm developing a report filter that chooses existing reports, applies a
filter (dates) to it and prints it out.
My report-selector is a comboBox that reads from tblReports where title is
the report string manually entered.

There must be a system table or query where I can get a list of all reports
in Access without the need of a separate table.

Thanks in advance.
Chuck
As Combo box rowsource:

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

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

Forms:
SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE
(((MSysObjects.Type)=-32768)) ORDER BY MSysObjects.Name;

Tables:
SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],4))<>"MSys") AND ((MSysObjects.Type)=1)) ORDER BY
MSysObjects.Name;
Click to expand...
 
Back
Top