John Bartow
john at winhaven.net
Mon Oct 27 19:13:18 CST 2003
Thanks to everyone for helping me out! I changed the control type to bound and everything works fine now. Dim varAppIcon As Variant With rstTemp .Edit strAppName = !fldAppName strVersion = !fldVersion varAppIcon = !fldAppIcon etc... .Close End With Me.imgAppIcon = varAppIcon Thanks again! John B. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart > McLachlan > Sent: Monday, October 27, 2003 6:14 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] A really silly and dumb - maybe even > ridiculous-accessquestion > > > On 27 Oct 2003 at 17:33, John Bartow wrote: > > > Hi Stuart: > > I store application information in a table. One piece of info I > store is a > > graphic (as an OLE object field). I have always diplayed this > on my SysInfo > > form, which was a bound form. Since I use the exact same table > and SysInfo > > form in every application I create, I moved it to my common > code library. I > > changed the entire form to work from the library and had to change the > > fields drawn from the table to unbound. Everything works fine > now EXCEPT the > > graphic. The graphic will always be stored in the table and will not be > > moved to being kept as a file. > > > > So the question is, how do I go about reading an OLE field from > the table > > and presenting it for display on an unbound form? > > I am trying to read it into a variant and place it into an > unbound object > > frame. I am not succeeding. > > > > Doesn't matter whether the form is bound or not. Still use a Bound Object > Frame and assign it's source to the field in the table using DLookup. It > will work. > -- > Stuart McLachlan > Lexacorp Ltd > Application Development, IT Consultancy > http://www.lexacorp.com.pg > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >