TransferText

[Shell]

In Access 2000, I am trying to use doCmd.TransferText to create a Word
coument of an Access report. I cant seem to get it to work at all. I would
rather not use "Publish with Word" because it does not accuratly reproduce
the report cosmetically.

Maybe another option would be better!

Any help would be appreciated.

Thanks

 

[mscertified]

Word will not retain the formatting of an Access report. The only format that
will do that is snapshot format.
Full details about 'TransferText' are available in Access HELP.

-Dorian

 

[Shell]

I tried the following
"DoCmd.OutputTo strOutputReport, "rptNewShopOrder", "Snapshot Format",
"F:\ACCESS_NEW-VERSION\SEGTEST.snp"

I get the run time error 2822
"The formats that enable you to output data as Microsoft Excel, rich-text
format, MS-DOS test, or HTML file are missing from the Windows registry"

How do I get these formats in the registry?

 

[mscertified]

Looks like you need to get Access reinstalled. Maybe those are optional
install components.

-Dorian

 

[boblarson]

As mentioned by mscertified, you will need to add additional items to your
install. You likely had a TYPICAL install and the stuff that has to do with
snapshots is not installed by default, if I remember correctly. You have to
do a CUSTOM install to get that. You also need to do a custom install if you
want VBA help installed.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.