MS Access: How can I print the design view of a table?

  • Thread starter Thread starter Sleepless in Ann Arbor
  • Start date Start date
S

Sleepless in Ann Arbor

I just want to a print out of all the field names in my access table. How
can I print the list of field names.
 
In Access 2003 from the Menu | Tools | Analyze | Documenter

Be warned that the documenter is capable of generating reams of
printout, so check your options carefully and look at the preview before
you do print.

Also, you can use Google Groups to search these groups for many other
documentation utilities.

Good Luck!
 
I just want to a print out of all the field names in my access table. How
can I print the list of field names.
Click to expand...

Use the Documenter feature
Tools + Analyze + Documenter

or...

Copy and paste the below function into a module:

Function TableFieldNames()
' Get the field names from a specified table
Dim dbs As DAO.Database, tdf As DAO.TableDef, fld As DAO.Field
Set dbs = CurrentDb
Set tdf = dbs("YourTableName")
For Each fld In tdf.Fields
TableFieldNames = TableFieldNames & fld.Name & vbCrLf
Next fld
Set dbs = Nothing
End Function

Then create a new report (no record source needed).
Add one unbound control to the report

Set it's control source to:
=TableFieldNames().
Set it's CanGrow property to Yes.
Also set the Section (that the control is in) CanGrow property to Yes.
 
Back
Top