JTBrown New Member of the Forum

[JTBrown]

First, I have been a user of Access sine the 2003 version but retired in 2011 so a bit rusty.
I picked up converting a Not-for-profit group's paper system to Access over the past year.
Most of my work in the past has been with PCs that have a version of Access installed and have created many multi-user split front-end with shared back-end files.
My current project is to use the Runtime library on 2-3 PCs purely as in-house user Data Entry and Report Printing.
Any help on the following issue would be greatly appreciated.
I have a fanfold 4x6 inch label and with the PC (Access installed) in the Report I set the printer setting and then save the Report. It works fine after that. However the PC with the 2016 Runtime Library installed and the *.accde executable file, the Page Size is defaulting to 3x13 inch. I have Create a Open in Print Preview and although I can set the Page Size then and it prints fine, the next time it open or prints it does not remember the 3x5 inch.
Any Thoughts on why the Page size is not being transferred to the Executable or code that I can set the Page Size?
Thanks in advance.

 

[MajP]

@JTBrown
A moderator will move this into another forum to get an answer or you can copy the question part and start a new Thread. There is a Reports and Access Module forum. The same people look at all the Access stuff so does not really matter. Normally you will not get answers here. If you do create a new one just mention here you creating a new thread. And you can place the url to that thread here.

 

[NauticalGent]

Welcome aboard!

 

[pbaldy]

Welcome. As MajP mentioned, I've moved the thread to a more appropriate forum.

 

[The_Doc_Man]

Usually Access will refer to the settings on the Default Printer (whatever it is).

You can find the default or selected printer using Application.Printer and you can adjust the settings of a printer via VBA using appropriate properties.

Application.Printer property (Access)

Office VBA reference topic

learn.microsoft.com

Printer object (Access)

Office VBA reference topic

learn.microsoft.com

As to "Any Thoughts on why the Page size is not being transferred to the Executable or code that I can set the Page Size?" you can look in this thread for some links:

Is it possible to set Printer settings using VBA

I have a need to be able to change Printer settings, specifically the Page Size, using VBA code. These are not standard Page Sizes but specific to a Sticky Label Printers attached to multible computers. Is this possible? And if so how. I have seen some code that nominates a specific printer...

www.access-programmers.co.uk

As to why it loses settings, this might be helpful (though I don't know because I'm sure your printer and mine aren't the same.

 

[CJ_London]

the next time it open or prints it does not remember the 3x5 inch.

That is because it is a .accde file. No changes can be made to the report (or form) and then saved. As doc has said the settings are stored in the report printer properties but will be over written on the fly with the default printer when on another machine.

Since they are using runtime, try supplying a .accdb - though they will still need to save the report for the changes to stick. You may need to provide some code to do this since runtime does not have save functionality so far as I am aware

Not sure if 3x5 is a standard size, you will need to investigate

Me.printer.papersize=see dropdown

Never tried to create a custom paper size but I understand this is done in the specified printer, not access, and is then referenced using acPRPSUser from the dropdown

Again, not tried but another possible option in vba is with me.printer set the default size to false then set the itemsizewidth and height to 3x5 converted to twips

For .accde, the vba code will need to run each time the report is opened so use the open or load event

 

[JTBrown]

That is because it is a .accde file. No changes can be made to the report (or form) and then saved. As doc has said the settings are stored in the report printer properties but will be over written on the fly with the default printer when on another machine.

Since they are using runtime, try supplying a .accdb - though they will still need to save the report for the changes to stick. You may need to provide some code to do this since runtime does not have save functionality so far as I am aware

Not sure if 3x5 is a standard size, you will need to investigate

Me.printer.papersize=see dropdown

Never tried to create a custom paper size but I understand this is done in the specified printer, not access, and is then referenced using acPRPSUser from the dropdown

Again, not tried but another possible option in vba is with me.printer set the default size to false then set the itemsizewidth and height to 3x5 converted to twips

For .accde, the vba code will need to run each time the report is opened so use the open or load event

I worked with the printer manufacturer and resolved the issue, by setting defaults in the printer to landscape that was not being properly transferred to the Printer, Thanks to everyone for the warm welcome and suggestions.