Windows login based display picture on Main form!?

[KrisDdb]

Hello All



I have a splash form that gets the user info based on the windows login. When I click the login button on this splash form, it takes me to the main form of my database. What I am trying to do is, to set up an image control that would display the image of the user that has logged in, on the main form. Is this possible? Any ideas/suggestions?

Best,

Kris

[JeroenMioch]

Extract the username on the main form and display the name in a hidden textbox.
Then add the format behind the value of that textbox.

Make sure the picture name is the same as the username.

I can try that out for you if you like.

[KrisDdb]

Den,
Thanks for the quick reply.
Can you please elaborate on 'add the format behind the value of that textbox'? I already have a text box that extracts the username and displays it on the top right of the main form to let users know who is logged in. This is where i am trying to put the picture of the logged in user.. beside it. I can name the pictures of the individual users to be similar to the login names. what do I do after that?

[JeroenMioch]

Well i have been looking for you to see what the best way to go is. In Holland we have a saying that there is more then one road that leads to Rome. In other words, different approaches might work.

I tryed making an unbound Image field on the main form and code the form_load so that the form knows where to get the picture from. But to my dismay, i didnt succeed yet. But ill give u a glimps of the code im trying this with

fldPictureTime = Len(Dir("I:\MainDir\Jeroen\Incidents database\" & Me.fldUserNameAfterLogin & ".jpg"))

I ran out of time because im at work, Ill try again tomorrow.