Set Mypath to the folder that the Database is in

[billHassall]

I will apologise for this request straight away, it should be straight forward, but I can't seem to find the right statement

When i am using VBA on Excel i use the following statement to open up a file that is in the same directory as the active file

MyPath = ActiveWorkbook.Path
Workbooks.Open Filename:=MyPath & "\CT Daily Info.xls"

What I can't find is what I need to replace "Active workbook" with for this to work in Access and if I could you something similar to output files by just filename into the same directory that the database is in.

Thanks

Bill

 

[John Big Booty]

Try;

MyPath = Application.CurrentProject.path

 

[JANR]

MyPath = CurrentProject.Path

JR

 

[billHassall]

Thanks very much,knew it would be simple, works a treat

Bill