[AccessD] [Fwd: Default Page Size]

Charlotte Foust cfoust at infostatsystems.com
Tue Jan 24 12:54:01 CST 2006


We format most of our reports to fit either now, which means we use
paper length and A4 width when designing the report.  If you use default
printer, that's your only choice.  Otherwise, yes, you'd have to allow
them to specify the paper size and you'd have to create some specially
formatted A4 reports if they needed the longer paper length.  

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 10:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] [Fwd: Default Page Size]


Charlotte:

I'm not using any code.  I just use default printer.  This app could be 
running in both 8 1/2 x 11 and A4, I guess.  So I didn't want to tie the

app to one size or another.  Apparently I'm going to have to put in some

kind of preference for the user to select their paper size then?

Rocky


Charlotte Foust wrote:
> 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

-- 
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