[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