Trying to get a signature scanned file to appear on a form

I have a form that has a image block on it.  I'm trying to get a scanned signature to appear in the field with this oncurrent event of the form but it isn't working.  What am I doing wrong?

Me.imageMechEmployeeSig = DLookup("[SignatureScan]", "tblEmployees", "[EmployeeID] = " & Me.cboMech)

In the table, tblEmployees the field SignatureScan is an attachment field.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Me.imageMechEmployeeSig.Picture = DLookup("[SignatureScan]", "tblEmployees", "[EmployeeID] = " & Me.cboMech)

Open in new window

SteveL13Author Commented:
Didn't work. I get an error ---  Object doesn't support this property or method.
What kind of control is imageMechEmployeeSig?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

SteveL13Author Commented:
A bound image frame.
Try using an Unbound Image Control.
SteveL13Author Commented:
Getting close.  The form is a continuous form and the image does appear but now it appears in that field on all of the records?????
Why don't you just use a bound control. No need for code to load the picture at all.
SteveL13Author Commented:
Because then I get back to... I get an error ---  Object doesn't support this property or method.
When you use an Image Control?
SteveL13Author Commented:
SteveL13Author Commented:
I appreciate the info but I really want to use the attachment filed option in this case.  I just can't figure out why the image is repeating on all records in the continuous form.
You can't. This is a built in limitation in Access, the image control cannot be bound to a field in a continuous form, this is to prevent crashing in event of a large table.
SteveL13Author Commented:
So then could I somehow make it an unbound control and just have it be populated with an afterupdate event of the combobox?  cboMech is the combobox.

Me.imageMechEmployeeSig.Picture = DLookup("[SignatureScan]", "tblEmployees", "[EmployeeID] = " & Me.cboMech)
Yes, but then you will get the same image for all the records.
SteveL13Author Commented:
I guess I don't understand why this is any different than any other afterupdate event of a combobox.
You don't need to use any code for this.  You just need to use a bound control.  The problem is you are using the wrong control for this.  You need to use the Attachment control.  The icon for this looks like a paperclip.  Once you add that control to your form, you just need to change the ControlSource to point to your attachment field.

Another way to do this is to click on Add Existing Fields and drag the whole attachment field group onto your form.

John TsioumprisSoftware & Systems EngineerCommented:
Let me understand something
you have a continuous form and you want when you change the value of the combobox to have a unbound picture control to show you a specific picture...
Can you share a screenshot to see if i am missing something
SteveL13Author Commented:
Attached is a snapshot of just the part of the continuous form I am concerned with.  When the user selects a record from the combobox, two things need to happen...

1) His/her employee number is to populate the upper right-hand corner text box.  This is already working perfectly.

2) Also, after selecting a record in the same combobox, the employee's signature is to appear in the lower "picture box".

The signature file exists in a table named tblEmployees in an attachment field named "SignatureScan".

Combobox Example
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
I made this sample for you. It gets the information into the continues form by the use of a left join to the primary table. (See the recordsource for the form).

As far as I can see it satisfies your requirement of having the signature in a attachment field, and being able to show it in a continuous form.

AND its a no.code solution.

EDIT: Included a screenshotExample
SteveL13Author Commented:
Anders, For some reason I cannot get my form to work like you did.  Please see the attached.  Select John Doe in the 1st combo box.  I do not know why the signature is not populated the signature field under the combo box.
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
Maybe its just because I am on my phone now, but the attachment reads as being 0 bytes?
SteveL13Author Commented:
I don't even know where you see the attachment size.  Sorry.  There is an attachment in the employee table.
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
I mean the attachment you added to your post here :)
Its empty.

Maybe try zipping the file first?
SteveL13Author Commented:
Anders,  New files attached including the signature file.  Please select "Alfred Moore" from the combo box.  His signature should then appear in the field below the combo box.  

Hope you can make this work.  I'm sure lost.
Anders Ebro (Microsoft MVP)Microsoft DeveloperCommented:
I've made some edits, and it works now.

Most notably, I removed the signature attachment field from the primary table. Unless you want to COPY the signature, the signature field should not be there. It is breaking the rules of normalization (Which can be ok, if you have the right reasons for it)

Try to look at the query, to see how the signatures make their way into the form.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SteveL13Author Commented:
Thank you very much.  Works perfectly.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.