Hi Guys
i am sure this is a quickie but
I have a report that i need to pdf -
I can export
DoCmd.OutputTo acOutputReport, "test Rpt", acFormatPDF, "S:\ZoomData\barking\CLIENTS\21329\ " & QuoteNo & ".PDF", False
however I want to export to a folder on the server - when i put in Me.QuoteNo it goes wobbly - I am sure its a simple thing ..
any pointers would be most helpful
DoCmd.OutputTo acOutputReport, "test Rpt", acFormatPDF, "S:\ZoomData\Barking\CLIENTS\ & me.Quoteno & " \ "& " & QuoteNo & ".PDF", False
i am sure this is a quickie but
I have a report that i need to pdf -
I can export
DoCmd.OutputTo acOutputReport, "test Rpt", acFormatPDF, "S:\ZoomData\barking\CLIENTS\21329\ " & QuoteNo & ".PDF", False
however I want to export to a folder on the server - when i put in Me.QuoteNo it goes wobbly - I am sure its a simple thing ..
any pointers would be most helpful
DoCmd.OutputTo acOutputReport, "test Rpt", acFormatPDF, "S:\ZoomData\Barking\CLIENTS\ & me.Quoteno & " \ "& " & QuoteNo & ".PDF", False
Last edited by a moderator: