Aug 16, 2001 #1 Gti Programmer Joined Jul 23, 2001 Messages 99 Location PT what i need is when i hit a button the database report is automaticaly pass to a Word file *.DOC How can i do it in VBA code? Tkx
what i need is when i hit a button the database report is automaticaly pass to a Word file *.DOC How can i do it in VBA code? Tkx
Aug 21, 2001 #2 ide Programmer Joined Apr 10, 2001 Messages 236 Location EU if you want to output your report to a word file, you could do for example like this: Private Sub Command1_Click() DoCmd.OutputTo acOutputReport, "MyReportName", acFormatRTF, "D:\temp\out.doc", -1 End Sub Upvote 0 Downvote
if you want to output your report to a word file, you could do for example like this: Private Sub Command1_Click() DoCmd.OutputTo acOutputReport, "MyReportName", acFormatRTF, "D:\temp\out.doc", -1 End Sub
Aug 21, 2001 #3 Aivars Programmer Joined May 4, 2001 Messages 687 Location LV Hi, Gti! Look at thread702-123001 if you want to select output repot's file name on browser. Aivars Upvote 0 Downvote