Documentation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inherited a good sized db with no documentation. I would like to
somehow match up the table names with the appropriatly 50 make table queries.
Is there a fast way of doing this? I reviewed the documenter section and it
did not really offer me what I am trying to do. TY
 
Hi Brian,

you may be on the right track with the documentor...

Document the SQL for all your queries

then, with the report open

right-click on it

choose "Export..." from the shortcut menu

change file type to Rich Text Format

and put the file in a logical place

then, open the file in Word

find --> INTO (space at end)
replace with --> INTO (space at end), format --> font --> bold

this will boldface every word INTO, making it easier to spot
the tables that are made

'~~~~~~~~~`

you could, of course, use Access to do a search and write a
program to actually return the tablenames and the queries
that make them.

here is a little procedure to get you on your way if you
feel like coding...

'~~~~~~~~~~~~~
Sub DocumentQuerySQL()

'NEEDS REFERENCE
'Microsoft DAO Library

Dim qdf As DAO.QueryDef

For Each qdf In CurrentDb.QueryDefs
MsgBox qdf.SQL, , qdf.Name
Next qdf

Set qdf = Nothing
MsgBox "DocumentQuerySQL Done", , "Done"
End Sub
'~~~~~~~~~~~~~



Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
If you need documentation modules, or at least modules to take
SQL/Queries/Stored proedures adn turn them into text, you can try the
following from my website (link is below)

StoredProcedure_Get.mdb.zip : Access MDB to backup stored procedures.
Code checks for table's existence and creates if necessary. Requires
modification of module level variables to fit your environment.

Access_Documentation.txt: Exports Access components to tables, in the
case of queries and tables, or subdirectories, for modules, to a
hard-coded subdirectory. Also includes function to enumerate Access
data type values as strings. In conjunction with a form, the path can
be dynamic, and provide additional source code backup.

List of Access modules provided:

http://code.comparative-advantage.com/code.php?type=Access


Regards,

James Igoe

(e-mail address removed) || http://code.comparative-advantage.com
 
Back
Top