[AccessD] A2K: Recordset

Thanks Stuart.
I am storing the path as a string in the table though
.Picture Is just one of the properties I wanted to set that was being held
in the dB

Just wanted to do it from the recordset

Many thanks

Darren



-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Stuart McLachlan
Sent: Tuesday, 25 February 2003 2:42 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2K: Recordset


irect copy froOn 25 Feb 2003 at 12:54, Darren Dick wrote:

> Hello all
> I want to set a recordset for a report. Then I want controls on
> the report to equal fields from the recordset.
>
> Something like
> dim rst as recordset
> set rst = "select * from Users where Clue > 0;"  ' Thanks Charles
>
> Say in the table Users there is a field called LogoPath (Text Data Type)
> Say I have an image control on my report called imgLogo.
> I want the .Picture property of the image control to equal LogoPath, so...
>
> Me.imgLogo.Picture = rst.LogoPath
>
> How do I do this????
>
> Many thanks in advance
>

Direct copy from a working system:
CandPhotoName is a text field holding the name of the photo.
The location of the photos is "hardwired"

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    imgCandidate.Picture = "\\elecsrv\common\images\" & CandPhotoName
End Sub



--
Stuart McLachlan
Lexacorp Ltd
Application Development,  IT Consultancy
http://www.lexacorp.com.pg

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com