|Printing to Custom Size Paper||Bob Darlington||10/18/10 12:07 AM|
I've already explored this through a different 'Subject' line, and received
some helpful replies, but unfortunately I still can't get it to work.
So, my question now is:
Has anybody successfully used code similar to that below to change paper
size to a custom size when printing to specialised forms?
Application.Printer = Application.Printers("Cheque Printer")
The code runs without generating an error, but invariably opens the report
|Re: Printing to Custom Size Paper||Arvin Meyer||10/18/10 5:51 AM|
I would create a custom Printer object that used this paper size and install
it on each user's machine. Then set the report to that specific printer and
Arvin Meyer, MCP, MVP
Co-author: "Access Solutions", published by Wiley
|Re: Printing to Custom Size Paper||Bob Darlington||10/18/10 4:18 PM|
That is what I've got at the moment.
But whenever the users open the report in the mde, the paper size is set to
I've been using TS to load the program as an mdb, selecting the 'Cheque'
paper size and creating the mde remotely.
It works, but is a pain in the backside.
BTW, I'm using Access 2002.
|Re: Printing to Custom Size Paper||Tony Toews||10/19/10 2:45 PM|
On Mon, 18 Oct 2010 08:51:34 -0400, "Arvin Meyer" <arv...@invalid.org>
Actually all you need to do is create the printer size on the printer
Go into the list of Printers under the Settings button from the Start
Then you can follow the below steps inside Access to choose the just
|Re: Printing to Custom Size Paper||Bob Darlington||10/19/10 3:27 PM|
That is what I'm doing at the moment.
But when the app is loaded on the client's server, the page size selection
I thought that I could overcome this problem using the Printer Object code.
|Re: Printing to Custom Size Paper||Tony Toews||10/19/10 10:45 PM|
On Wed, 20 Oct 2010 08:27:41 +1000, "Bob Darlington"
Right but are the users creating that paper size on the clients
|Re: Printing to Custom Size Paper||Bob Darlington||10/19/10 11:09 PM|
|Re: Printing to Custom Size Paper||Tony Toews||10/20/10 11:01 PM|
On Wed, 20 Oct 2010 16:09:10 +1000, "Bob Darlington"
Well, darn then I don't have a clue.
Tony (sorry to be so unhelpful.)
|Re: Printing to Custom Size Paper||Bob Darlington||10/21/10 12:04 AM|
Thanks for trying Tony.
It seems that no-one has successfully used the Printer object for custom
|Re: Printing to Custom Size Paper||David-W-Fenton||10/21/10 4:18 PM|
"Bob Darlington" <b...@notheredpcman.com.au> wrote innews:email@example.com:
> It seems that no-one has successfully used the Printer object for
Have you compared this in MDB vs. MDE? I recall that you're trying
|Re: Printing to Custom Size Paper||Bob Darlington||10/21/10 5:45 PM|
I'm still testing in the mdb on my development PC and I can't get it to work
Hopefully, if I can get it to work in the mdb, it will (might) work in the
mde at the client site.
That's my goal anyway.
I still haven't heard from anyone who has successfully done so in either
|Re: Printing to Custom Size Paper||yanto||10/23/10 1:00 AM|
I have the similar problem, so far I did what Tony suggested, I go to
client place, setup CUSTOM page on server properties, open my report
in design mode, change pagesize as CUSTOM and recompile it, so far
it's ok, but I prefer to do once a time so I use this way, I put my
report on backend database so you just set once for the custom page
then I call that report from my frontend so now everytime I copy my
modified fron'tend, I don't need to set the pagesize in my client
place even I can email it...but this doesn't works if I use Ms Access
Runtime in my client place
On Oct 22, 7:45 am, "Bob Darlington" <b...@notheredpcman.com.au>
> Brisbane"David-W-Fenton" <NoEm...@SeeSignature.invalid> wrote in message
> > contact via website only http://www.dfenton.com/DFA/- Hide quoted text -
> - Show quoted text -
|Re: Printing to Custom Size Paper||Phil||10/24/10 12:45 AM|
Have you tried the old fashioned method (AK2) using things like PRTMIP &
|Re: Printing to Custom Size Paper||Bob Darlington||10/24/10 3:33 PM|
|Re: Printing to Custom Size Paper||Bob Darlington||10/24/10 3:36 PM|
Unfortunately, I have a mixture of runtime and non runtime installations.
I hadn't thought about attaching the report to the backend though, so I'll
have a play with that idea.
|Re: Printing to Custom Size Paper||Phil||10/24/10 4:02 PM|
On 24/10/2010 23:33:04, "Bob Darlington" wrote:
Don't think that is a problem
|Re: Printing to Custom Size Paper||Bob Darlington||10/24/10 5:02 PM|
I thought that those methods required the reports to be able to be opened in
design mode, which you can't do in mde.
|Re: Printing to Custom Size Paper||Phil||10/25/10 9:18 AM|
On 25/10/2010 01:02:12, "Bob Darlington" wrote:
Er um deep crimson
Of course you're right
|Re: Printing to Custom Size Paper||Bob Darlington||10/25/10 4:38 PM|
Thanks to all for their help on this one.
I've reluctantly come to the conclusion that I can't use the Printer object
to reset a custom paper page size after migrating my front end to the client
PCs, so I've given up on that tack.
Instead, I moved along the line suggested by Yanto (in this thread) and
created a new db to hold the Cheque report with attendant queries, linked
relevant tables to the backend db and loaded it into the user's 'CurrentDir'
I can then open it with OpenCurrentDatabase as follows:
Set objAccess = New Access.Application