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