Display Image on form

[usfarang]

I'm trying to display a picture I have already for an employee on frmEmployees on another form.
tblEmployees
EmpID
ProfilePicture
Path
'ProfilePicture field contains the full path and .jpg file location.
I want it to display that users picture on another form.
How can I do this? I have tried DLookup with no luck.

Me.Pic = (DLookup("[ProfilePictureImage]", "tblEmployees", "[EmpID]='" & Me.txtUserID.Value & "'"))

[ranman256]

in a form of the record that has the photos,use a OLE bound image box for the OLE field.
load the image into paint, select it, copy,
in the form , paste into the image box.

then in other forms or reports, use the image box bound to that field. It will show.

[Welshgasman]

Is txtUserID text of numeric?
Any fields that I had with ID in them like EmpID, were autonumber?

You also say ProfilePicture holds the full path to the image file, yet you use ProfilePictureImage in the DLookUp() ?

[usfarang]

ProfilePicture is the field name in the table, ProfilePath is also a field in the table. ProfilePictureImage is the actual picture with its control source set to ProfilePicture. This is all on frmEmployees and works fine.
I need to get that picture on another form as well for the SAME person associated with it when their name is entered.
Ex; I enter John Doe and his picture shows up. Having difficulty with the syntax is all. The actual code of course will be like this.
"C:\Users\usfar\Pictures\Camera Roll\WIN_20211221_16_06_09_Pro.jpg"
This comes from ProfilePicture on frmEmployees. I use a FileDialog to get the picture.
Hope this clears everything up. Nothing is store, only linked.
txtuserID is TEXT , it is the users name. YES EmpID is a number, PK. It is the employees ID.
tblusers
userID is their name, a text field.
So if txtUserID on the form = txtuserID in tblUsers = their name.

[usfarang]

Here is a screenshot of frmEmployees with the ProfilePath & ProfilePicture. ProfilePictureImage (The actual Picture = ProfilePicture as it's control source) and ProfilePath is where the picture is stored.
Hth

[Welshgasman]

ProfilePicture is the field name in the table, ProfilePath is also a field in the table. ProfilePictureImage is the actual picture with its control source set to ProfilePicture. This is all on frmEmployees and works fine.
I need to get that picture on another form as well for the SAME person associated with it when their name is entered.
Ex; I enter John Doe and his picture shows up. Having difficulty with the syntax is all. The actual code of course will be like this.
"C:\Users\usfar\Pictures\Camera Roll\WIN_20211221_16_06_09_Pro.jpg"
This comes from ProfilePicture on frmEmployees. I use a FileDialog to get the picture.
Hope this clears everything up. Nothing is store, only linked.
txtuserID is TEXT , it is the users name. YES EmpID is a number, PK. It is the employees ID.
tblusers
userID is their name, a text field.
So if txtUserID on the form = txtuserID in tblUsers = their name.

So you are comparing one field which is a number to another field which is text?

You need to either find the EmpID of the user and use that in the above code, or just search for the userid in the table Employees.

You have to match like with like. You are comparing apples and oranges.

[usfarang]

You are correct. My mistake, when trying too many different things. This is my latest attempt which still does not work. txtuserID and userID are both text fields.
But of course this even if it worked would not get me the file name of the picture?

Me.ProfilePicture = (DLookup("[ProfilePicture]", "tblEmployees" = "C:\Users\usfar\Pictures\Camera Roll", "tblUsers", "[userID]='" & Me.txtUserID.Value & "'"))

[Welshgasman]

No, with code like that, it would not.
I would expect the path to the picture to be returned to Me.ProfilePicture.Picture

For that to happen you would need code more like

Me.ProfilePicture.Picture = (DLookup("[ProfilePicture]", "tblEmployees" "[userID]='" & Me.txtUserID & "'"))

Now if you do not have UserID in table employees, that is not going to work.
So, get one piece of data to be able to use that for the retrieval of the picture path.

Take it one step at a time. Why isn't UserID in tblEmployees?, there must be some way of linking users to Employees?

[usfarang]

The form does not use tblEmployees, it uses tblUsers. The picture is stored in tblEmployees.
EmpID is in tblEmployees which is the PK. EmpName is the employees name.

tblEmployees
EmpID = PK
EmpName
ProfilePicture
ProfilePath

tblUsers
userID = PK which is TEXT
UserName = users name


EmpName (tblEmployees)= UserName (tblUsers)
Not that it should make a difference but the form is NOT bound.

[usfarang]

A bit of duplication, not normalization but I want this to work. In the process of just using tblusers and adding in ProfilePicture and ProfilePath.
Stay Tuned. Not a big issue since the files are not being stored.

[Welshgasman]

So from your latest update on information

Me.ProfilePicture.Picture = (DLookup("[ProfilePicture]", "tblEmployees" "[EmpName]='" & Me.txtUserID & "'"))

Plus it does make a difference if the form was bound. Then you could bring in the path of the picture in the form recordsource and have no need for a Dlookup().

[usfarang]

="C:\Users\usfar\Pictures\Camera Roll"
This does not work or get me the picture?
I set the control source of the image to this, is this not correct?

[usfarang]

Now have picture on form but it does not change for the user.
ProfilePicture="C:\Users\usfar\Pictures\Camera Roll"
ProfilePictureImage=[ProfilePicture] & [txtUserID].[Value] & "'

[usfarang]

Blow a Horn, Sound the Trumpets, Success at last.

Many Thanks WelshGasman for the help.