🚀 go-pugleaf

I have the same problem.  I have pictures of all of our products in the
product table.  fields are productID, type, description, picture, price.

The backend (tables only) is about 40MB.  Could I use the same technique you
explain here.  I don't really need the pictures to show up on a form, but I
do need them to show up on a report.


"Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
news:OYEAWvq9BHA.2396@tkmsftngp05...
> Matt:
>
> Check out the following web pages - they might prove useful to you
(especially when it comes to
> avoiding the BLOAT problem caused by actually storing images in your
tables):
>
> http://www.mvps.org/access/forms/frm0030.htm
> http://www.lebans.com/loadjpeggif.htm
> ... and/or (I'm not sure you need the preceding if you implement the
following) ...
> http://www.lebans.com/loadsavejpeg.htm
>
> If you still need assistance, just post a reply within this thread (reply
to this message, for
> example) so we can find it.
> --
> Bruce M. Thompson, Microsoft Access MVP
> bthmpson@big~SPAM_NOT~foot.com
> >>No Email, Please. Keep all communications
>     within the newsgroups so that all might benefit.<<
>
>
> "Matt" <matt@slippednospampleasedisk.fsnet.co.uk> wrote in message
> news:abbggm$kra$1@news6.svr.pol.co.uk...
> > Hi
> >
> > I am building a database that requires the inclusion of JPEGS into the
> > form for the particular table. All the required JPEGS are in one folder
> > but I am having snags getting the pics into the form. Each form record
> > already has data in it, I am now simply trying to add the pics.
> > The pic field is an OLE object, and I am inserting the JPEG by right
> > clicking on the relevant  field and choosing insert object, then create
from
> > file. I the select browse and locate the relevant pic. This pic will
insert
> > fine. I go to do the next record, and when I select browse, the folder
> > containing the pics seems empty, although I know it isn't!
> > The only way I can get it to work is by closing the whole database and
> > opening it again.
> > As I have a lot of records to do, it seems wrong that this is the only
way
> > to do it, and I must be doing something wrong.
> >
> > Can anyone please advise me what I am doing wrong and point me in the
right
> > direction.?
> >
> > Many thanks in advance
> >
> > Matt Newman
> >
> >
>
>
>