TransferText

[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

 

[Steve Schapel]

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

 

[Ken Snell]

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

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.

 

[Steve Schapel]

Good point, Ken!

- Steve Schapel, Microsoft Access MVP