Solved

How get a scanned image on a report

Posted on 2016-10-04
4
24 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

730 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