Selasa, 29 September 2015

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

 

Hi Crystal,  I really enjoy your work.  How you do it all amazes me.  Thanks for sharing.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, September 29, 2015 11:03 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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

 







This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___

Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

.

__,_._,___

Tidak ada komentar:

Posting Komentar