🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #526

Re: JPEGS into Records

#526
From: Bruce M. Thompson
Date: Thu, 09 May 2002 15:18
138 lines
6450 bytes
<chuckle>

I supplied 3 links in my response to Matt. They represent at least 2 different solutions.

Which link is it that worked for you?

Could you provide any details on what you did to implement the method provided via the link that
worked for you?

(These questions are not just to allow others, and myself, to understand how to approach helping you
make this work, but they are also to provide a clearer explanation of the problem and of what the
final solution might be for those who are having similar problems.)
--
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.<<


"Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
news:f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com...
> I found out how to do it on the link in your above response to Matt.
>
>
> "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
> news:u5lXnZ29BHA.1656@tkmsftngp07...
> > You don't say "how" you got it to work in a form, but I presume that you
> can use the same approach
> > in your report. You might want to enlighten us on the "how" of your
> success before I can feel
> > confident about my presumption, however.
> > --
> > 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.<<
> >
> > "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> > news:dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com...
> > > OK, I got it to work on the forms.  Now, how do I get the picks to show
> up
> > > on a report?  Can this be done?
> > >
> > >
> > > "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
> > > news:C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com...
> > > > 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
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <eNhNey29BHA.1012@tkmsftngp04>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp04
References: <abbggm$kra$1@news6.svr.pol.co.uk> <OYEAWvq9BHA.2396@tkmsftngp05> <C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com> <dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com> <u5lXnZ29BHA.1656@tkmsftngp07> <f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111343,d83a670d2ccaafe9
X-Google-Attributes: gid111343,public
X-Google-Thread: 101bdd,d83a670d2ccaafe9
X-Google-Attributes: gid101bdd,public
X-Google-Thread: ff0ac,d83a670d2ccaafe9
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10f31b,d83a670d2ccaafe9
X-Google-Attributes: gid10f31b,public
X-Google-ArrivalTime: 2002-05-09 08:19:19 PST
Reply-To: "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com>
From: "Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com>
References: <abbggm$kra$1@news6.svr.pol.co.uk> <OYEAWvq9BHA.2396@tkmsftngp05> <C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com> <dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com> <u5lXnZ29BHA.1656@tkmsftngp07> <f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com>
Subject: Re: JPEGS into Records
Date: Thu, 9 May 2002 11:18:09 -0400
Lines: 140
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
Message-ID: <eNhNey29BHA.1012@tkmsftngp04>
Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.forms,microsoft.public.access.gettingstarted
NNTP-Posting-Host: pm41-112-185.worldpath.net 209.187.112.185
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp04