Monthly Archives: July 2013

Using File System Objects in Microsoft Access

If you want to manipulate files and folders from within Access, here’s how you do it. First, open a module or create a new one. From the Tools menu, choose References… and the References window opens. Scroll down to the … Continue reading

Posted in Access 2007 problems/solutions | Leave a comment

Using a subtable for criteria to a main table report

Here’s the scenario: You have 2 related tables:  Projects and Machinery.  You wish to see a listing of projects where the location of the Machinery is in China.  Yet there are multiple machinery items in multiple locations for Projects, and … Continue reading

Posted in Uncategorized | Leave a comment