Solved

How get a scanned image on a report

Posted on 2016-10-04
4
22 Views
Last Modified: 2016-10-04
First of all I have a table named tblSignatures.  The table has two fields...  Initials (short text field), and Signature (attachment field).

On a report I want to populate or make a scanned image appear of the signature scan in tblSignatures.  I have tried this as a control source for the image field but it doesn't work.:

=DLookUp("[Signature]","tblSignatures","[Initials] = '" & [Reports]![rptPurchaseOrder]![txtUserInitials] & "'")

Recommendations?
0
Comment
Question by:SteveL13
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 41828391
is your report linked to the table? (recordsource)
and do you have an image field on the report linked (control source) to the Signature in the recordsource?
if so, the image would be populated automatically.
0
 

Author Comment

by:SteveL13
ID: 41828484
The report's recordsource is tblPurchaseOrder so no, it is not linked to tblSignatures.  But tblPurchaseOrder does contain the Initials field.
0
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 500 total points
ID: 41828515
maybe your recordsource should be a QUERY joining two tables on initials, and returning the signature field so you can use it as the control source for the image control.
0
 

Author Closing Comment

by:SteveL13
ID: 41828533
Brilliant. Thank you very much. That did it.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question