Contrasting to Access 2007, in which you need to install add-ins to export database. Access 2010 offers option of exporting database in PDF (Portable Docum. The following have been specifically mentioned as being able to be automated. PDFCreator Free, open source. More info on using it in VBA code, including combining. I have a very simple database in access, but for each record i need to attach a scanned in document (probably pdf). What is the best way to do this, the database.

QUESTION ——— Using VBA, how do I export a report to PDF in Microsoft Access? This topic explains how to export text files by using the Export Wizard in Microsoft Office Access 2007. This topic also explains how to save the export details as a.

How to show . Thought not explictly stated, the apparent purpose is to get a selected file name, whereas other answers return either counts or lists. I would add, however, that the msofiledialogfilepicker might be a better option in this case. I used its value outside the loop with equal success. It's probably better practice to do it as John M did, however. Also, the folder picker can be used to get a selected folder. Can T Open Java Control Panel Windows Xp.

I always prefer late binding, but I think the object is native to the default access library, so it may not be necessary here.

That said, I wouldn't personally rule it out, though if you are going to take that option, I'd strongly suggest splitting out the file data into its own table in its own backend file. For example: Create a new database file called Scanned files.

Scanned files. accdb). Add a single table called Scans with fields such as File. ID (Auto. Number, primary key), Main. Table. ID (matches whatever is the primary key of the main table in the main database file), File.

Name (Text), File. Ext (Text) and File. Data ('OLE object', really just a BLOB - don't actually use OLE Objects because they will bloat the database horribly). Back in the frontend, add a reference to Scans as a linked table. Use a bit of VBA to upload and extract files from the Scans table (if you're interested in the mechanics of this, post a separate question). Use the VBA Shell routine (if you must) or Shell.

Execute from the Windows API (= the better option IMO) to open extracted data. If you are using the newer ACCDB format, then you have the 'attachment' field type available as smk.

This basically does most of the above steps for you, however doing things 'by hand' gives you greater flexibilty - for example, it allows giving each file a 'Date. Scanned' or 'Date. Effective' field. That said, your requirement for thumbnails will require explicit coding whatever option you take. It might be possible to leverage the Windows file previewing API, though I'd be certain thumbnails are a definite requirement before investigating this - Access VBA is powerful enough to encourage attempts at complex solutions, but frequently not clean and modern enough to allow fulfilling them in a particularly maintainable fashion.