Why yes it is. I always enjoy tidbits like this on this forum.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, December 02, 2015 4:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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.
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 (4) |
Tidak ada komentar:
Posting Komentar