S
Sasquatch
Hello,
I'm attempting to have a Word document print out duplexed (double-sided) but
I'm not having much luck. I have a function that creates a reference to a
file using GetObject(fileName) command then uses the .PrintOut command to
print the document, but the command does not offer duplexing.
I found some code from the MS Knowledge Base -
SetPrinterDuplex(Printer.DeviceName, duplexOptionVal) - that will retrieve
the default printer and will in fact change the duplex option from off to
horizontal/vertical and print the document appropriately and thus solving my
problem (I though). But calling the function again to turn the duplexing
back off after the document has printed isn't "holding" the request. It runs
the function call with no error indications, as if it worked, but looking at
the printer's properties reveals it is still set to duplex. Basically once I
have made one call to the printer to change the duplex option (regardless if
its being set to off, horizontal or vertical) then subsequent calls will not
change the option any more until Access is closed and re-opened.
Does anyone have any ideas why the SetPrinterDuplex() function would only
allow one change, OR does anyone have any other tips on how to duplex print a
Word doc from Access?
Thanks in advance.
I'm attempting to have a Word document print out duplexed (double-sided) but
I'm not having much luck. I have a function that creates a reference to a
file using GetObject(fileName) command then uses the .PrintOut command to
print the document, but the command does not offer duplexing.
I found some code from the MS Knowledge Base -
SetPrinterDuplex(Printer.DeviceName, duplexOptionVal) - that will retrieve
the default printer and will in fact change the duplex option from off to
horizontal/vertical and print the document appropriately and thus solving my
problem (I though). But calling the function again to turn the duplexing
back off after the document has printed isn't "holding" the request. It runs
the function call with no error indications, as if it worked, but looking at
the printer's properties reveals it is still set to duplex. Basically once I
have made one call to the printer to change the duplex option (regardless if
its being set to off, horizontal or vertical) then subsequent calls will not
change the option any more until Access is closed and re-opened.
Does anyone have any ideas why the SetPrinterDuplex() function would only
allow one change, OR does anyone have any other tips on how to duplex print a
Word doc from Access?
Thanks in advance.