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

Hope this helps.

Using Single Images Across Multiple Forms and Reports in Access 2010
Applications
http://msdn.microsoft.com/en-us/library/office/gg490661(v=office.14).aspx

Image.PictureType Property (Access)
http://msdn.microsoft.com/en-us/library/office/ff197027(v=office.14).aspx

David Gibson

-----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