scanning into access

Posted on 2012-04-10
Medium Priority
Last Modified: 2012-05-15
hello, i belong to a club where we collect dues each year. we receive a check as payment, with different amounts, i would like to use a scanner to scan a copy of the check sent by each member, i have a form for each member where i enter their info and payment information. at that time i would like to scan the check. not sure if this is an image or a pdf. i would like to see the image of the check on the form where i enter the info for each member. thanks in advance, Charly
Question by:cazink
1 Comment
LVL 28

Accepted Solution

burrcm earned 1500 total points
ID: 37832150
You can add an OLE Object field to your table and then to your form. Then right click the field on the form and "Insert Object" then "Bitmap Image". This action will open Paint where you can create a scanned image for insertion. This method however will lead to significant bloat of your database and may over time become unworkable. Might be better to link the images to the member data on the form, that is create a folder of the cheques named with the member number. Place a button on the form to open the stored picture as required. The code behind the button will read like this -

MyfileShell = Chr$(34) & "C:\Windows\system32\mspaint.exe " & Chr$(34) & " " & Chr$(34) & "C:\YourFolder\" & [YourFormField] & ".jpg" & Chr$(34)
    Call Shell(MyfileShell, 1)

Fairly self explanatory. Set the extension to suit - jpg or bmp. You can actually use a *, but this might lead to complications. When you open the first one Paint will come up full screen but if you reduce it to the picture size, it should remember for next time.

Chris B

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

624 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