Sort field names in table design

[Guest]

Is there any way to get an alphabetical list of table field names? The
documenter gives them in the as enterd order and it's very dificult when
comparing 2 tables or looking for information on a specific field in the
design mode.

 

[Jeff Conrad]

in message:

Is there any way to get an alphabetical list of table field names? The
documenter gives them in the as enterd order and it's very dificult when
comparing 2 tables or looking for information on a specific field in the
design mode.

Hi Irene,

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.

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.

Wait a minute.....

Just before I was going to hit "Send", I thought, "Wait a minute, I'm not sure
if my report will list them in alphabetical order either!" I just checked and
my report will list them in Design View order as well. This is my personal
preference, but that is just me.

If you would like, I will build a custom add-in just for you Irene that will
do this. It should only take about 10-15 minutes to complete. These are
my terms:

1. You must admit you are an Access Junkie. No wiggle room on that one.

2. I will need to know which Access version you are using.

3. I will need to know where you want the file sent to. Please mung the
e-mail address so you do not get Spammed. If you are not comfortable
with this, then post back and I will tell you how to contact me.

If you agree, please sign below and I'll get started:

___________ April 8th, 2005

 

[Lynn Trapp]

1. You must admit you are an Access Junkie. No wiggle room on that one.
Conrad,
You are more than a Junkie... you are a NUT. <g,d,&r>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Conrad]

in message:

Conrad,
You are more than a Junkie... you are a NUT. <g,d,&r>

LOL!
I think it's time for my medication.

I had four terms before, but I decided to leave off the last one
as I thought Irene may not agree to it.

4. A portion of the proceeds will go to the Vinson Wayward Home
of Lookup Field Users.

 

[John Vinson]

in message:



LOL!
I think it's time for my medication.

I had four terms before, but I decided to leave off the last one
as I thought Irene may not agree to it.

4. A portion of the proceeds will go to the Vinson Wayward Home
of Lookup Field Users.

<SNORK><splutter><choke>

Jeff, I should know better than to drink coffee and read your posts at
the same time...

Well, I just hauled 20 wheelbarrow loads of composted cattle manure
onto the garden; about 60 to go. I could certainly use the unpaid
labor force!

John W. Vinson[MVP]

 

[Jeff Conrad]

in message:

<SNORK><splutter><choke>

Jeff, I should know better than to drink coffee and read your posts at
the same time...

ROFL!!
Sorry about that.

Well, I just hauled 20 wheelbarrow loads of composted cattle manure
onto the garden; about 60 to go. I could certainly use the unpaid
labor force!

I am certainly glad the wind is blowing East right now.
;-)

 

[Jeff Conrad]

The add-in is ready if you would like it Irene.
It only took 12 minutes to make the modifications.
Just post back and it is all yours.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message

 

[Guest]

Absolutely I want it. So how I do I get my e-mail address to you? What does
"Mung" the e-mail address mean?

Access junkie - YES. I continually threaten to take Excel away from my
coworkers who have 2000 line spreadsheets with 58 columns in them. Ugh!!!

Thank you very much

The add-in is ready if you would like it Irene.
It only took 12 minutes to make the modifications.
Just post back and it is all yours.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message

 

[Jeff Conrad]

in message:

Hi Irene,

Absolutely I want it. So how I do I get my e-mail address to you? What does
"Mung" the e-mail address mean?

You may send a text only message to the following address. This is a
"dump" e-mail account for our office and receives hundreds of junk messages
daily. In order for me to spot your message, please put "Access Junkie"
in the Subject line.

administrator
at
ernstbros
dot
com

Please include the following in your message:
1. The e-mail address you want the file sent to.
2. What Access version you are using.
3. A signed affidavit that you are an Access Junkie.
(Ok, you can forget the last one; I trust you.)

Access junkie - YES. I continually threaten to take Excel away from my
coworkers who have 2000 line spreadsheets with 58 columns in them. Ugh!!!

Exxxxxxcellent!! My work here is done.

Sniff.....sniff.....sniff....I need a moment.
It's a beautiful thing isn't it? Sniff...

Thank you very much

You're very welcome.

 

[Guest]

Got it .Works just great. But - why is the report not "hard" copy created. I
would like to insert page breaks, etc between the table listing so I can put
it into my documentation notebook. Yes I still use paper documentation. Not a
big deal, and I sure appreciate the Add-in, but there is always something
else on the wish list!

Thanks, Irene

 

[Jeff Conrad]

in message:

Hi Irene,

Got it .Works just great.

Excellent, good to hear!

But - why is the report not "hard" copy created. I
would like to insert page breaks, etc between the table listing so I can put
it into my documentation notebook. Yes I still use paper documentation. Not a
big deal, and I sure appreciate the Add-in, but there is always something
else on the wish list!

<g>
Give a Junkie an inch......
;-)

Version 1.0 of my add-in did exactly that. It would create a new table object
in the current database to hold the information needed for the report. It would
also create a new report object in the database to display the information.
This report could be opened again at any time and/or could be customized
further by the end user.

There was one major drawback to this, however. The add-in could not be run on
an MDE file then for obvious reasons. I thought it would be better to have the
add-in be accessible to MDB and MDE files. In addition, a new table object and
report object in the database may not be what *everyone* wants to see created
in their nice polished database.

If you would like the other version instead, I can create another custom add-in
just for you based on Version 1.0 that will create a report (and table) in the
current database. You can then "play" with it all you like. Is this something you
would like?

If you agree, the stakes get higher now.

I will now require that the next time you meet an Access MVP you
give them a big hug for me.

Deal?

 

[Guest]

