Access Documenter in 2003

[Margaret]

I have used the Access Documenter to print out the macro
code in older versions of Access. In Access Xp and 2003
the documenter now gives me lots of blank lines in the
report so that what would take 1 page to print now takes
5. I have tried to export the documentation page to
Excel or text files but that is not really satisfactory.
I looked at an old email that said to look for the
acwzusr.mdt file for the output for the documenter but
the table listed - doc_tblObjects isn't there. Any
ideas???

['69 Camaro]

Hi, Margaret.

> I looked at an old email that said to look for the
> acwzusr.mdt file for the output for the documenter but
> the table listed - doc_tblObjects isn't there.

The doc_tblObjects table doesn't exist until the Documenter is run. The
acwzusr.mdt file is a wizard _and_ a template, which will be copied and the
copy will be used to store the data in the doc_tblObjects table. The name
of this file copy will be ACWZUSRT.MDT, and it is placed in one's Windows
profile directory by default. Check the following directory for this file:

C:\Documents and Settings\<YourUserID>\Application Data\Microsoft\Access

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Margaret" <anon...@discussions.microsoft.com> wrote in message
news:197401c4ab0d$0b9e3a20$7d02...@phx.gbl...

[anon...@discussions.microsoft.com]

Hi Gunny,

Thanks for your reply but for some reason I still can't
find that table. I have run the documenter again and
checked the acwzusr.mdt file and there are lots of tables
in it but not the doc_tblObjects. I thought I had all my
wizards installed but could it be that there is a wizard
missing? There are copies of the acwzusr.mdt file in the
\Microsoft Office 2003\Office11 folder (and my previous
versions of Access) but not in the one you listed. I
don't have the folder "Application Data". Should I add
that to my Documents and Settings folder???

Thanks again,
Margaret

>.
>

[Jeff Conrad]

Hi,

First off, royal pain in the butt isn't it with the Documentor for macros in 2003?
I see big empty spots in the report as well.

Ok, back to business.
That particular folder "Application Data" under:

C:\Documents and Settings\<YourUserID>\Application Data\Microsoft\Access

...is a hidden folder. If you have not changed your folder options to view hidden folders/files, you
will not be able to see it.

Follow these steps:
1. Go to My Computer, C Drive, Documents and Settings
2. On the menu bar go to Tools | Folder Options
3. Go to the View tab
4. In the Advanced Settings area look for the option called "Hidden files and folders"
5. Select the option "Show hidden files and folders" and then hit Apply
6. You should now see the Application Data folder.
7. Keep navigating down to \Application Data\Microsoft\Access and there you should find your
treasure.

However, the treasure is a big jumbled mess of information!

So, what we need to do is to link to this table in your current database.

1. Close everything and then open your database. Run the Documentor and only select macros for the
output. Close the report now
2. Now go to File | Get External Data | Link Tables
3. Now we need to browse for the acwzusr.mdt, but wait, we have a problem!
If you look at the list of available file extensions MDT is NOT one of them!
So, you'll never see it in the browse list!!
4. What we need to do is manually type in the full path to the file like so:
C:\Documents and Settings\<YourUserID>\Application Data\Microsoft\Access\Acwzusr.mdt
(Windows/Access will actually help you type some of this as you go along)
Once you have the full path hit "OK" and you should see the list of tables.
5. Find doc_tblObjects in the list and link to it.
6. Finally, we have a link!

Now look at the data in the table.
Ugly, isn't it?

Copy and paste this SQL into a new query and run it:

TRANSFORM First(doc_tblObjects_2.Extra1) AS FirstOfExtra1
SELECT doc_tblObjects_1.ID, doc_tblObjects.Name AS MacroName, doc_tblObjects_1.Extra1 AS MacroGroup,
doc_tblObjects_1.Extra2 AS Condition, doc_tblObjects_1.Name AS [Action], doc_tblObjects_1.Extra3 AS
Comment
FROM doc_tblObjects AS doc_tblObjects_2 INNER JOIN (doc_tblObjects AS doc_tblObjects_1 INNER JOIN
doc_tblObjects ON doc_tblObjects_1.ParentID = doc_tblObjects.ID) ON doc_tblObjects_2.ParentID =
doc_tblObjects_1.ID
WHERE (((doc_tblObjects.TypeID)=4))
GROUP BY doc_tblObjects_1.ID, doc_tblObjects.Name, doc_tblObjects_1.Extra1, doc_tblObjects_1.Extra2,
doc_tblObjects_1.Name, doc_tblObjects_1.Extra3
ORDER BY doc_tblObjects_1.ID
PIVOT doc_tblObjects_2.Name In ("Caption:");

It's not *perfect*, but it should look a lot better now.
You could base a report on this query and customize it.
Hope that helps,
--
Jeff Conrad
Access Junkie
Bend, Oregon

<anon...@discussions.microsoft.com> wrote in message
news:03a901c4ab21$c6614370$a401...@phx.gbl...

[anon...@discussions.microsoft.com]

Thank you - thank you - thank you. It works !

Margaret

>-----Original Message-----
>Hi,
>
>First off, royal pain in the butt isn't it with the
Documentor for macros in 2003?
>I see big empty spots in the report as well.
>
>Ok, back to business.
>That particular folder "Application Data" under:
>C:\Documents and Settings\<YourUserID>\Application
Data\Microsoft\Access
>

>....is a hidden folder. If you have not changed your

>.
>

[Jeff Conrad]

You're very welcome, glad to help.
Maybe I should make my own Add-In to do this. Humm....

--
Jeff Conrad
Access Junkie
Bend, Oregon

<anon...@discussions.microsoft.com> wrote in message
news:0e4801c4ab33$fcde37c0$a601...@phx.gbl...

[Fred Boer]

Uh-oh.. Jeff's got that look in his eye again! ;)

Fred

"Jeff Conrad" <je...@ernstbrothers.com> wrote in message
news:%23N5R23z...@TK2MSFTNGP10.phx.gbl...

[Jeff Conrad]

Have to finish the Advanced SBM first. Focus Jeff....

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Fred Boer" <fred...@NOyahooSPAM.com> wrote in message
news:O74mq%23zqEH...@TK2MSFTNGP10.phx.gbl...