🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: JPEGS into Records

#527
From: Steve T
Date: Thu, 09 May 2002 16:25
172 lines
7466 bytes
I used the first link.  It was the one for Q148463


"Bruce M. Thompson" <NO~SPAM_bthmpson@bigfoot.com> wrote in message
news:eNhNey29BHA.1012@tkmsftngp04...
> <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: <OpxC8.109288$q8.11508423@bin3.nnrp.aus1.giganews.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!feed2.news.rcn.net!rcn!border1.nntp.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!bin3.nnrp.aus1.giganews.com.POSTED!not-for-mail
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> <eNhNey29BHA.1012@tkmsftngp04>

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: ff0ac,d83a670d2ccaafe9
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 101bdd,d83a670d2ccaafe9
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 10f31b,d83a670d2ccaafe9
X-Google-Attributes: gid10f31b,public
X-Google-ArrivalTime: 2002-05-09 09:25:34 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!feed2.news.rcn.net!rcn!border1.nntp.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!bin3.nnrp.aus1.giganews.com.POSTED!not-for-mail
From: "Steve T" <stevethompson@REMOVEMEsouthwestcontract.com>
Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.forms,microsoft.public.access.gettingstarted
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> <eNhNey29BHA.1012@tkmsftngp04>
Subject: Re: JPEGS into Records
Lines: 174
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <OpxC8.109288$q8.11508423@bin3.nnrp.aus1.giganews.com>
NNTP-Posting-Date: Thu, 09 May 2002 11:25:18 CDT
Organization: Giganews.Com - Premium News Outsourcing
X-Trace: sv3-eA1DoMlQ1RY+fMVDYh5xwjyU4wKw9m9+XUs39IQ1k2H5eeCJRU9e0kP+OYMmJsZ07azhg5MG1Lsrn7M!nGaAh10HTcrmGgwT4r3LBmZUDD26KGHHPCILP5dlqKyzBq7CrL4y9P5NcMMRE/l6l7ZQOIAOUJlz!CKyUOItKyDZzJQ==
X-Complaints-To: abuse@GigaNews.Com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
Date: Thu, 09 May 2002 16:25:18 GMT