🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: JPEGS into Records

#524
From: Bruce M. Thompson
Date: Thu, 09 May 2002 14:33
93 lines
4864 bytes
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: <u5lXnZ29BHA.1656@tkmsftngp07>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!paloalto-snf1.gtei.net!news.gtei.net!enews.sgi.com!msrnewsc1!tkmsftngp01!tkmsftngp07
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>

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 07:35:21 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>
Subject: Re: JPEGS into Records
Date: Thu, 9 May 2002 10:33:40 -0400
Lines: 95
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: <u5lXnZ29BHA.1656@tkmsftngp07>
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!paloalto-snf1.gtei.net!news.gtei.net!enews.sgi.com!msrnewsc1!tkmsftngp01!tkmsftngp07