Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Wed Jan 25 11:26:34 CST 2006
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