App.Path not working

[lasitha]

Hi All,

Is it possible to application path through vba code.
App.Path

Lasitha.

 

[KenReay]

Hi

Try

? application.CurrentDb.Name
S:\NCSC\Headquarters\ICT\Team\KenReay\CurrentRelease\ComplaintsFE.mdb


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[lasitha]

Dear KenReay,

ThankX a Lot, It's worked..

x = Replace(Application.CurrentDb.Name,"ComplaintsFE.mdb","")

Thanks again...
Lasitha

 

[PHV]

Another way :
Application.CodeProject.Path
Application.CurrentProject.Path

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[lasitha]

Hi PHV (MIS)

ThankX a Lot...

Lasitha.