Exporting Documenter to Word

[kryptkitten]

Hi All,

I am using Access 2000 and not sure how to export the Documenter to Word. I see the option for a text file, but would like to do Word so I can do any editing I might need to do. How can that be done?

Thanks!

Stacy

 

[GaryPanic]

the simple answer is no - you can try to export to word - but I would not bank on it if your report is complicated ....

You can get Access to talk to word - but then your reports are word reports to begin with - tere are tow basic options the first being Bookmarks - (I am not their biggest fan - so am predjice against them ) the second is super easy word - its a merge function built by someone who is bloody clever -

effectively its a straight forward mailmerge option - but you will need to read up on it -

check the samples for more info -

slight draw back - number formatting goes tits up - so you need to be up on "switches" in word (basically foramtting numbers in word )
after this its pretty easy


If you check bookmarks as well this might be more you thing


best of luck

 

[kryptkitten]

I think we are talking different things here. I am talking about a specific tool in Access that generates documentation of the database called Documenter. Tools>Analyze>Documenter. I have seen folks mention in other posts that this can be done, but no one mentions how. I can see how to export to rich text format, just a plain old text doc, or to Excel, but not to Word so just wanting to know if there is something I am not seeing or missing in order to be able to do this.

Thanks!

Stacy

 

[AccessJunkie]

Hi Stacy,

The Documenter doesn't have a built-in way to do this.

You might give my free CSD Tools Add-in a try for this. For most of the reports, you can just click the Word button to output the database reports to Word. You can then modify to your heart's content.

You can find my add-in here:
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

If you're using Access 200, make sure you download the 2000 version of the tool.

I also have a web page listing other options for documenting tables here:

http://www.accessmvp.com/JConrad/accessjunkie/doctable.html

Hope that helps,

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[kryptkitten]

I will give that a shot! Thanks so much!

 

[Nastya]

To my mind, when you want to safe time and money, it's better to resort to resume writing services

 

[reddwarf]

seems simple but cant you just out put the report to an RTF document. My DB does this and it opens up in word. ( degfault for rtf files ). I do it like this :

Add a button then add this code to button from the form.

Dim strReport As String
Dim strWhere As String

MsgBox "Give a message sayong your report is being exported to word."
strReport = "YOUR REPORT NAME"
strWhere = "[LINK FIELD] = """ & Me![LINK FIELD] & """"
DoCmd.OpenReport strReport, acViewPreview, , strWhere
DoCmd.OutputTo acOutputReport, strReport, acFormatRTF, [LNK FIELD] & " NAME OF REPORT.rtf", True
DoCmd.Close

the LINK FIELD is what ever you are using to identify reports, on my DB is a ref number, and when i generate reports I only want to export the 1 report for that ref. this seciton can be removed if you are doing an overall report.

this opens up the report viewer, then experts it to word, then closes the report viewer leaving word open for you to modiy report. Be aware that some graphic formatting is lost in the conversion.

probably not what you want but may come in handy.

 

[PaulWilson]

Of course, the newer versions of Access export the Database Documenter output to Word and to Excel as well as to rtf, pdf and XPS. The only dang problem is that the Excel export is all screwed up. I spent some time trying to get the output into a proper table in Excel so that I could filter by property and field name (taking advantage of those great Excel features).

Does anyone know of a way to get at database object properties via VBA so that the output is reasonably useful?

PaulWilson

 

[Jeanette Cunningham]

Have a look at this code - it prints table properties to the immediate window.
http://www.allenbrowne.com/func-06.html