Kamis, 03 Januari 2019

Re: [MS_AccessPros] Please help with VBA code

 

Duane, on first field I have only SKU provided by vendors and manufacturers and cannot be edited because then their system would not recognize it on purchase orders. On second field (Map) I have the code you helped me with:

Private Sub Map_GotFocus()

Map = [fullname] & ".jpg"

End Sub

 

And on form Current Event:

Private Sub Form_Current()

If IsNull(Me.[Map]) Then

    Me.Image10.Visible = False

    Else

    Me.Image10.Picture = "C:\Images\" & [Map]

    Me.Image10.Visible = True

End If

End Sub

As I said it works but no image is imported while new record is filled but if I go to previous  record and back to present record image is there.

 

__._,_.___

Posted by: kenaf42@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (10)

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.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar