Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How get a scanned image on a report

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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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 …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

636 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