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

Reading this now, it sounds promising and will report on my level of
success.
On May 31, 2013 1:12 PM, "David A Gibson" <davidalangibson2010 at gmail.com>
wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>