Exporting and saving report to pdf or word.

[zaiena]

hello,
i'm trying to make a button that export my report to word or pdf formate i'm trying to use macros to that but it doesn't help me.maby i can use procedure code instead of macros code. is there a way to do that?????

[NeoPa]

There doesn't appear to be any native support for either of these in Access I'm afraid. There are solutions but they depend on third-party software. Some of them are easier than others to program but I'll leave others who know about the various software to fill in any details.

[Denburt]

rtf (rich text format) is a format that Word can read and MS Access exports to with very few issues.

In a Macro you would look for the OutputTo Method then select the rest of the settings.

If you wanted to use code you would select the button in question look at the properties for the button and select the On Click event enter [Event Procedure] into the field then click the button to the right of this field. Once in VBA enter something like:

docmd.OutputTo acOutputReport,"Your Report Name",acFormatRTF

While in the vba window if you highlight the word OutputTo then press F1 you can see how this method works and all the arguments etc.


Let us know if this helps.

[NeoPa]

Thanks Denburt.
I don't use that much so I had a quick look-see but couldn't find it :(

[Denburt]

Your quite welcome, I use it quite frequently but I am usually required to do it manually from inside the database, the people in our office are always asking for one time this or that exported, so I see this a lot. I think it is their way of checking on me j/k.


I hope it helps the OP, let us know how this works out for you zaiena.