Using Image Control Accessing Access 2000 Database from VB6

[TajulBashar]

Hi,

I am qite new to VB database programming. I would like to know how do I have an image control in VB6 [SP3] form connected to an Access 2000 database tables's OLE[Image field, bitmaps] field using ADO code/datacontrol.

I have another question, how to implement a RecordSource [of course, without using ADO datacontrol] which will retrieve fields from multiple tables.

I will greately appreciate your help. Thnaks.

[Clunietp]

First Question:
Add an ADO data control to your form, and bind a picture/image control to your picture field via the data control.

Second Question:
If your two tables are in the same database, you can perform a SQL join to join the tables together, giving one recordset. If they are in separate databases, you can build your own recordset at runtime that you can populate.

HTH

Tom