Re: JPEGS into Records

Article View: comp.databases.ms-access

Article #528

Back to comp.databases.ms-access Previous Next

#528

From: Bruce M. Thompson
Date: Thu, 09 May 2002 19:10

26 lines
2589 bytes

Okay. In the report, in place of the form's "OnCurrent" event procedure to set the image control's
"Picture" property, you would use the "OnFormat" event procedure for the section of the report that
contains the image control:

'*********************START EXAMPLE
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

      'Set the Picture property of the image control
    Me![ImageFrame].Picture = Me![ImagePath]

      'If no image path or typo in same, hide image control so wrong image won't show
      '  Disable error handling, first, in case typo in image path value
    On Error Resume Next
    Me![ImageFrame].Visible = (Len("" & Me.ImagePath.Value) > 0) _
                                And Dir$("" & Me.ImagePath.Value) <> ""

      'Re-enable error handling
    On Error Goto ...

End Sub
'**********************END EXAMPLE

"Steve T" <stevethompson@REMOVEMEsouthwestcontract.com> wrote in message
news:OpxC8.109288$q8.11508423@bin3.nnrp.aus1.giganews.com...
> I used the first link.  It was the one for Q148463
<snip>

Technical Details

Message-ID: <OTXFT049BHA.1828@tkmsftngp05>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp05

References:

<abbggm$kra$1@news6.svr.pol.co.uk> <OYEAWvq9BHA.2396@tkmsftngp05> <C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com> <dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com> <u5lXnZ29BHA.1656@tkmsftngp07> <f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com> <eNhNey29BHA.1012@tkmsftngp04> <OpxC8.109288$q8.11508423@bin3.nnrp.aus1.giganews.com>

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: ff0ac,d83a670d2ccaafe9
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 101bdd,d83a670d2ccaafe9
X-Google-Attributes: gid101bdd,public
X-Google-ArrivalTime: 2002-05-09 12:12:17 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> <OYEAWvq9BHA.2396@tkmsftngp05> <C3vC8.142982$Lj.11337655@bin4.nnrp.aus1.giganews.com> <dsvC8.122542$v7.10470386@bin6.nnrp.aus1.giganews.com> <u5lXnZ29BHA.1656@tkmsftngp07> <f2wC8.143604$Lj.11383922@bin4.nnrp.aus1.giganews.com> <eNhNey29BHA.1012@tkmsftngp04> <OpxC8.109288$q8.11508423@bin3.nnrp.aus1.giganews.com>
Subject: Re: JPEGS into Records
Date: Thu, 9 May 2002 15:10:27 -0400
Lines: 28
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: <OTXFT049BHA.1828@tkmsftngp05>
Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.forms,microsoft.public.access.gettingstarted
NNTP-Posting-Host: 207.3.148.93
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp05

Reply to Parent Message