?
Solved

How get a scanned image on a report

Posted on 2016-10-04
4
Medium Priority
?
33 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 2000 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

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…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

771 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