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
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
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
-----Original Message-----
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.)
in message
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???
