Mike Mattys
mmattys at rochester.rr.com
Tue Apr 27 16:16:27 CDT 2010
I should mention that a Word Template allows you to use the Send To: option and neatly embeds the report into an Outlook email ... Michael R Mattys Business Process Developers www.mattysconsulting.com ----- Original Message ----- From: "Max Wanadoo" <max.wanadoo at gmail.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Tuesday, April 27, 2010 5:08 PM Subject: Re: [AccessD] Weird problem - ugly logo in reports > Yes, > And also in Access you have THREE options on how to view the image. > Try each one in turn from the properties dialog. > It can be CLIP, STRETCH or ZOOM and each one will display differently. > > Also, open it in an editor, say MS Office Picture Manager and make sure > you > have it exactly as you want it, sized etc. > > It needs to be a Bitmap > > Max > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike Mattys > Sent: Tuesday, April 27, 2010 9:32 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Weird problem - ugly logo in reports > > > > Hi John, > > Since I can remember, Access has always converted all images to bitmap > first, > thereby bloating your database. I doubt this has changed in 2007. > > After that, Access places the bitmap into your report at the width and > height you specify, > often removing scanlines and pixelating in the process of making it fit. > > Long ago, we decided to export to either bookmarked dot or rtf templates > and they come out spectacularly. > > Michael R Mattys > Business Process Developers > www.mattysconsulting.com > > ----- Original Message ----- > From: "John Clark" <John.Clark at niagaracounty.com> > To: <accessd at databaseadvisors.com> > Sent: Tuesday, April 27, 2010 10:51 AM > Subject: [AccessD] Weird problem - ugly logo in reports > > >> I've got something to run by y'all, which seems even too strange to >> ask...but, I've been looking into it for a bit now, and I'm not getting >> anywhere. >> >> I recently inherited a program, which is used by a fellow county, to keep >> track of something we do. The user department prints some reports, and >> one > >> of the items they need to print is a certificate. What this does >> currently > >> is open MS Word and print the cert, but it doesn't seem to be connected >> in > >> any way and just basically opens the last cert in Word, and they retype >> the pertinent data, which is just about 4 things (i.e. Name, SSN, >> Address, > >> and maybe one or two more things). >> >> OK, here's the thing...obviously...to me anyhow...it doesn't seem very >> "proper" to open up Word and have to type out anything...the data should >> just "happen" automagically. So, I wanted to setup the document to be a >> merge (I think). But, after gaining advice from many of you people, I >> don't think that is worthy of "plan A" either, because this seems to be >> version specific and I don't want to worry about that...believe me, in >> this place, people don't plan things out and it WILL be a problem in the >> future. >> >> So, I decided to go about this the same way I did w/my last program. >> Again, guided by several on this list, I recreated the form I needed, >> w/in > >> Access, and just did it as an Access report. Everything brought together >> at run-time and all self contained. >> >> But, here is why I am asking for input... >> >> This form has our letterhead w/in it...just a logo and address, pretty >> much. No problem, I'll just add it to the report's design. But, it looks >> terrible! The same seal that I have in word, looks awful in Access. I >> tried many different versions of our county seal, and they all look >> terrible in an Access report. >> >> Does anyone have any insight on why exactly this is the case? >> >> BTW, it is 2007 that I am using for this. >> >> Thanks for any enlightenment! >> >> J Clark >> -- >> 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 >