Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Jan 24 23:14:11 CST 2006
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