Hi,

   I have seen this before, I just can't find the controls or code.

   I need to add a file explorer or browser (expandable list) to a form so that users can select a file to associate with a record (image files that will be displayed in a form, and then in a report.) I know this can be done even with a filter so that only .jpg files show up in the list. I would also like to filter the list so that the file names (which start with a valid SSN) will be filtered for the current employee's SSN, and also have a default folder.

   (These are scans of employee records in .jpg format, and I need the user to be able to assocaite and view images of the docs in reocrds, and I want them to only see scans available for the employee on whose record they are at the moment.)

Thanks.


mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Well, here is what I had to do since I couldn't use the ocx that covers this, and I couldn't find an API:

I have a folder with files that use the patient's ssn as the beginning of the file name.

I created a button on the form that takes the patient's ssn, then loops through the folder where the scanned docs are and pulls only those that start with the patient's ssn.

Then it pushes this data to a temporary table, and opens a continuous form that lists all the files. On the continuous form there is a button next to each record that says Attach this file.

If you click that button, the form closes, the file name and path are pushed to the proper field in the database, and the temporary table is cleared out.

So it is not only an OpenFileDialog box, but it is prefiltered for files pertaining to the patient whose record is being worked on.

It doesn't look to fancy yet, but it will tomorrow.

Thanks for looking in. I hope this helps someone else.


mmcdonal