William Hindman
wdhindman at dejpolsystems.com
Mon Dec 21 13:35:33 CST 2009
...and if you need to provide user editing of the report contents you can insert an rtf control (I use Leban's freebie) and let the user edit the verbiage before printing/distributing ...access reports provide a great deal more control over the formatting and layout of your end product than Word will provide without a lot of work. William -------------------------------------------------- From: "Reuben Cummings" <accessd at gfconsultants.com> Sent: Monday, December 21, 2009 11:44 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Try this one again > I would stick with Access reports. I make all kinds of reports for > government work all using Access. And if the formatting is tough to copy > you'd be surprised what you can convince people to change to. > I've nearly changed the culture of "claims" in the state of Indiana. The > old form was ridiculous - and I couldn't match it. So I convinced one > county to change years ago and now it's on the verge of being the > standard. > > And if you are placing parts of your data into pre-worded paragraphs (the > paragraph wording is pre-defined other than your data) do all the > paragraph > building in code. > > Reuben Cummings > GFC, LLC > 812.523.1017 > > >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark >> Sent: Monday, December 21, 2009 11:08 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Try this one again >> >> >> Yeah, I did find this...thank you. For some reason...I'm >> guessing I didn't have it set at creation time...the format >> didn't follow from the table into the form, so I had to set >> this on the form itself. This was an easy one. >> >> Thanks to your help...and a few others...I finally got this >> near completion. I can't believe I'd actually done this >> before and just forgot it. >> >> I've got a couple more issues to iron out, but I think I'll >> put them in a separate post...one is just advice sought, and >> another is...well, I don't think I actually need help on >> it...I actually got code from this list long ago, and I just >> have to work it to fit this current project. Well, since it >> is just advice, I guess I will ask here... >> >> I am using this data to print a voucher, which the witnesses >> will take to the treasurer's dept, and get a check. For the >> actual letter, would you suggest an Access report, or pumping >> the data out to a Word form? I figure the Access report would >> be the easiest, but I'm limited there w/formatting. I am >> currently leaning toward do this, but I am working out some >> spacing issues...making it work w/different data placed into >> the paragraphs. >> >> Oh, and I do have one issue, which I will be putting in a >> different post... >> >> Thanks again! Take care! >> >> >>> "A.D. Tejpal" <adtp at airtelmail.in> 12/19/2009 3:15 AM >>> >> You are most welcome John! For forced display of two >> decimal positions, just make sure that format property is >> also set as desired (e.g. Standard, Fixed or Currency) >> >> Best wishes, >> A.D. Tejpal >> ------------ >> >> ----- Original Message ----- >> From: John Clark >> To: Access Developers discussion and problem solving >> Sent: Friday, December 18, 2009 21:47 >> Subject: Re: [AccessD] Try this one again >> >> >> Well A.D., I think you are officially my hero today! ;o) >> >> First of all, as soon as I saw your code...specifically the >> change to the SQL of the query...I regained my memory. This >> is exactly what I had done in the past, and I had totally >> forgotten about it. So, because I had done it that way >> before, and I am pressed for time, I went this way >> again...and it worked...for the most part it worked. >> >> Now I am on to something I totally did not >> foresee...something I've never run into before. I am having >> simple arithmetic problems now >> >> (A) The biggest problem...decimals aren't showing up >> properly. I've got the number type setup as double w/2 >> decimals, and I am still seeing "0.2" and "15" instead of "15.00" >> >> and >> >> (B) It doesn't seem to want to perform the addition of the >> standard fee. The witness gets mileage, based on the going >> rate, multiplied by their distance, and this is working. But, >> they also get a stipend of $15.00, and this isn't working right now. >> >> I'm not real worried about this last one...yet...because >> I'm guessing it is something dumb that I am missing or doing, >> and I've just got to go back and proof my work for a mistake. >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >