Maybe a silly a question, but I want to know if there's an easy way to export my report to Word in an almost identical copy.
I know how to open word and such, but is there a command that will basically paste my report into a word document?
thanks
Maybe a silly a question, but I want to know if there's an easy way to export my report to Word in an almost identical copy.
I know how to open word and such, but is there a command that will basically paste my report into a word document?
thanks
export as .rtf then rename to .doc
thanks, but how do i do it in vba code attached to a button click event?
i want to just click a button and the report gets opened up in word, or saved in word...either or
DoCmd.OutputTo acReport, reportName, acFormatRTF, outputfile
thanks!
that works for the most part. But I have a form that is sort of a questionairre. I created lines for people to write on when the form is printed. Everything exported to word except the lines.
also, is there a way for the user to select where the file is saved when the button is clicked and to possibly name it as well? Maybe that's asking to much. I didn't have any trouble finding the file as it was saved in my documents, but if its not too difficult it would be cool to be able to save to a specific location.
you may do it as using a browse button to get the path and file name, store them in 2 varibales,then use this 2 variables in the outputTo parameters.
I didn't test but I think it would work.
---Disregard, didnt see new posts-------
thanks man! my online help isn't working right now for some reason...normally i would just press F1 on the command i'm not sure about.
The format is perfect for all of the detail stuff, but the report header doesn't get exported. Also, the report format doesn't get transferred either. For instance, on my report I have labels that are all blue with an off white text. When the report gets transferred to Word, I can barely see my labels anymore. Can i use VBA to set the font color of all items to black before exporting?
lol...i appreciate your help thus far regardless...sorry to be a pain