Search Form - to search for files on pc

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

Hi there

I wonder if this is possible. I have a database in which I save reports as
snapshots into a file on my pc.
(I use the "output to" option)

Now I would like to enquire whether it is possible to somehow search for
these "saved reports" via access? for eg. A "search" form with a text box
to enter the name of a file I am looking for (on my pc itself), and then it
needs to display the results of the search in access, with an option to open
the chosen report from a button on the form.

Thank you

Melissa
 
See:
List files recursively
at:
http://allenbrowne.com/ser-59.html

The code lists the files of a certain type (optionally) in a folder and
subfolders (optionally), and can fill a list box with the results so the
user can select one.

You will need some experience with VBA code to achieve this.
 
Back
Top