🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: JPEGS into Records

#520
From: Bruce M. Thompson
Date: Wed, 08 May 2002 16:18
45 lines
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!tkmsftngp05
References: <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