Path for linked pictures

[bwyrwitzke]

Here's another dumb question...

Is it possible to specify a path to my linked pictures without listing the entire path? The pictures are in a folder one step below the database folder. I'd hate to have a user move the location of the database files and lose all the links. Thanks.

Bruce

 

[boblarson]

For Access 2000, you can get the path by using:
CurrentProject.Path

So you could do something like:

Dim strPath as String

strPath = CurrentProject.Path & "\Photos\"


etc.

Hope that helps!

 

[bwyrwitzke]

Thanks Bob! It worked like a charm.

Bruce