[AccessD] set the DefaultPicture of an unbound image control to an attachment in a recordset field?

Ah Hah!  I've never used an attachment field.  Keeps the tables smaller.

An alternative might be to add your icon into the title bar of the forms.
This link provides some code (which I haven't tested).
http://www.access-programmers.co.uk/forums/showthread.php?t=123449

Thanks!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
(VBACreations.Com)
Sent: Friday, May 31, 2013 1:17 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] set the DefaultPicture of an unbound image control to
an attachment in a recordset field?

No, Dan, it is an attachment. In fact an .ico file I built from clipart and
attached to the table where it is being held in an attachment field. The
code I presented that I am currently using sorta made that clear, or so I
had thought. Sorry if not.

    rsPic.Fields("FileData").SaveToFile SOME_PATH 
    imgApplicationIcon.DefaultPicture = SOME_PATH


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Friday, May 31, 2013 2:02 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] set the DefaultPicture of an unbound image control to
an attachment in a recordset field?

Hi William,

When you say an attachment, do you mean a .bmp file where the full path to
that file is listed in a field in your table?

If so, that's just 
    
    imgControl.Picture = rst!FileFullPath

HTH,
Dan