[AccessD] [Fwd: Default Page Size]

Charlotte Foust cfoust at infostatsystems.com
Tue Jan 24 12:13:20 CST 2006


Rocky,

What kind of code are you using to set the paper size?  There are
actually papersize constants you can use to make it easier.  We use
these in our Access apps to make the code easier to read:  

Public Const PAPER_LETTER As Integer = 1
Public Const PAPER_A4 As Integer = 9
Public Const PAPER_LEGAL As Integer = 5

If you check the Access.Printer class, you'll get a list of the built in
constants for AcPrintPaperSize, including acPRPSA4, acPRPSLetter, and
acPRPSLegal, which have the same values as we use (our code was built
before the Printer object became part of Access).  Whichever you use,
it's what you have to pass to the printer to get the setting right.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
- Beach Access Software
Sent: Tuesday, January 24, 2006 9:31 AM
To: access Developers discussion and problem solving
Subject: [AccessD] [Fwd: Default Page Size]




Dear List:

A guy in India with whom I'm developing a preventive maintenance app is 
using A4 paper.  The report I sent him apparently doesn't print the 
whole footer unless he changes the printer.  He writes:

"The problem still persisted of the report saying only "page no 1 of " 
and not showing the total no of pages and of the second page being a 
blank, but third page showing the second page (all this only in the mtce

sch. report). I have found the cause. I found that the page set up was 
landscape and letter size. I changed the letter size to A4 and 
everything became ok! But I am not able to make it permanent - when I 
ask for the report the next time, the same problem. I had to again reset

the page size. How do I make it stick?"

But the other reports in the system apparently work OK.  The File-->Page

Setup parameters are the as the other reports - default printer is 
checked - except this one is landscape.  Any ideas?

MTIA

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com


----- Original Message -----

    *From:* Rocky Smolin - Beach Access Software
<mailto:bchacc at san.rr.com>
    *To:* R Ramamurthy <mailto:rram22 at dataone.in>
    *Sent:* Saturday, January 21, 2006 8:57 PM
    *Subject:* Re: PM?

    Ram:

    The graph can be done but it's not real easy in Access.  On the X
    axis you would also lose visibility of what machines were creating
    the scores on the Y axis.  The X axis would just be a sequence
    number.  Wouldn't seeing the list of machines with description be
    more helpful.  >From an information standpoint the graph will only
    show the user that the scores of the machines run from m to n.  So
    they will be picking an arbitrary point between the lowest and
    highest value without much visibility over the nature of the
    equipment that's being included and excluded.

    I will do a bit of research to see if there's a graphing control I
    can find so I don't have to reinvent the wheel.  Then maybe put an
    button on the form to let the user choose tabular of graphic format.

    Requiring administrator access to change the cutoff point is easy. 
    I'll attend to that.  What's the next step?

    Best,

    Rocky

     


-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com


-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list