This is a very nice little menu system I developed for storing file locations and filenames in a table and then opening those files. It shows how you can populate a table with the file location and file name using the Dir() function with ANY file types and it also shows 3 different ways on how to open a stored filename (of any type) in a table. This program/utility has many, many features including:

1. Quickly search any drive/directory, find files of ANY specified type (ex: mdb, dll, exe, doc, xls, xlw, bmp, etc...etc....), and STORE those file locations in a table for quick access via the menu.
2. FSO file searching ability to find files of ANY type (You do NOT need the Office Object Library 10 or any other additional references in this mdb example).
3. "keyword" searches for filenames and quickly find any filepath/name with the wording "shortcut" or any wording you specify.
4. Code to open stored files of any types (3 different methods of opening files - if the first method fails, it automatically executes the 2nd method (which utilizes the windows file association). If that fails, it will prompt you for the program name to open the file.)
5. 2 listboxes on the main form, 1 to select files newer than the date you specifiy and the other to list files older than the date you specify.
6. Quick tabs for listing MSAccess, Word, Excel, and Picture files.
7. JetUsersLog incorporated into it to find any users in any specified mdb file.
8. Sort file listing by Date, foldername, or filename.
9. Tracks users and which files they open at what time.
10. Plus many, many more features - a great utility regardless if you're an MSAccess user or not.

There is also code in this utility to create a desktop shortcut to the users desktop for a selected file.

And lastly, there is code (in the main form's onLoad event) which will remove all of MSAccess menu's and only show the form (ie. see module2).

Hold down the shift key while opening to see the code behind the form.

Also has the resize module in it for resizing forms.
Also has the FormInfo module for removing caption bars or manipulating forms.

NEW VERSION - Just uploaded on 9/10/07!

New version uploaded 3/1/08! (MenuSystemInAccessByEDP2008 - trimmed out excess code).