Output a named Word report

[Rainer2000]

Hi

when I output a report to Word using the "Office link" button, Access gives it an automatic name. (I think it is always the name of the report).

Is there any way to give it a specific name which is taken from a field?

Rainer

 

[ZmrAbdulla]

Create your own button with "OutputTo" command.
See "OutputTo Method" in the VBA help

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[Rainer2000]

Hallo Zamer,
thanks for the hint. That's the way I made it work.

Dim stDocName As String
stDocName = "ANGEBOT"
DoCmd.OpenReport stDocName, acPreview, whereCondition:="Nr=" & [NR]
DoCmd.OutputTo acReport, , acFormatRTF, [Text220], False
DoCmd.Close

I am not sure if it is 100% correct, but it works.

I also created a field [Text220] in the Form, where I keep the file name.

Thanks again,

Rainer


Rainer

 

[ZmrAbdulla]

Yes that is the way..

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.