[AccessD] [Fwd: Default Page Size]

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu Jan 26 11:25:23 CST 2006


Charlotte:

I put this code:

If Me.fraPaperSize = 1 Then
    Access.Printer.PaperSize = acPRPSLetter
Else
    Access.Printer.PaperSize = acPRPSA4
End If


into the event that calls the report in question.  On my printer it 
doesn't print any differently with either setting but I would expect 
that, I guess as I haven't got any A4 paper to test it with.  I'll send 
it to the user to see if it solves the problem.

But have I got the code right?  Should it go in the open event of the 
report itself instead of the calling procedure in the form?

MTIA,

Rocky


Charlotte Foust wrote:
> I don't think so.  I know AXP does, but I don't recall it in A2k.
>
> 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: Wednesday, January 25, 2006 9:27 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] [Fwd: Default Page Size]
>
>
> O.  But A2K has this printer object?  (Suppose I could go take a look 
> for myself)
>
> Rocky
>
>
> Charlotte Foust wrote:
>   
>> No, Rocky.  Remember, this is older code that predates the Access 
>> Printer object.  The user sets a paper option in the app configuration
>>     
>
>   
>> to tell us whether he uses letter/legal or A4 paper.
>>
>> Charlotte
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
>> Smolin
>> - Beach Access Software
>> Sent: Wednesday, January 25, 2006 8:54 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] [Fwd: Default Page Size]
>>
>>
>> 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