problem

[Neo]

Hi

I have a form which lists employees. Each employee record has a link to a folder on my computer that contains a picture of the employee.
I use a picture frame to = the field that contains the link
eg C:/Mydocuments/Mypictures/Emplyees....

The problem is that this folder is not stored in the same place on the different computers , is there a way for the form to find the folder with out put in the whole address

Thanks

 

[Only1Abhi]

don't worry.
this shouldn't be a problem.
The picture u put in your form is automatically embedded to the form.

So it should be there in any computer.

IF U're STILL having problems, then try to put the original picture in the same directory (folder) as the access DB. And whereever u take the DB, take the pic with u.

That should DEFIENTLY solve the problem.

Regards,
Abhi

 

[The_Doc_Man]

I don't know if this even CAN work for you, but the method I use to find things is that I put the DB in a directory. Any directory. Any files that are to be associated with it go into a subdirectory of that directory. So if my DB is in ... /DB/ then my pictures might be in ... /DB/PICS/

You can find where you are using CurrentDB.Name to get the fully qualified name with device, path, name, and type. Using the mid function, search backwards to find the rightmost "/" character. Everything to the left of that (including the slash) is your base folder. All else can be subdirectories thereof with simple string concatenation.

Now, if that doesn't work, you might have to do some things with the Application.FileSearch object. The Help Files will tell you how to use it. That and the DIR function (also in the Help Files) will tell you how to search a directory for a given file. Of course, it would be up to you to do the recursive search that you need.