Hi!
My program reads an Access 7.0 database and then populates a label control
array with names. I'm trying to get the program to load an image control
array with either OLE objects in the Access table or by using a reference to
an actual bitmap.
Here's the code:
'recEmpInfo is my recordset
With recEmpInfo
i = 0
Do Until .EOF
Image1(i).Visible = True
Image1(i).Picture = recEmpInfo!Image ' *** Here's where it
doesn't work
Image1(i).ToolTipText = recEmpInfo!Tooltip
lblEmpName(i).Visible = True
lblEmpName(i).Caption = recEmpInfo!Name
.MoveNext
i = i + 1
Loop
.Close
End With
I've also tried using code like this:
Picture = recEmpInfo!Image
Image1(i).Picture = LoadPicture([Picture])
to pass a location like c:\temp\picture.bmp to the LoadPicture
function....no deal. I keep getting type mismatch and a wonderful assortment
of other messages. The problem is definitely in the *** noted line of code.
Can a wiseperson please help me?
Thanks in advance!
Stephen