I am trying to code a spreadsheet from Access 2003 that will print in landscape on a 1-wide format. I can get the landscape setting but the code for 1-wide is not working or holding in the saved spreadsheet. I am trying with the following code:
xlsSheet.pagesetup.Orientation = xllandscape
' xlsSheet.pagesetup.printgridlines = True
xlsSheet.pagesetup.printheadings = True
xlsSheet.pagesetup.leftheader = "Weekly Handbag Report"
xlsSheet.pagesetup.rightheader = "&D &T"
xlsSheet.pagesetup.PrintArea = "A2:P" & LastLine
' xlsSheet.pagesetup.FitToPagesTall = ""
xlsSheet.pagesetup.fittopageswide = 1
xlsSheet.pagesetup.printtitlerows = activesheet.rows(1).Address
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: