Quickly grab the app source folder to use as a starting point for
search and save tasks (2000/2002/2003)
If your application is searching for a file or needs to create a new
file, the most logical search/storage location is the directory where
the user opened the current database. To determine the name of this
folder, you can use the Path property of the
Application.CurrentProject object. The following code snippet uses
this property to attach the database's current location to the file
name myFile.txt:
Application.CurrentProject.Path & ("\") & "myFile.txt"