Good afternoon.
This will be my first question on this forum so take it easy on me as I am a total MS Access muppet.
I set up the following Macro with the idea being to automatically print a table out in Landscape A3:
Open Table:
- Name: Example
- View: Datasheet
- Data Mode: Read Only
Runcode:
- Public Function Landscape()
Application.Printer.Orientation = acPRORLandscape
End Function
Runcode:
- Public Function PageSize()
Application.Printer.PaperSize = acPRPSA3
End Function
Runcode:
- Public Function PrintDoc()
DoCmd.Printout acPrintAll, , , acHigh
End Function
This does not appear to work though. Therefore could anyone advise what I should of done.
Note: This was working fine previously so I know it can be done, I just can't remember how (a colleague overwrote the original macro, so the above is my attempt to recreate).
If you need any additional information, please let me know.