Know where current MDB file is

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

In Excel VBA, there is this command
ActiveWorkbook.Path
which can tell you the Path of where the active xls file that you working in
is.

Is there a similar command in Access VBA that can give you where the current
MDB file you are working with is in ? so you can know during runtime.

Thank you,
Jeff
 
Jeff said:
In Excel VBA, there is this command
ActiveWorkbook.Path
which can tell you the Path of where the active xls file that you working in
is.

Is there a similar command in Access VBA that can give you where the current
MDB file you are working with is in ? so you can know during runtime.
Click to expand...


Depending on whether you want the file name part of the
path:
CurrentDb.Name
or not:
CurrentProject.Path
 
Back
Top