Display pictures in Northwind on the VB form

[งChrissiง]

Hi,

In Northwind, there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it
give me a error saying "unable to bind to field...". I used the same way to
display the logos in the pubs and there is no problem. In VB, I used ODBC
data source with ADODB control and a picture control. Later, I tried DAO
control and the error is "Invalid data".

This happened when I used either ACCESS or SQL Server database. When I open
Northwind in ACCESS, I can see the pictures.

Could you try it and tell me how to solve the problem?

Thanks a lot

[Paul Clement]

On Sat, 28 May 2005 19:04:11 -0800, "§Chrissi§" <anubisof...@hotmail.com> wrote:

¤ Hi,

If you're referring to the Photo field in the Employees table, it's an OLE Object data type. This
would require that you use the OLE control in Visual Basic if you are binding to a Data Control.

Paul
~~~~
Microsoft MVP (Visual Basic)