A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Exporting database documenter info to table



 
 
Thread Tools Display Modes
  #1  
Old February 18th, 2010, 06:27 PM posted to microsoft.public.access
Browser
external usenet poster
 
Posts: 1
Default Exporting database documenter info to table

Used to be you could export table and field information via the database
documenter to a table. Does anyone out there have any pointers on how do to
that in 2007? It appears to try but fails - in my case anyhow - with
messages like "doc_rptObject does not exist... and/or doc_rptObject can not
be opened".
Thanks.
  #2  
Old February 19th, 2010, 03:42 AM posted to microsoft.public.access
Paul Shapiro
external usenet poster
 
Posts: 635
Default Exporting database documenter info to table

"Browser" wrote in message
...
Used to be you could export table and field information via the database
documenter to a table. Does anyone out there have any pointers on how do
to
that in 2007? It appears to try but fails - in my case anyhow - with
messages like "doc_rptObject does not exist... and/or doc_rptObject can
not
be opened".


I don't know about the documenter, but I have VBA code which creates a
nicely formatted Word document with similar info. You could modify the code
to output in any format you want. I wrote the code for checking student db
projects when I was teaching a db course, so the output includes warnings on
what I considered common issues. The code is too long to post here, so email
me privately if you want the code, making the obvious correction to my email
address.

  #3  
Old May 14th, 2010, 12:38 PM posted to microsoft.public.access
audie collins
external usenet poster
 
Posts: 1
Default Exporting database documenter info to table



"Paul Shapiro" wrote in message
...
"Browser" wrote in message
...
Used to be you could export table and field information via the database
documenter to a table. Does anyone out there have any pointers on how do
to
that in 2007? It appears to try but fails - in my case anyhow - with
messages like "doc_rptObject does not exist... and/or doc_rptObject can
not
be opened".


I don't know about the documenter, but I have VBA code which creates a
nicely formatted Word document with similar info. You could modify the
code to output in any format you want. I wrote the code for checking
student db projects when I was teaching a db course, so the output
includes warnings on what I considered common issues. The code is too long
to post here, so email me privately if you want the code, making the
obvious correction to my email address.


  #4  
Old May 15th, 2010, 06:35 AM posted to microsoft.public.access
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Exporting database documenter info to table

I believe you can link to the documenter data from the file ACWZUSR12.ACCDU
in the folder C:\Users\_your user name
here_\AppData\Roaming\Microsoft\Access\


--
Duane Hookom
MS Access MVP


"audie collins" wrote in message
...


"Paul Shapiro" wrote in message
...
"Browser" wrote in message
...
Used to be you could export table and field information via the database
documenter to a table. Does anyone out there have any pointers on how
do to
that in 2007? It appears to try but fails - in my case anyhow - with
messages like "doc_rptObject does not exist... and/or doc_rptObject can
not
be opened".


I don't know about the documenter, but I have VBA code which creates a
nicely formatted Word document with similar info. You could modify the
code to output in any format you want. I wrote the code for checking
student db projects when I was teaching a db course, so the output
includes warnings on what I considered common issues. The code is too
long to post here, so email me privately if you want the code, making the
obvious correction to my email address.


  #5  
Old May 17th, 2010, 02:00 PM posted to microsoft.public.access
Sakaguti
external usenet poster
 
Posts: 2
Default Exporting database documenter info to table


"audie collins" wrote in message
...


"Paul Shapiro" wrote in message
...
"Browser" wrote in message
...
Used to be you could export table and field information via the database
documenter to a table. Does anyone out there have any pointers on how
do to
that in 2007? It appears to try but fails - in my case anyhow - with
messages like "doc_rptObject does not exist... and/or doc_rptObject can
not
be opened".


I don't know about the documenter, but I have VBA code which creates a
nicely formatted Word document with similar info. You could modify the
code to output in any format you want. I wrote the code for checking
student db projects when I was teaching a db course, so the output
includes warnings on what I considered common issues. The code is too
long to post here, so email me privately if you want the code, making the
obvious correction to my email address.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:27 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.