TransferText


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
 
Ad

Advertisements

S

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
 
K

Ken Snell

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
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.
 
Ad

Advertisements

S

Steve Schapel

Good point, Ken! :)

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferText 1
TransferText 1
TransferText 2
TransferText 1
transfertext 1
TransferText Output 1
Using TransferText 1
TransferText(FileName) 3

Top