🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: JPEGS into Records

#523
From: Steve T
Date: Thu, 09 May 2002 14:11
80 lines
4626 bytes
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: <dsvC8.122542$v7.10470386@bin6.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!news-xfer.siscom.net!nntp2.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!bin6.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>

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 07:11:38 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-xfer.siscom.net!nntp2.aus1.giganews.com!nntp.giganews.com!nntp3.aus1.giganews.com!bin6.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>
Subject: Re: JPEGS into Records
Lines: 82
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: <dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com>
NNTP-Posting-Date: Thu, 09 May 2002 09:11:21 CDT
Organization: Giganews.Com - Premium News Outsourcing
X-Trace: sv3-WK7GWUfMv2zO2HaKurY2cZDT8T3ePWQ6pIdajsJm1UIv3FTkU5Caa3cl9MyDw7vSQNdTd/A6zwpFt7z!8tAzw5rrCi0c6dfQHuRiXVWnb67RZP0YbRncj6RxlAMO00Lz1GKFKwV6gp8KHaIefGGXg5l66eGF!MFPe/uJgFGIDpQ==
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:11:21 GMT