Hugs - Its a Deal.

Thanks a lot. I'm sure I'll use both at different times. But I already found
in the mda file the table that was created and can really format a new report
to my hearts content. But creating the report object in the database is is a
little more convenient since I have several I would like to get the
documentation organized for.

Thanks a lot

 

[Jeff Conrad]

in message:

Hugs - Its a Deal.

Excellent, pleasure doing business with you.

Thanks a lot. I'm sure I'll use both at different times. But I already found
in the mda file the table that was created and can really format a new report
to my hearts content. But creating the report object in the database is a
little more convenient since I have several I would like to get the
documentation organized for.

Yes, the table and report are in the MDA file itself, however, you cannot
modify the report object itself since the file is actually an MDE.

Thanks a lot

You're very welcome.

New file will be coming along shortly. There will be a slight layover delay
in Denver, however, due to the heavy snow. Please be patient as flights
are backed up a bit.

When the file arrives you will need to do the following steps in this order.

1. Uninstall the current add-in by following the instructions on page 2
of the guide I sent you.
2. Now you will need to delete the *current* JVTableList.MDA files
from your system. There should actually be two instances of this file.
One will be in the Office folder (if you followed my previous instructions)
and one will be in your profile under
Application Data\Microsoft\Addins
or something similar. This will most likely be a hidden folder. Search
your hard drive for all instances of JVTableList.MDA and make
sure to include hidden folders in the search.
Delete both files when located.
3. Install the new one just like before by following the instructions.

Now you can launch the add-in just as before. A new table and report
will be created in your database. The table will list the details *at this
point in time.* If you make any table field changes and wish to see
an updated report, simply re-run the add-in from the add-ins menu.
The table will be cleared and re-populated with the new information.
Make sense?

The first report made will be in Table Design View layout. Simply
open the report in Design View, go to the Sorting/Grouping box
and change the sort order from SequenceID on the second line
to FieldName and alphabetical. Make any other changes you wish
as well.

Hope this is what you are looking for.
Please post back here with any problems/questions.

 

[Guest]

Got, Works Great. Just what I wanted

More Hugs to my Favorite Access Junkie

Oh by the way - Anything for queries?

 

[Jeff Conrad]

in message:

Hi Irene,

Got, Works Great. Just what I wanted
Excellent!

More Hugs to my Favorite Access Junkie

<blush>
Oh, thanks.

Oh by the way - Anything for queries?

Scary....are you a mind reader?
I'm actually working on something like that!
(Shhh...don't tell anyone else)
I want to have an add-in that will list the SQL for each
saved query. The Documentor spits it out one page for each.
Too much paper for me.

Whenever I finish it (not sure when) do you want me to ping you?

I just finished another add-in this past weekend. Someone in the
newsgroup last week wanted a list of all code procedure names in
all forms, report, and, modules so I whipped up something. They
just wanted the names, not the code itself.

So far everything works great, but I have not yet completed all my
testing on various OS and Access versions. I still need to make
the accompaning user's guide as well.

Would you be willing to test drive a copy of that one and give me
some feedback??

I also have this one posted on MVP Doug Steele's site:
http://www.accessmvp.com/djsteele/Documentor.html
That one will list all the database objects in a three column layout.

I also have one that (among other things) will document all
the permissions for database objects in a secured database.
That one is one MVP Sandra Daigle's site:
http://www.daiglenet.com/msaccess.htm

I have another one that will produce a one-page report that lists
the total number of lines of code in Modules, Forms, and Reports (a
sub total for each and a grand total) as well as a count of each other
type of database object (a sub total for each category and a grand total).
That one is called the "Albert Kallal Database Statistics." I am
awaiting word back from Albert on the possibility of him posting
it on his site. If you'd like a copy of that one let me know.

 

[Jeff Conrad]

in message:

Yes on the query documenter.
Ok.

I already have the Doug Steele documenter, that's how I got the idea to
pursue my latest quest. Very successfully!

Very good.
I'm so proud...sniff....Irene is all grown up now...sniff....

As far as those that provide code documentation - this is a little beyond me
so I'm probably not the best to do any serious testing. I'm at the macro and
modify other peoples code level.

No problem, I just thought I would ask.

Thanks for all your help. Now off to do some real work using all my new
tools!! Its just like going to the hardware store!

You're very welcome, it is my pleasure to help.

Now go and assimilate everyone around you with Access.
"You will adapt to service us..."

;-)

 

[Lynn Trapp]

More Hugs to my Favorite Access Junkie

<blush>
Oh, thanks.

Jeff! Are you stealing all the hugs? ;-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Conrad]

in message:

Jeff! Are you stealing all the hugs? ;-)

Sorry.

There's plenty of love to go around!
Big group hug everybody, group hug!!

Remember that famous Coke commercial?
Sing along now....
"I'l like to buy the world an Access copy, and keep it company...."

 

[Lynn Trapp]

There's plenty of love to go around!

Big group hug everybody, group hug!!

Remember that famous Coke commercial?
Sing along now....
"I'l like to buy the world an Access copy, and keep it company...."

Nice, but the meter leaves something to be desired. No way I can arrange
that in the good old Barbershop style. ;-)

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Jeff Conrad]

in message:

Nice, but the meter leaves something to be desired. No way I can arrange
that in the good old Barbershop style. ;-)

Yeah, it's a little rough right now.

Maybe...."I see trees of green...purple Access keys too...I see them
bloom for me and you. And I think to myself....what a wonderful world."

There is a truck pulling up and a bunch of guys in white clothes are
getting out. Hummm....you'll have to excuse me for a minute....