File Name and Path

[Terry]

When in an Access Form I would like a field to default to
the name of the Access Database and the path.
The CurDir does not work because sometimes the file is
openned from Explore and the CurDir shows as
C:\..\MyDocuments. However if it is openned from the
program then CurDir works. However, then if it is
minimized and the user moves around in other programs and
comes back to it the default is wrong again.
Is there a command that gives you the Filename and path of
the open Access file?

I have the same problem in Excel I use
MyPath = CurDir & "\" & ActiveWorkbook.Name
but if the user goes to other programs and files and back
they get the wrong path.

Thanks for any help.

 

[Andi Mayer..]

When in an Access Form I would like a field to default to
the name of the Access Database and the path.
The CurDir does not work because sometimes the file is
openned from Explore and the CurDir shows as
C:\..\MyDocuments. However if it is openned from the
program then CurDir works. However, then if it is
minimized and the user moves around in other programs and
comes back to it the default is wrong again.
Is there a command that gives you the Filename and path of
the open Access file?

I have the same problem in Excel I use
MyPath = CurDir & "\" & ActiveWorkbook.Name
but if the user goes to other programs and files and back
they get the wrong path.

Thanks for any help.

currentdb.name
currentproject.path

 

[Mark]

If you're using Access 2000 or higher, you can use
CurrentProject.Path


...

 

[Terry]

Thanks to all for the quick answer. So helpful..>

currentdb.name
currentproject.path

word "manfred" to the first 10 lines in the message

 

[Terry]

Thanks to All for the quick answer. So helpful. So
appreciated.