[AccessD] [Fwd: Default Page Size]

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Wed Jan 25 10:54:05 CST 2006


So you poll the printer class to see what paper was selected? Very slick.

Rocky


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




More information about the AccessD mailing list