Displaying multiple images in an Access 2000 report

[Schubndrhrbrt]

Greetings one and all,

I'm stuck! I'm attempting to design a report that displays multiple
user-selected images which correspond to individual records. The code below
is as close as I've been able to get, but it only repeats the first image for
every record in the recordset. Any help would be most appreciated.

Private Sub Report_Activate()

Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strSQL As String
Dim lidx As Long
Dim strPath As String

Set db = CurrentDb

strSQL = "SELECT * FROM tblVisuals " & "WHERE nfldidxItems = " & lidx & ""
lidx = Me!idxItems
strPath = tfldImagePath

Set rs = db.OpenRecordset(strSQL)

With rs
Me!imgItem.Picture = (strPath)
End With

rs.Close

End Sub

 

[Cindy M.]

Hi =?Utf-8?B?U2NodWJuZHJocmJydA==?=,

I'm stuck! I'm attempting to design a report that displays multiple
user-selected images which correspond to individual records.

Since you haven't received a response here, try in the Access-specific
newsgroups, where most of the specialists hang out.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail