Macro-Transfertext-Filename using input from form

[Rickm]

I would like to use a Macro/Transfertext to import a csv file. It has a tree
associated with it: c:\Data\filename.csv I would like to substitute
filename with a textbox parameter from a form. Is there a special format
I must use or is there another way I must go? Thanks for the help!

 

[Brian]

Use this instead of the path & filename: [Forms]![NameOfForm]![NameOfTextBox]

This assumes that the form is open and that the control on the form contains
the entire path & file name.

 

[Rickm]

Brian,
This would make the user enter the complete tree name and file suffix every
time. Through some pain I came up with a format that works. In the Macro
where I select Transfertext as the action, I use the following arguments:
"c:\Data\" & [FORMS]![Formname]![TextboxName] & ".csv"
This allows the user to only type the filename and not worry about the tree
path (which is longer than I show above). They don't even have to put the
..csv on the end. I appreciate the option but I did manage to hit this one.
Perhaps you or someone else could benefit from this. Thanks again for the
reply!

Use this instead of the path & filename: [Forms]![NameOfForm]![NameOfTextBox]

This assumes that the form is open and that the control on the form contains
the entire path & file name.

I would like to use a Macro/Transfertext to import a csv file. It has a tree
associated with it: c:\Data\filename.csv I would like to substitute
filename with a textbox parameter from a form. Is there a special format
I must use or is there another way I must go? Thanks for the help!

 

[Rickm]

Brian,
Actually, the Arguments in the other reply go in the Filename area of the
Argument listing just for clarification.

Use this instead of the path & filename: [Forms]![NameOfForm]![NameOfTextBox]

This assumes that the form is open and that the control on the form contains
the entire path & file name.

I would like to use a Macro/Transfertext to import a csv file. It has a tree
associated with it: c:\Data\filename.csv I would like to substitute
filename with a textbox parameter from a form. Is there a special format
I must use or is there another way I must go? Thanks for the help!