Article View: comp.databases.ms-access
Article #525Re: JPEGS into Records
From: Steve T
Date: Thu, 09 May 2002 14:51
Date: Thu, 09 May 2002 14:51
115 lines
5826 bytes
5826 bytes
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:
<f2wC8.143604$Lj.11383922@bin4.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!bin4.nnrp.aus1.giganews.com.POSTED!not-for-mailReferences:
<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>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: 10f31b,d83a670d2ccaafe9 X-Google-Attributes: gid10f31b,public X-Google-Thread: 101bdd,d83a670d2ccaafe9 X-Google-Attributes: gid101bdd,public X-Google-Thread: ff0ac,d83a670d2ccaafe9 X-Google-Attributes: gidff0ac,public X-Google-ArrivalTime: 2002-05-09 07:52:12 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!bin4.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> Subject: Re: JPEGS into Records Lines: 117 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: <f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com> NNTP-Posting-Date: Thu, 09 May 2002 09:51:55 CDT Organization: Giganews.Com - Premium News Outsourcing X-Trace: sv3-primeW3jYqLT5pnTbEiH2Pv9VqF8HRUuxVrNvM2acITtND5KXMGVEno3R9p4+AQdMyfzFLyLHDU0YBO!mYCbolw07hIUb39n751x2W4bzizqTUq+npL0Bv1Ftq+sw3rMdwg/JuISAyIYdujYCBO72dPs6+GH!2rT27lTFxXTFsA== 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 14:51:55 GMT