Marios:
CurrentDB.Name returns the full path and filename of the currently open MDB, and
to parse out just the path (it's all on one line):
Left$(CurrentDB.Name, Len(CurrentDB.Name) - Len(Dir$(CurrentDB.Name)))
--
Bruce M. Thompson, Microsoft Access MVP
Quote:
>>No Email, Please. Keep all communications
within the newsgroups so that all might benefit.<<
Quote:
> Hello guys !!
> Does anybody knows whether there is an equivalent in VBA of App.path
> which is in Visual Basic? ..or if there is something equivalent.
> I need to know the current path of my VBA application.
> Thank you
> Marios