JPEGS into Records

Article View: comp.databases.ms-access

Article #519

Back to comp.databases.ms-access Previous Next

#519

From: Matt
Date: Wed, 08 May 2002 15:33

22 lines
2333 bytes

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: <abbggm$kra$1@news6.svr.pol.co.uk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!diablo.theplanet.net!diablo.theplanet.net!news.theplanet.net!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111343,d83a670d2ccaafe9,start
X-Google-Attributes: gid111343,public
X-Google-Thread: 101bdd,d83a670d2ccaafe9,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 10f31b,d83a670d2ccaafe9,start
X-Google-Attributes: gid10f31b,public
X-Google-Thread: ff0ac,d83a670d2ccaafe9,start
X-Google-Attributes: gidff0ac,public
X-Google-ArrivalTime: 2002-05-08 08:38:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!212.74.64.35!colt.net!diablo.theplanet.net!diablo.theplanet.net!news.theplanet.net!not-for-mail
From: "Matt" <matt@slippednospampleasedisk.fsnet.co.uk>
Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.forms,microsoft.public.access.gettingstarted
Subject: JPEGS into Records
Date: Wed, 8 May 2002 16:33:38 +0100
Lines: 24
Message-ID: <abbggm$kra$1@news6.svr.pol.co.uk>
NNTP-Posting-Host: modem-710.articuno.dialup.pol.co.uk
X-Trace: news6.svr.pol.co.uk 1020872022 21354 217.135.28.198 (8 May 2002 15:33:42 GMT)
NNTP-Posting-Date: 8 May 2002 15:33:42 GMT
X-Complaints-To: abuse@theplanet.net
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