current dir

[HansD]

please help me

I have a directory called photo in the directory with my database.
what is the code in Visual basic for : "current dir"\photo

the problem is I want to make a directory with my database and in there a directory with pictures. It want to be able to place the directory where i want without changing the code.

Thanx

 

[dalchri]

There's two ways that I know of:

1) App.Path. In VB6 this is the same directory as the EXE file. I'm not sure what the behavior is in VBA from within Access.

2) Ironically, a function called CurrentDir(). This function is a little unpredictable though. Its results can be changed by whatever the last common dialog path was or by other browse operations from within a program.