Print design view of a table and report

  • Thread starter Thread starter L Guest
  • Start date Start date
L

L Guest

Is there a way to print the design view of a table (that
shows the field name, data type and description) and a
report with the fields that are being pulled into the
report?
 
Is there a way to print the design view of a table (that
shows the field name, data type and description) and a
report with the fields that are being pulled into the
report?
Click to expand...

Tools + Analyze + Documenter

Make sure you check which Options you wish to display/print or else be
prepared with lot's of paper.
 
Thanks for the info. but I was more looking for printing
the screen that displays when you go into the design view
of the table or the report. The documenter report gives
too much information even with minimal options selected.
 
Thanks for the info. but I was more looking for printing
the screen that displays when you go into the design view
of the table or the report. The documenter report gives
too much information even with minimal options selected.
Click to expand...

Display the table in Design View.
Click Print Screen.
Open a new Word document (or create a new Access Report) and paste the
screen image into it.
You can now print the Word (or Access report) document.
 
You can run the documenter and then link to the table containing the results
of the documenter. On my PC this table connection is
DATABASE=C:\Documents and Settings\Duane Hookom\Application
Data\Microsoft\Access\ACWZUSRT.MDT;TABLE=doc_tblObjects.

Then create a query that returns the table name and field name & properties.
Then create your own report.

SELECT doc_tblObjects.Name AS TableName,
doc_tblObjects_1.Name AS FieldName,
doc_tblObjects_1.Extra2 AS FieldType,
doc_tblObjects_1.Extra3 AS FieldSize
FROM doc_tblObjects AS doc_tblObjects_1
INNER JOIN doc_tblObjects
ON doc_tblObjects_1.ParentID = doc_tblObjects.ID
WHERE (((doc_tblObjects_1.TypeID)=11));
 
Back
Top