[AccessD] [Fwd: Default Page Size]

Charlotte Foust cfoust at infostatsystems.com
Wed Jan 25 10:26:52 CST 2006


No, code selects the appropriate report format based on the paper
selection.

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


So do you have two formats of the same report, selectable by the user? 

Rocky


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