LOOKING AT THE FILESEARCH OBJECT

A useful addition to the Microsoft Office objects is FileSearch. This object can be used via code to search for files in your system using the same options as found on the Find dialog off the Tools menu, located on the File Open dialog (see Figure 20.24).

Figure 20.24. Developers can now locate multiple files by using VBA and the FileSearch object, and have the same options as this dialog.

Where this would be useful is in applications where you need to track documents for users outside Access. Although most of the time users can locate the file on their own, sometimes they just want to type the name and have your ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.