TransferText

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

Guest

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
 
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
 
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?
 
Looks like you need to get Access reinstalled. Maybe those are optional
install components.

-Dorian
 
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.
 
Back
Top