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