TransferText

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I would like to prompt the user to enter in the file name
and location when the TransferText command runs. How do I
do this. The "File Name" control on this command requires
a full name and path. I want the user to be able to get a
dialog that would allow them to select the folder and name
the file. Is this possible in a macro or is this a VB
thing.

Thanks.
Todd
 
Todd,

It is possible with a macro if you have an unbound textbox on a form,
where the user will type the full path and filename. If you want
something like the Windows file open dialog, or Explorer type
interface, for the user to browse and select, then you will need to
use VBA routines.

- Steve Schapel, Microsoft Access MVP
 
Steve Schapel said:
Todd,

It is possible with a macro if you have an unbound textbox on a form,
where the user will type the full path and filename. < snip >
- Steve Schapel, Microsoft Access MVP
Click to expand...
Or you can use an InputBox function to let the user type the string in as a
prompted entry without using a form. You also can have the InputBox display
a "default" string to minimize the typing needed by the user.
 
Back
Top