Search results

No. Actually, the list of users is on a subform based on a query that includes an Image container bound to the field [picture]. The subform is displayed as "Continuous" on the main form. The subform includes the fields [Picture], [User], and [Image]. [Image] is the only visible field on the...

The control source is a text field (hidden) with a the location of the pictures in a network folder.

Now that I have set it up, it's working great. However, I am having a flickering issue with the images. The form (or at least the images) seem to reload(echo/repaint) anytime I do anything outside that form or even when i go back to that form from somewhere else. It is affecting performance...

Bingo! This works. I suppose it wouldve worked with the other field too. Thank you!

Not yet. I know I am missing syntax or something because It works fine if the I click the textbox field with the name of the user but when I click the image from it will only change the user to the first user on the list.

Yes. The control source is [User] from table [Users] (bad naming here, I know, but this is only for my use and it's not used outside this form).

Thank you! I was overthinking it. I just added the imageframe to that subform. Now it shows the users image. However, I had an OnClick event that if I clicked on the user name it would change the name in a combo box on the Main Form. When I added the Onclick event to the picture it only...

The subform is displayed as a datasheet. Now I am wondering if it would be easier to use recordset here and reference either the table or the subform.

Hey all, I have a small change that I am working on for a control console form I have. Currently, the form includes a sub-form that gives a list of all the users logged into the database. I am trying to get an image frame to load the corresponding ID picture for each user with the hopes that...

Perfect. Thank you. Works great. Resolved!

One last question regarding syntax - How do I include either error handling or cause the code only to run when the workerID.value is Not Null The image shows what the event looks like. Sometimes we have to clear the worker name which will clear the worker id and because it's an afterupdate...

Yes. The code you suggested works perfectly! Thank you very much for all your help!

Yes!!! I just figured it out. I was putting the code in an Event that happens BEFORE the workerID is populated by the AFTERUpdate Event so the WorkerID is was not allowing for the change. I figured it out now.

I may be placing it in the wrong spot, When I debug it does not open a window, it only highlights the strSQL line

Yes, to both those questions.

I am getting a syntax error: Any ideas? Syntax Error (missing operator) in query expression '[EmployeeID]=',

This is perfect. I couldnt find the correct syntax for this and it seems I wasnt using the correct phrasing for when doing a Google search. Thank you again. I will report back with what finally works!

Unfortunately, the supervisors are technically the supervisors for the Clients specifically. They are supervisors to ALL the workers, if that makes sense. So, for internal purposes the employees are regarded in that way. It's dumb and i've been fighting it for a long time but its how they...