If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Set Import Location in Table

Hello,
I am setting up a database to share with dozens of users, and therefore it needs to be versatile. It imports multiple text files with set filenames, but I would like the other administrators to be able to change the import location in a table, and then use that location (e.g. C:\Temp\) in the code for all the files? Currently everything is set up in a macro, but I'm switching over to code, but this has me stumped.

In the example below, I would want the folder location to pull from a text field in a table, but the filename would be set.