TransferText

[Rod]

I need to create a text file based upon a query and am using the following
command:

Dim stDocName As String
DoCmd.TransferText acExportDelim, , StDocName, "c:/directory/filename", -1

However, I would like to be able to define [FileName]
("c:/directory/filename") based upon an object on a form. Is this possible?
What is the correct syntax?

Thanks... Rod

 

[Arvin Meyer [MVP]]

Try somethink like:

Dim stDocName As String
Dim strFile As String

strFile = Me.txtMyTextBox & ".txt"

DoCmd.TransferText acExportDelim, , stDocName, "c:/directory/" &
strFile, -1
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Rod]

It worked! Thanks for the quick response.

Try somethink like:

Dim stDocName As String
Dim strFile As String

strFile = Me.txtMyTextBox & ".txt"

DoCmd.TransferText acExportDelim, , stDocName, "c:/directory/" &
strFile, -1
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

I need to create a text file based upon a query and am using the following
command:

Dim stDocName As String
DoCmd.TransferText acExportDelim, , StDocName, "c:/directory/filename", -1

However, I would like to be able to define [FileName]
("c:/directory/filename") based upon an object on a form. Is this possible?
What is the correct syntax?

Thanks... Rod