Import txt file from same folder as Database (1 Viewer)

ECEK · Oct 19, 2017

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 · Oct 19, 2017

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 · Oct 19, 2017

Found it !!!!

Code:

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

ECEK · Oct 19, 2017

How do I thank myself !!!!

Mark_ · Oct 19, 2017

ECEK said:
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 · Oct 19, 2017

ECEK said:
How do I thank myself !!!!

I've done it for you!

Import txt file from same folder as Database (1 Viewer)

ECEK

Registered User.

CJ_London

Super Moderator

ECEK

Registered User.

ECEK

Registered User.

Mark_

Longboard on the internet

Uncle Gizmo

Nifty Access Guy

Similar threads

Users who are viewing this thread