Re: [MS_AccessPros] Please help with VBA code

 

Ken,

It looks like you are storing FullName with jpg in the Map field. This would suggest your image relies on Map field rather than a concatenated value.

How does your image get its source?

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of kenaf42@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, January 2, 2019 12:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Please help with VBA code

 

Thank you Duane, it worked but it does not show the image unless I go back to previous  record and then back to the new record then image is there. I try it in After Update event same problem. What should be added to this code?

Private Sub Map_GotFocus()

Map = [fullname] & ".jpg"

End Sub

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (8)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1
• New Photos 1

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___