Stored Company Logo

[Guest]

Hi,
Using Allen Browne’s routine to return to the last record and the tblSys so
used, Allen recommended that this table can easily be used to lookup the
company name for inclusion in reports. Is there a way to use this table to
store a frequently used company Logo to be looked up when generating reports?
Many thanks
Mary

 

[Larry Linson]

Using Allen Browne's routine to return to the last
record and the tblSys so used, Allen recommended
that this table can easily be used to lookup the
company name for inclusion in reports. Is there a
way to use this table to store a frequently used
company Logo to be looked up when generating
reports?

Last time I looked, Allen Browne had a rather large number of tips, hints,
items, and examples on his site, and I suspect I am not alone in thinking
that someone here helping you would be much, much easier if you'd be more
specific than "Allen Browe's routine." I don't know for certain that I would
be able to help you, if you did clarify, but there is a good chance that
someone could.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thank you Larry for replying. The Allen Browne tip I was referring to is
"Return to the same record next time form is opened" in which Allen refers
to other uses and I wondered if it could be used for a logo as well as a
company name.
Regards
Mary

 

[Larry Linson]

You can easily store the path and file name of the logo's image file in such
a table, and retrieve it.

How are you displaying the logo? As background or in an image control? (If
you had in mind using a Bound OLE Frame, I would generally recommend against
that.)

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks for coming back Larry. Each report has the logo as an image control.
Because the database is devolped on another computer and there are other
copies (updated 3 monthly) it wouldn't be feasible to use an external linked
file for the logo.
I will give it up.
Thank you for your trouble.
Mary

 

[Larry Linson]

Thanks for coming back Larry. Each report has the logo
as an image control. Because the database is devolped on
another computer and there are other copies (updated 3
monthly) it wouldn't be feasible to use an external linked
file for the logo.
I will give it up.
Thank you for your trouble.
Mary

Perhaps all is not lost, Mary.

Take a look at the example referenced in the following. I don't see why you
could not use the BLOB technique to distribute the database, but instead of
unBLOBing to a temporary file for each use, write it to an image file in the
same folder as the database the first time a new copy of the database is
used. Then, if you try to use that image and find it's not there... either
deleted, or the database has been moved, just create a new one in the same
folder as the database.

Or, if you've got lots of processing power on your machines, you could just
use the technique as shown, only in the OnPrint event of the Report's
Section where the picture is to be displayed, instead of the OnCurrent event
of a Form, as demonstrated.

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry, I am very grateful for the effort you have put into this but I have to
admit that it is obviously out of my league. The file normally resides on a
server but there are stand-alone copies also in laptops. I was looking for a
way to decrease the file size a little. Thanks a lot, perhaps other readers
can make use of your suggestions.
Regards
Mary

 

[Larry Linson]

Larry, I am very grateful for the effort you have put
into this but I have to admit that it is obviously out
of my league.

Just as a matter of interest, what do you mean, exactly, by "out of my
league?" Do you mean that you aren't conversant in VBA code, or something
else? That information may help me with future answers in the newsgroups.

The file normally resides on a server
but there are stand-alone copies also in laptops. I was
looking for a way to decrease the file size a little.

If you use an embedded picture in the Reports, then you will be paying the
price for multiple copies of the logo (in an internal bitmap format,
relatively large). If you use the BLOB technique, you can store it only
once and save some storage, and pay a bit of processing time when the
reports are run.

But you can accomplish making the file smaller by only embedding the picture
in one place, as follows: Create an unbound form, frmMyLogo, just large
enough to hold an image control to display the logo, remove all other
display "artifacts," place the image control on the unbound form, embed the
logo image and save it. Then on each Form or Report where you now have an
Image Control displaying the logo, replace the Image Control with a Subform
or Subreport Control using the frmMyLogo as its Source Object.

Because you are just referring to the same Form in each of those (that is,
the one Form containing the embedded Logo), you will reduce the size of your
database, and, if you are careful with the Format properties, it will look
no different than the Image Control those Subform/Subreport Controls
replace.

Larry Linson
Microsoft Access MVP