Any Access experts out there?
I have lately been using it quite a bit for work. We are actually putting all our data into a central area (the database) rather than keeping it scattered over everyone’s hard drives in Word and Excel files as it had been. All good.
However, because there are so many old files, I have just linked them to their project numbers in the database rather than cutting and pasting the many files that are out there. Any new projects get written up in the database itself.
Now, the problem. When generating a report (for example, all projects expected to be done in the next quarter), I would like the project data in these linked documents to be included in the report. Is there a way to automatically open linked Word or Excel files and include them when generating a report? Note: I don’t want a listing of the links, I want the actual document or spreadsheet included w/o having to reenter it all.
My kingdom (what little there is) to the Doper who solves this!