Article View: comp.databases.ms-access
Article #531Re: JPEGS into Records
From: Matt
Date: Fri, 10 May 2002 09:42
Date: Fri, 10 May 2002 09:42
41 lines
3033 bytes
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-mailReferences:
<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