Print field description of a table

[Jeff Conrad]

Hi Nicole,

Sure, I'd be happy to send along a copy of the Add-in.
I just finished Version 2.0 of the Add-in. This version
is a tad bit faster, causes no databases bloat, and can
even be run on MDE files.

Do you need the 97 version or the 2000 version?
The 2000 version works with Access 2000, 2002, and 2003.

 

[Guest]

Arghhhhhh! I can't believe I forgot to include the version of Access I'm
running, even after reading all the other posts.

I'm running 2002, so I guess the 2000 version will work for me. Many thanks.

Nicole

nedwards@(nospam)labyrinth.net

 

[Guest]

Thank you, that was it. I was using the function in the immediate window.
It did not need the ?, but the quotes fixed it.

Silly me, the argument was listed as a string, but somehow I forgot that
meant quotes.

Thanks again,

Nicole

 

[Jeff Conrad]

Hi Nicole,

Ok, I'll send along the 2000 version first thing in the morning.
Have to get kids to bed right now.

 

[Jeff Conrad]

Hi Nicole,

File has 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 file and if 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]

Jeff,

I have received the file, thank you. I will not have a chance to make sure
it works until this evening, I'll let you know how it goes.

Nicole

 

[Jeff Conrad]

Hi Nicole,

Thank you for letting me know you received the file.
If you have any problems and/or if it helps with your project let me know.
Feedback is welcome.

 

[Guest]

Jeff,

I have not used it extensively yet, but I did try it last night and it
worked very well. I'm working with a group consolidating 9 of their
"databases" (from a Lotus approach format) into Access. While I am a long
time user of Access I am only recently becoming competent with vb. And since
I am having to build so many new tables at once, I am using the description
section of the table design to not only describe the variable, but make notes
as to anything I need to discuss with the group I am working for. So it is
very helpful to be able to print out a report that has the description field
on it for when I sit down with them to discuss progress.

Thank you for making such a useful add in available to Access users.

Nicole

 

[Jeff Conrad]

Hi Nicole,

That is good to hear my add-in works fine and it is just what you were looking for.
You're welcome on making it available and thank you for the feedback.
Good luck with your project.

 

[Kefri Ismail via AccessMonster.com]

Hi Jeff,

Can i get a copy of the this tool as well? I'm using MS Access 2002 and my
email address is kefri_99[AT]yahoo.com

Regards,
Kefri

 

[Jeff Conrad]

Hi Kefri,

Sure, I'd be happy to send along a copy of the add-in.

Files have been sent to the address you provided.
Subject line will be:
"Access Add-In You Requested From The Newsgroup"
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.

 

[Kefri Ismail via AccessMonster.com]

Hi Jeff,

Could u resend the file again.i might have accidentally deleted the email.
Email address again is kefri_99[At]yahoo.com

I've subtituted the @ sign so that spambots will not grab my email address

Thanks so much,
Kefri

 

[Jeff Conrad]

Sure Kefri, I'll resend the file for you.
Follow the instructions in the previous NG post.

 

[Kefri Ismail via AccessMonster.com]

Thanks Jeff!

This is really helpful....

 

[Jeff Conrad]

You're very welcome Kefri.
I'm glad to hear the add-in is helpful.
Thanks for the feedback!