Images

Access Imaging Seminar

Access Open Programs Seminar

Developer 30+

Hi Alex

Thanks for replay but my asking is for PDF files not images And do i need to watch Dev30 for this regard??

PDF files are images

Let me make sure I understand what you're doing... you have 900 PDF files all scanned in a folder. You want to associate those with records in your database by storing the filename of the PDF file with a patient's record so you can easily click to open the right one. Correct? If that's the case HOW are you distinguishing the PDF files? Is it just the patient's name in the filename of the PDF? If that's the case, are they all unique? It would be possible to write some VBA to loop through the files in that folder and try to figure out which patient each file belongs to based on the filename, but the names would have to be EXACT. This is also going to involve you knowing how to program VBA and know how to loop a DIR statement, and then use an SQL statement or Recordset to store the filename. Lots of stuff here. Is it possible? Sure. You're definitely going to need a lot of various Developer lessons to get there though. If you want to try to find someone to build this for you, check out the Developer Network.

I say ABCD purchase it and use it or do the classes and modify it to meet your needs.  and Alex is correct
Images will talk about file picker

Yeah, but the ABCD doesn't match up people based on filenames. If you want to match up the documents manually, sure. I guess I could build an add on to attach the documents based on something in the filename... But that's something I'd have to put on the back burner right now. Too many kettles on the stove atm.

Im just saying for me the ABCD is the best thing I use it for manything I even added the product catalog for my projects.  Love this like a fat kid love cake.  I know i have a few pounds on me from cake.....

Mmm.... Cake

Hi All,

I know that there is serval way but I'm looking for full Automation as much as we can for this topic