forms question

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

Hello NG. First let me extend a hearty Happy New Year to
you all. And second, a heartfelt thank you for the
assistance this NG has provided over the past year. My
project is now completed, on time, and getting posted on
the server today (12/31/2003).

Now, my question is; Is there a way to be able to print
out the list of forms from the database window? The same
for the tables? I know there is the documenter but I am
just looking to get a list without having to screen print
or do it manually.

Thanks to anyone who responds.
*** John
 
JohnE said:
Hello NG. First let me extend a hearty Happy New Year to
you all. And second, a heartfelt thank you for the
assistance this NG has provided over the past year. My
project is now completed, on time, and getting posted on
the server today (12/31/2003).

Now, my question is; Is there a way to be able to print
out the list of forms from the database window? The same
for the tables? I know there is the documenter but I am
just looking to get a list without having to screen print
or do it manually.

Thanks to anyone who responds.
*** John
Click to expand...

Make a new unbound report.
As Report RecordSource:
SELECT MSysObjects.Name, MSysObjects.Type FROM MSysObjects WHERE
(((MSysObjects.Type)=-32768)) ORDER BY MSysObjects.Name;

Add just the Name field to the report Detail Section.
Print it.

Use the same report to print out the table names.
Just change the RecordSource to:

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