Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Image in OLE Object

Status
Not open for further replies.
mans

mans

Programmer
Joined
Mar 18, 2000
Messages
136
Location
AU
Hello,

I am attempting to display an OLE object in Access2000 in an ole object (ole1) on a VB6 form. I have been using the code below and it comes up with error messages stating “Item no found in this collection” or “Type Mismatch” when I run it, can somebody please let me know how I need to change the code to get it to work.

Set rs = daoDB36.OpenRecordset("SELECT DetailsIndex.Surname, DetailsIndex.Image FROM MemberDetails INNER JOIN DetailsIndex ON MemberDetails.Member_ID = DetailsIndex.Member_ID")

Text2 = "" & rs!Surname
Ole1 = "" & rs!image

Thank You
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question Question
I can't find the routine to download the image file anymore
Replies
1
Views
401
strongm
strongm
44MARCO
  • Locked
  • Question Question
MACRO SETTINGS - VBA PROJECT OBJECT MODEL
Replies
2
Views
1K
strongm
strongm
2009luca
  • Locked
  • Question Question
Never used image webp
Replies
1
Views
535
strongm
strongm
OCM
  • Locked
  • Question Question
Filters in access forms
Replies
2
Views
484
OCM
OCM
sal21
  • Question Question
delete ll picturebox in a form
Replies
8
Views
397
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top