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

Hi William,

Since you are putting an image into the header of every form, I'm going to
assume that this image is fairly small.  In that case, it might be worth it
to embed the image in the image control, rather than set it on the opening
of every form.

HTH,
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 11:49 AM
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?

Wow, I thought I had lobbed this group an easy one... no takers yet?
----------------------------------------------------------------------------
----------------

I am wanting to have the same Header fields and image appear on every form
in my database. The query which populates these items has SQL:


SQL = ""
SQL = SQL & " SELECT "
SQL = SQL & " First([Build Date]) AS AppBuildDate,"
SQL = SQL & " First(ApplicationImage.FileData) As AppImage"
SQL = SQL & " FROM 9997_DevelopmentVersion  as Tbl"
SQL = SQL & " WHERE "
SQL = SQL & " [Build Date]=(Select Max([Build Date]) from
9997_DevelopmentVersion);"


I have also tried substituting ApplicationImage for
ApplicationImage.FileData

So far I have been unable to set an image control's defaultpicture property
to a RECORDSET FIELD from a recordset created with that SQL statement. Can
someone help with the syntax to set the DefaultPicture of an unbound image
control to an attachment identified by a field in a recordset described
above?


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com