T
Tony
Access 2002 (XP)
How can I print out record layouts or field names?
Thanks
How can I print out record layouts or field names?
Thanks
J
Jeff Conrad
in message:
Here are a few options for you,
1. You can use the built-in Access Documentor
(Tools | Analyze | Documentor) to get a huge list of just about everything
you ever wanted to know about the database. At the same time, you can
keep the logging and paper manufacturing industry going strong in Oregon!
Depending upon the options you select, you could fell several trees.
2. I created an Access Add-In called the "John Viescas Table Documentor"
that does exactly this. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.
Once installed (takes less than a minute) all you have to do is
Tools | Add-Ins | John Viescas Table Documentor. Poof!
After a few seconds a slick report is displayed on the screen. Easy as pie!
The report will list each Field Name, Description, Type, Length, and which
field(s) compose the Primary Key.
The display output will be something like this:
Table: tblVendors
Field Name: Description Type Length Primary
VendorID ID Field Autonumber 4 X
VendorName Vendor's Name Text 50
etc...
Will this work for you?
I am awaiting word back from John about the possibility of having him post
it on his web site where anyone can download it. In the meantime, I do not
believe he would have a problem if I sent you a copy. If you do wish to have
a copy please let me know where you would like it sent to (please mung the
e-mail address so you won't get spammed!). There is one version for Access
97 and one for 2000 which works with Access 2000, 2002, and 2003.
I will need to know which version you need.
3. David Hare-Scott has also written a simple table documenter. You can
download it here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hare-Scott,David
4. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
(Look for Data Dictionary Report Utility)
Hope that gives you some ideas,
Here are a few options for you,
1. You can use the built-in Access Documentor
(Tools | Analyze | Documentor) to get a huge list of just about everything
you ever wanted to know about the database. At the same time, you can
keep the logging and paper manufacturing industry going strong in Oregon!
Depending upon the options you select, you could fell several trees.
2. I created an Access Add-In called the "John Viescas Table Documentor"
that does exactly this. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.
Once installed (takes less than a minute) all you have to do is
Tools | Add-Ins | John Viescas Table Documentor. Poof!
After a few seconds a slick report is displayed on the screen. Easy as pie!
The report will list each Field Name, Description, Type, Length, and which
field(s) compose the Primary Key.
The display output will be something like this:
Table: tblVendors
Field Name: Description Type Length Primary
VendorID ID Field Autonumber 4 X
VendorName Vendor's Name Text 50
etc...
Will this work for you?
I am awaiting word back from John about the possibility of having him post
it on his web site where anyone can download it. In the meantime, I do not
believe he would have a problem if I sent you a copy. If you do wish to have
a copy please let me know where you would like it sent to (please mung the
e-mail address so you won't get spammed!). There is one version for Access
97 and one for 2000 which works with Access 2000, 2002, and 2003.
I will need to know which version you need.
3. David Hare-Scott has also written a simple table documenter. You can
download it here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hare-Scott,David
4. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
(Look for Data Dictionary Report Utility)
Hope that gives you some ideas,
T
Tony
J
Jeff Conrad
in message:
Sure Tony, I'd be happy to send along a copy.
I'll do that shortly.
Please post back here when you receive the files so I know
you got them.
Sure Tony, I'd be happy to send along a copy.
I'll do that shortly.
Please post back here when you receive the files so I know
you got them.
T
Tony
OK Jeff, got it, installed it, and works fine, (had some trouble installing
XP SP2, I had to unblock it).
Works great, I only wish it printed the table description and would be
perfect.
Thanks
Tony
XP SP2, I had to unblock it).
Works great, I only wish it printed the table description and would be
perfect.
Thanks
Tony
T
Tony
I wonder if there is a way to do this with VB .net?
J
Jeff Conrad
in message:
Glad you received the files Ok Tony.
Yes, I probably should have warned about unblocking with XP SP2.
The table description itself?
Humm....no one has asked about that before.
Should be easy to add. I'll try and incorporate
that into the next release.
Thanks for the feedback and I hope you find it useful in your projects.
Glad you received the files Ok Tony.
Yes, I probably should have warned about unblocking with XP SP2.
The table description itself?
Humm....no one has asked about that before.
Should be easy to add. I'll try and incorporate
that into the next release.
Thanks for the feedback and I hope you find it useful in your projects.
J
Jeff Conrad
in message:
I do not have any VB.NET experience myself Tony so
I cannot give a definitive answer on that. You might consider
posting a question in one of the newsgroups devoted to
VB.NET. Perhaps somewhere there can assist.
I do not have any VB.NET experience myself Tony so
I cannot give a definitive answer on that. You might consider
posting a question in one of the newsgroups devoted to
VB.NET. Perhaps somewhere there can assist.