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

Hi Onno,

for an example, look at my free contact template here:

free Contact Template for Access including Project Management and Common Business Needs
http://msaccessgurus.com/Contacts.htm

click on the red pushpin icon (yellow background) to pop up a form that can show pictures -- and look at the code to do it. The pictures use a path relative to the database.

warm regards,
crystal

~ have an awesome day ~

On 9/29/2015 1:28 AM, onno.knol@pbl.nl [MS_Access_Professionals] wrote:

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