print database fields

I received it, thanks.
Dave
"Jeff Conrad" wrote in message
...
Hi Dave,

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.
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

Thanks Jeff,
I would appreciate the code. Thanks for your help.
i am at e-mail address snipped
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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's Name, Description, Type, Length, and
which field(s) is the Primary Key.

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.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave" wrote in message
...

Hello,
Is there a way to print all field names by tables within a database?
I
have
about 25 tables in the database and wondering if there is a way to
dump
all
field names. Not the values within, just the names. I am using
Access
2000.
I have the database on other several different servers (at different
clients) and am trying to make it easier to change the tables in the
offsite
databases before I publish to them.
Thanks,
Dave

Good to hear you received the files Ok Dave.
Hope it helps in your projects.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

I received it, thanks.
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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.
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

Thanks Jeff,
I would appreciate the code. Thanks for your help.
i am at e-mail address snipped
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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's Name, Description, Type, Length, and
which field(s) is the Primary Key.

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.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave" wrote in message
...

Hello,
Is there a way to print all field names by tables within a database?
I
have
about 25 tables in the database and wondering if there is a way to
dump
all
field names. Not the values within, just the names. I am using
Access
2000.
I have the database on other several different servers (at different
clients) and am trying to make it easier to change the tables in the
offsite
databases before I publish to them.
Thanks,
Dave

I cannot get the mda file you sent opened. I know it has to do with
security settings, but it will not open.
"Jeff Conrad" wrote in message
...
Good to hear you received the files Ok Dave.
Hope it helps in your projects.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

I received it, thanks.
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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.
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

Thanks Jeff,
I would appreciate the code. Thanks for your help.
i am at e-mail address snipped
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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's Name, Description, Type, Length,
and
which field(s) is the Primary Key.

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.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave" wrote in message
...

Hello,
Is there a way to print all field names by tables within a
database?
I
have
about 25 tables in the database and wondering if there is a way to
dump
all
field names. Not the values within, just the names. I am using
Access
2000.
I have the database on other several different servers (at
different
clients) and am trying to make it easier to change the tables in
the
offsite
databases before I publish to them.
Thanks,
Dave

What exactly do you mean by cannot "open" Dave?
Do you mean you cannot unzip the file or you
are trying to open the MDA file itself to run it?
The file is meant to be an Access add-in that
you install using the Add-In Manager utility.
Once installed you access it by going to Tools |Add-ins.

Are you using Windows XP by chance?

Can you provide a little more detail about exactly
you are doing and what is not working?

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" wrote in message
...

I cannot get the mda file you sent opened. I know it has to do with
security settings, but it will not open.

"Jeff Conrad" wrote in message
...
Good to hear you received the files Ok Dave.
Hope it helps in your projects.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

I received it, thanks.
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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.
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

Thanks Jeff,
I would appreciate the code. Thanks for your help.
i am at e-mail address snipped
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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's Name, Description, Type, Length,
and
which field(s) is the Primary Key.

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.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave" wrote in message
...

Hello,
Is there a way to print all field names by tables within a
database?
I
have
about 25 tables in the database and wondering if there is a way to
dump
all
field names. Not the values within, just the names. I am using
Access
2000.
I have the database on other several different servers (at
different
clients) and am trying to make it easier to change the tables in
the
offsite
databases before I publish to them.
Thanks,
Dave

I am using Windows XP Pro.

Windows security will not allow me to take the MDA file out of the zip
folder. It has blocked access to the file. I even turn off the security
feature, but it still does not allow it.
Thanks,
Dave
"Jeff Conrad" wrote in message
...
What exactly do you mean by cannot "open" Dave?
Do you mean you cannot unzip the file or you
are trying to open the MDA file itself to run it?
The file is meant to be an Access add-in that
you install using the Add-In Manager utility.
Once installed you access it by going to Tools |Add-ins.

Are you using Windows XP by chance?

Can you provide a little more detail about exactly
you are doing and what is not working?

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" wrote in message
...

I cannot get the mda file you sent opened. I know it has to do with
security settings, but it will not open.

"Jeff Conrad" wrote in message
...
Good to hear you received the files Ok Dave.
Hope it helps in your projects.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

I received it, thanks.
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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.
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

Thanks Jeff,
I would appreciate the code. Thanks for your help.
i am at e-mail address snipped
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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's Name, Description, Type,
Length,
and
which field(s) is the Primary Key.

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.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave" wrote in message
...

Hello,
Is there a way to print all field names by tables within a
database?
I
have
about 25 tables in the database and wondering if there is a way
to
dump
all
field names. Not the values within, just the names. I am using
Access
2000.
I have the database on other several different servers (at
different
clients) and am trying to make it easier to change the tables in
the
offsite
databases before I publish to them.
Thanks,
Dave

Hi Dave,

Here is a past post by Rick Brandt which covers this issue:

If he has Service Pack 2 for Windows XP installed it "Blocks" all
executable files that come from other systems whether that be Email or being
dragged from the network. You have to right-click on the file, view the
properties, and press the [Unblock] button in the lower right. Then the
file will work.


And here is a KB article on the subject as well:
http://support.microsoft.com/?id=883260

Once you have access to the file, then follow the installation
instructions I provided in the Word document.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail snipped wrote in message
...

I am using Windows XP Pro.

Windows security will not allow me to take the MDA file out of the zip
folder. It has blocked access to the file. I even turn off the security
feature, but it still does not allow it.
Thanks,
Dave

"Jeff Conrad" wrote in message
...

What exactly do you mean by cannot "open" Dave?
Do you mean you cannot unzip the file or you
are trying to open the MDA file itself to run it?
The file is meant to be an Access add-in that
you install using the Add-In Manager utility.
Once installed you access it by going to Tools |Add-ins.

Are you using Windows XP by chance?

Can you provide a little more detail about exactly
you are doing and what is not working?

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail snipped wrote in message
...

I cannot get the mda file you sent opened. I know it has to do with
security settings, but it will not open.

"Jeff Conrad" wrote in message
...

Good to hear you received the files Ok Dave.
Hope it helps in your projects.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

I received it, thanks.
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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.
--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave Melosi" e-mail address snipped wrote in message
...

Thanks Jeff,
I would appreciate the code. Thanks for your help.
i am at e-mail address snipped
Dave

"Jeff Conrad" wrote in message
...
Hi Dave,

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's Name, Description, Type,
Length,
and
which field(s) is the Primary Key.

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.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Dave" wrote in message
...

Hello,
Is there a way to print all field names by tables within a
database?
I
have
about 25 tables in the database and wondering if there is a way
to
dump
all
field names. Not the values within, just the names. I am using
Access
2000.
I have the database on other several different servers (at
different
clients) and am trying to make it easier to change the tables in
the
offsite
databases before I publish to them.
Thanks,
Dave