Docmd.transfertext cmd with a variable?

  • Thread starter Thread starter Steve in MN
  • Start date Start date
S

Steve in MN

I would like to know how or if it is possible to use a form field in a
transfer text statement so that the user can direct the program where to look
to get the file.

Can someone give me an example of how this would work. Assuming i would
have a table with one text field and that would be the mapping of the file to
be imported. Then have that field show up on my import form.

Here is the code for my current import process:
DoCmd.TransferText acImportFixed, "Schedule Import Specification Test",
"Schedule", "Q:\HR\LQD\Schedule.txt", False, ""

I would like to have the "Q:\HR\LQD\Schedule.txt" as the variable that can
be changed out side of the code. is this done with a Me![Fieldname] or is it
more complicated?
 
Here is the code for my current import process:
DoCmd.TransferText acImportFixed, "Schedule Import Specification Test",
"Schedule", "Q:\HR\LQD\Schedule.txt", False, ""

I would like to have the "Q:\HR\LQD\Schedule.txt" as the variable that can
be changed out side of the code.  is this done with a Me![Fieldname] oris it
more complicated?
Click to expand...

dim strFile As String

'get the filename from the table (assuming there's only one file
there... )
strFile = DLookup("[FileNameToImport]", "ztblFileList")

'do the transfer
DoCmd.TransferText acImportFixed, "Schedule Import Specification
Test",
"Schedule", strFile, False, ""
 
Thanks,
I'll give that a try.

[email protected] said:
Here is the code for my current import process:
DoCmd.TransferText acImportFixed, "Schedule Import Specification Test",
"Schedule", "Q:\HR\LQD\Schedule.txt", False, ""

I would like to have the "Q:\HR\LQD\Schedule.txt" as the variable that can
be changed out side of the code. is this done with a Me![Fieldname] or is it
more complicated?
Click to expand...

dim strFile As String

'get the filename from the table (assuming there's only one file
there... )
strFile = DLookup("[FileNameToImport]", "ztblFileList")

'do the transfer
DoCmd.TransferText acImportFixed, "Schedule Import Specification
Test",
"Schedule", strFile, False, ""
Click to expand...
 
Back
Top