[AccessD] Scanning documents as attachment

I think you would want to first set up a folder for all the documents.  I
assume that they'd become pdfs?  And all scanned docs go into that folder.

Than, add a field to the Animal table for each document you want to store.
Make it a hyperlink format.

On the animal form, you will have a bound text box, locked but not disabled
so the click event will fire.  When you hover over it, the pointer will turn
into a finger because it's a hyperlink (and it won't be editable.  Next to
each text box a command button will pop up the file finder (I've got code in
the can for that - I still use the Littwin, Getz ADH code for that), and
having selected the document, that path and file name goes into the bound
text box and the table. And voila!  Documents can be popped up with a click
on the field. Just be sure that the pdf file type is associated with a pdf
reader that's loaded onto the target machine.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, September 25, 2014 8:07 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Scanning documents as attachment

The animal tracking database is moving along. It's slow going because it's
my lowest priority, but I get a little done most days.

Along with each new animal, there will be paperwork -- permits and vet exams
that are required by law. The manager would like to scan these and be able
to click a button to see them. I can teach her how to do this manually, but
it would be great if I could smooth the whole thing around the edges.

Have any of you coded this kind of functionality and if so -- what should I
keep in mind, watch for -- let's discuss please. :)

Thanks!
Susan H.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com