Exodus
Registered User.
- Local time
- Today, 08:28
- Joined
- Dec 4, 2003
- Messages
- 317
I am working on being able to print pdfs that are stored in a directory from my database. Is there any way to set the page settings in adobe from access. The pages are over sized and need to be scaled down to fit on legal size.
I am currently using this code to print the documents but they come out on the wrong size page and not scaled down.
Public Function PrintFile(sFileName As String, SFilePath As String)
On Error GoTo Err_PrintFile
PrintFile = ShellExecute(Application.hWndAccessApp, "Print", sFileName, "", SFilePath, 0)
Exit_PrintFile:
Exit Function
Err_PrintFile:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_PrintFile
End Function
I am currently using this code to print the documents but they come out on the wrong size page and not scaled down.
Public Function PrintFile(sFileName As String, SFilePath As String)
On Error GoTo Err_PrintFile
PrintFile = ShellExecute(Application.hWndAccessApp, "Print", sFileName, "", SFilePath, 0)
Exit_PrintFile:
Exit Function
Err_PrintFile:
MsgBox Err.Number & " - " & Err.Description
Resume Exit_PrintFile
End Function