PDA

View Full Version : Default Legal paper



bkudulis
07-26-2005, 04:10 PM
I have a report that is printed to different printers by the user. The report has to be printed on Legal paper. When I change the paper select in the report it works fine when the report is printed to the printer that was selected as the default printer at the time the report was saved. If I print the report to a printer that was not my default printer the reports prints on letter size paper. I want the paper to be legal no matter what printer the report goes to and no matter what the default printer is. This has been driving me nuts for a long time.

xCav8r
07-26-2005, 04:48 PM
This might be helpful: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101

bkudulis
07-27-2005, 07:37 PM
I don't ever remember having this problem with preious version of Access. Does anyone else know of this problem in Access? If the report is set to print on legal then regardless of the printer selected it should print on legal.

xCav8r
07-27-2005, 07:46 PM
What about the API code from that article?

bkudulis
07-27-2005, 08:05 PM
I figured that I was just missing something somewhere. If this is a problem for everyone then the article does look like it has the solution. I figured that I was just missing something simple especially since i don't remember having this problem before.

xCav8r
07-27-2005, 08:10 PM
I have never tried printing on legal paper with Access reports, so I wouldn't know. BTW, here's the Access equivalent of that Word article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_Printers.asp

bkudulis
07-27-2005, 08:34 PM
I am going to try it, thanks.

xCav8r
07-27-2005, 08:55 PM
BTW, what country are you in that it's 4:50 AM?

bkudulis
07-27-2005, 09:00 PM
US West Coast

xCav8r
07-27-2005, 09:11 PM
Ah, incorrect TZ. Always the Americans who are too stupid to set the correct TZ. You're making me look bad!!!!! J/K ;)

Default must be GMT.

xCav8r
07-29-2005, 09:29 PM
bkudulis, were those articles helpful?

bkudulis
07-31-2005, 07:16 AM
I was still hoping that someone would confirm that the problem exists. I am not sure if this will work or not since it refers to Access 2003 and I am using 2000. We can close it though.

xCav8r
07-31-2005, 08:19 AM
I'm pretty sure the problem exists. If any program were to work with legal paper, it would be Word, but it doesn't. There's too much code out there from Microsoft to make me think there's something that we're missing. MHO.

xCav8r
08-08-2005, 08:54 PM
Where do you stand with this? Did you come up with a different solution?

mdmackillop
08-09-2005, 10:42 AM
My workaround for such problems is to add another version of the printer(s) which is set to the relevant papersize settings and naming it accordingly eg HP_Legal

bkudulis
08-09-2005, 11:10 AM
No I have not found a solution for this yet. The Access solution is for Access 2002 and the Word solution is for Bins which are different on all of the printers that are being used. I'll just have to keep looking.

xCav8r
08-09-2005, 05:21 PM
Malcom's suggestion is a good one unless you're in a big enterprise environment where your access application will be deployed and printing on a multitude of printers (which might mean butting heads with IT folks about extra drivers). Anyway, that code for Access I linked to should do the job. The version is irrelevant. Also, the code for Word could be adopted pretty easily.

bkudulis
08-09-2005, 06:10 PM
I have tried copying over the sample DB that was in the link (Access) and it keeps giving me errors about things not being defined. According to the article it is for Access 2002. In Access 2002 there are new Printers Collections and Printer objects whic are not in 2000. I can run it in a 2000 db that has the 2002 version installed on the machine but as soon as I put it on a 2002 version I cannot open the form because of the errors. I am totally frustrated with this thing, it shouldn't be this difficult.

xCav8r
08-09-2005, 06:14 PM
I'm sorry. I made the stupid assumption (don't know why) that you were using 2003. I need to recheck the Word code now.

xCav8r
08-09-2005, 06:16 PM
Well, I think the Word code could be adopted, since it doesn't use the printers collection. But, what about Malcom's suggestion? Why not make another driver and set the tray there to what you want?

bkudulis
08-09-2005, 06:23 PM
There are 5 different printers all of different types and accessed from different locations. This is te only thing that is holding me up right now from getting this deployed.

bkudulis
08-09-2005, 06:24 PM
The other thing is that I cannot change it in design mode either because it is a mde file type.

geekgirlau
08-09-2005, 06:48 PM
One other item to throw into the mix ...

I haven't tested this in 2002, but I know in 2000 Access had the delightful habit of periodically losing all non-standard page settings on reports, including paper size and orientation. :igiveup:

bkudulis
08-09-2005, 06:55 PM
When I use the word solution and create a new module it gives me the error of Variable not defined for Active Printer.

bkudulis
08-09-2005, 06:58 PM
I was able to get the bins to populate a list box in word but the same code does not work in access. I am not sure how that is going to help me anyway because the bins don't tell me what paper is in there.

xCav8r
08-09-2005, 07:01 PM
Here's a 2000 article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acproPrtDevNames.asp (you might find the substitute for the active printer here)

This too: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acproPrtDevNames.asp