🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: JPEGS into Records

#531
From: Matt
Date: Fri, 10 May 2002 09:42
41 lines
3033 bytes
Thanks to all who posted possible solutions. I have tried most of them, and
have succeeded in a separate table with the images. I tried to have the
images in the form but not the table, but got bogged down with the
properties.
All I need do now I imagine is link the pics to their relevant details.
I am going to be building a web site to link to this database, using
ultradev. Has anyone any tips before I embark on that? It will include a
shopping basket!

Many thanks again

Matt
"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: <abg4mf$p3j$1@news8.svr.pol.co.uk>
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!newspeer.clara.net!news.clara.net!btnet-peer!btnet!diablo.theplanet.net!news.theplanet.net!not-for-mail
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: 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-10 02:42:39 PST
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!newspeer.clara.net!news.clara.net!btnet-peer!btnet!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: Re: JPEGS into Records
Date: Fri, 10 May 2002 10:42:26 +0100
Lines: 43
Message-ID: <abg4mf$p3j$1@news8.svr.pol.co.uk>
References: <abbggm$kra$1@news6.svr.pol.co.uk>
NNTP-Posting-Host: modem-523.articuno.dialup.pol.co.uk
X-Trace: news8.svr.pol.co.uk 1021023759 25715 217.135.28.11 (10 May 2002 09:42:39 GMT)
NNTP-Posting-Date: 10 May 2002 09:42:39 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