Import txt file from same folder as Database

[ECEK]

Is it possible to write VBA that will import a file into the database that is in the same folder that the database is in regardless of the address of the folder?


Or import the name of the folder itself?

 

[CJ_London]

is the database split?

for the front end you can use currentdb.name to give the full path - remove the name to give you the path.

if the backend, inspect the tabledefs for a link table to find the path to the backend - think it is currentdb.tabledefs("nameofalinkedtable").connect

 

[ECEK]

Found it !!!!

Private Sub Form_Open(Cancel As Integer)
Me.Text2 = Application.CurrentProject.Path
End Sub

 

[ECEK]

How do I thank myself !!!!

 

[Mark_]

How do I thank myself !!!!

By renaming

Me.Text2

to something you will remember next week when you are wondering why your code that references asCurrentPath doesn't work?

 

[Uncle Gizmo]

How do I thank myself !!!!

I've done it for you!