filepath output issues (1 Viewer)

GaryPanic

Smoke me a Kipper,Skipper
Local time
Today, 01:46
Joined
Nov 8, 2005
Messages
3,294
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
 
Last edited by a moderator:

JHB

Have been here a while
Local time
Today, 10:46
Joined
Jun 17, 2012
Messages
7,732
You're missing a " + & " to much and I've some doubts about the spaces before and behind the \.
DoCmd.OutputTo acOutputReport, "test Rpt", acFormatPDF, "S:\ZoomData\Barking\CLIENTS\" & me.Quoteno & " \ "& " & QuoteNo & ".PDF", False
So correct .
Code:
 DoCmd.OutputTo acOutputReport, "test Rpt", acFormatPDF, "S:\ZoomData\Barking\CLIENTS\" & me.Quoteno &  "\" & QuoteNo & ".PDF", False
 

GaryPanic

Smoke me a Kipper,Skipper
Local time
Today, 01:46
Joined
Nov 8, 2005
Messages
3,294
Yeap...
I thought i was missing a comma or something -

that did the trick .

big thanks

Have a great Christmas break

G:eek:
 

Users who are viewing this thread

Top Bottom