By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Exporting and saving report to pdf or word.

P: 20
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?????
Sep 11 '07 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,271
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.
Sep 19 '07 #2

Denburt
Expert 100+
P: 1,356
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.
Sep 19 '07 #3

NeoPa
Expert Mod 15k+
P: 31,271
Thanks Denburt.
I don't use that much so I had a quick look-see but couldn't find it :(
Sep 19 '07 #4

Denburt
Expert 100+
P: 1,356
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.
Sep 19 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.