Article View: comp.databases.ms-access
Article #527Re: JPEGS into Records
From: Steve T
Date: Thu, 09 May 2002 16:25
Date: Thu, 09 May 2002 16:25
172 lines
7466 bytes
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-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> <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