ACCESS FEED: Re: [MS_AccessPros] Set controlsource for image object by vba

Selasa, 29 September 2015

Re: [MS_AccessPros] Set controlsource for image object by vba

In Access 2003, I use an OLE Object, with control source as a table with an OLE Object field holding images, to produce an image changing on a form.

Dave W

----- Original Message -----

From: onno.knol@pbl.nl [MS_Access_Professionals]

To: MS_Access_Professionals@yahoogroups.com

Sent: Tuesday, September 29, 2015 8:28 AM

Subject: Re: [MS_AccessPros] Set controlsource for image object by vba

Dear Crystal, I do run msaccess 2010. I checked the object model for the image control on MSDN and it does not mention a controlsource property. But apparently it CAN be set from the form properties. but not by VBA! Maybe it inherits the property form a partent object, and should I refer to that? Or is it hidden, can I access it in another way?

Any help is welcomed. Onno

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

Hi Onno,

upgrade to Access 2007 or higher -- then you can have a ControlSource for an image.

warm regards,
crystal

~ have an awesome day ~

On 9/28/2015 11:44 AM, onno.knol@... [MS_Access_Professionals] wrote:

Dear pros,

I have an image control on my form, for which i set the controlsource in the form properties. It is set to a field in the database and when you move to another record,the image changes.

That works fine. Now later i want to change the source. That seems not to be possible The image object does not have a controlsource property. Is there a workaround for this?

Kind regards, Onno Knol