Article View: comp.databases.ms-access
Article #520Re: JPEGS into Records
From: Bruce M. Thompson
Date: Wed, 08 May 2002 16:18
Date: Wed, 08 May 2002 16:18
45 lines
3064 bytes
3064 bytes
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:
<OYEAWvq9BHA.2396@tkmsftngp05>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!colt.net!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp05References:
<abbggm$kra$1@news6.svr.pol.co.uk>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-08 09:18:57 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> Subject: Re: JPEGS into Records Date: Wed, 8 May 2002 12:18:04 -0400 Lines: 47 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: <OYEAWvq9BHA.2396@tkmsftngp05> Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.forms,microsoft.public.access.gettingstarted NNTP-Posting-Host: 207.3.148.58 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!colt.net!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp05