Search Form - to search for files on pc

[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

 

[Allen Browne]

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.