var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Retreiving CurentDB Location
Hopefully this'll just be a quicky but I simply can't find a quick and easy method.
How can I return the file path for the database that is open? I'm assuming there is an inbuilt function that I am missing, but I cannot find it!
Quick and easy enough for ya?
Originally Posted by georgev
ur codings are working excelent.
Nice and swift post edit Poots :P
I actually just discovered this also:
which appears to work...
So here's the second part:
I want to return the folder which the database is in - but CurDir is not giving me the correct location *sigh*
C:\Documents and Settings\******\My Documents\Access\db1.mdb
C:\Documents and Settings\******\My Documents
Ahh screw it - I worked out a dirty little solution as soon as I posted
But surely there's a cuter way (inbuilt)?
FilePath = Left(CurrentDb.Name, (len(CurrentDb.Name) - len(Dir(CurrentDb.Name))))
EDIT: Why George, yes there is!
Last edited by gvee; 05-14-07 at 09:59.