Rabu, 02 Desember 2015

Re: [MS_AccessPros] Re: Help with VBA code

 

actually, in Access 2010 (starting with 2007), the Image control can have a ControlSource.  This can be an equation -- or a call to a function.  This gives the ability to show pictures on a continuous form without code to render them individually.

Although your form is probably a single view and you may not need to know this to implement for the solution here, it is good to know!

warm regards,
crystal

~ have an awesome day ~


On 12/1/2015 2:04 PM, wrmosca@comcast.net [MS_Access_Professionals] wrote:
All you need to do is set the .Picture property of an image control.


Private Sub cmdLoadPic_Click()
    Me.Image14.Picture = "C:\DB_Pictures\Dilbert_BugReward.bmp"
    
End Sub

To remove the picture, just set the .Picture proprty to an empty string like this:

Private Sub cmdUnload_Click()
    Me.Image14.Picture = ""
    
End Sub

Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog

 


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

ACCESS 2010

Please help,  I need code for button on click event to embed a picture in FORM and code for second button to remove the embedded photo from The same form.


 

__._,_.___

Posted by: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar