copy table design view

[Guest]

I need to copy the table design view into Word. I copy the highlighted
design viw, but I am not allowed to paste it into Word or excel. Is there a
way to do this. Print screen works, but I cannot edit the information.

 

[Jeff Conrad]

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!

Once on screen you can just click on the Output to Word or Excel option on the toolbar and
you save the output to either Word or Excel.

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.

 

[Guest]

Thanks for the reply, Jeff. I don't need the table properties, just the
design view information, field name, data type, and description. Does this
add-in supply that or the entire property list that documentor does?

Thanks, Dave

 

[Jeff Conrad]

Hi Dave,

My add-in will list the Field Names, Descriptions, Type, Length, and which
field(s) is the Primary Key for each table, including linked ones.
It uses a LOT less paper than the Documentor, but of course it
does not have everything that the Documentor can spit out.
It is a nice concise list of *most* of the important information
that you would need for a table.

 

[Guest]

Jeff could you send me a copy, please. I am using Access 2000.
Email sorbillid at dteenergy dot com

Thanks, Dave

 

[Jeff Conrad]

Hi Dave,

Files have been sent to the address you provided.
Follow these steps to install the Add-In and/or read the attached
Word document:

1. Unzip the file JVTableList.MDA to your Office or Access directory
to easily find it when we install the Add-In.

2. Now open any Access database and go up to "Tools" on the main
Access menu bar. From there go down to the option called "Add-Ins".
This sub-menu will list any installed Access add-ins on your system, as
well as an option called "Add-In Manager". Click on the option called
"Add-In Manager" and a new screen will appear.

3. The box will display a list of available add-ins on the left side. Depending
upon where you unzipped the add-in file, you may see the John Viescas
Table Documentor already listed in this box. If the file is listed, click on the
option to highlight it and then press the "Install" button to complete the installation.
There should now be a little "x" next to the option meaning it has now been
installed. If you do not see the add-in listed in this box simply click the button
called "Add New..." where you can browse for the location of the file. Once
you find the file and click on it in the browse window, you will be taken back
to the Add-In Manager screen. Now you should see our add-in listed in the
box with a "x" by it meaning it has been successfully installed. If not, highlight
the option and then press the "Install" button to complete the installation. Hit the
"Close" button on the Add-In Manager when finished.
That's it, now we're ready to use the utility!

4. To launch the add-in, simply open any database you wish to document and go
up to Tools | Add-Ins and click on the new option "John Viescas Table Documentor".
Depending upon the number of tables in your database (and whether they are linked
or not), the utility should only take a few seconds to create the report and display it
on the screen. Once on screen you can either print the report or just view the different
pages. Doesn't get any easier than that!

Please post back to the newsgroup when you receive the files and if you have any
problems. The e-mail was being sent from a "dump" e-mail account and will not be
checked if a reply is sent. The ONLY way I will know if you received the file is
through the newsgroup.

Hope you find it useful.

 

[Guest]

Sorry Jeff, my company email would not allow the files in. Could you send
them to sorbillid at comcast dot net? Thanks, sorry for the trouble. Dave

 

[Jeff Conrad]

Hi Dave,

Ok, files sent to new address.
That's strange that your company e-mail would not let them through.
I did wash them behind the ears before sending.

No trouble at all.
Let me know when you receive the files (or not).