Unexpected Results from Curdir?

[bginhb]

My application is being launched from:

C:\Users\Bill\Dropbox\DesktopLaptop\MDalia

but when I use a Curdir or Curdir$ function in a Private Sub embedded in a button click event and stopped by a breakpoint after the Curdir function has been run and executed - the VBA Immediate window shows:



?curdir$
C:\Users\Bill\Documents

Do I need to do something special to set the current directory equal to the accdb launch directory?

[RuralGuy]

You would need to do a ChDir but why bother? Is it causing you problems?

[bginhb]

Yes, it is.

When I distribute the DB I wanted to allow the Users to install it anywhere. That in itself is not a problem as the DB is completely self contained but I have also needed to provide 2 PDFs as help files and thought the best way was to instruct the Users to save them in the same directory as the accdb.

So if I am unable to determine the directory of the DB I have to have them save them in a common location and that appears to be My Documents as that seems to be the default current directory default location regardless of OS.

Not ideal, in my opinion!

[ssanfu]

So if I am unable to determine the directory of the DB ...<snip>

Curdir (or Curdir$) is a DOS environmental variable. To get the directory the dB is in, use "CurrentProject.Path"

Dim MyPath as string
MyPath = CurrentProject.Path
Msgbox MyPath

[RuralGuy]

That's why Access has CurrentProject.Path.

[bginhb]

Thank you all for your assistance!
That resolves my problem ... I will designate the thread "solved".

[RuralGuy]

Glad we could help.