TransferText

[Mike B]

I am trying to create a TransferText command in a macro but keep getting an
error message that says " the text you entered isn't an item in the list. I
have seen this in another database and can't fiqure out how to get it to
work. any help would be appreciated.

 

[Daryl S]

Mike -

Chances are you have a typo or incomplete information in one of the fields.
Please show what you have entered for each of the items so we can help...

 

[dpminusa via AccessMonster.com]

Mike -

Chances are you have a typo or incomplete information in one of the fields.
Please show what you have entered for each of the items so we can help...

The documentation says:

expression.TransferText(TransferType, SpecificationName, TableName, FileName,
HasFieldNames, HTMLTableName, CodePage)

Example

The following example exports the data from the Microsoft Access table
External Report to the delimited text file April.doc by using the
specification Standard Output:

DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc"

If you make this into a Function you can use a RunCode in your Macro and
refer to it by the Function name. Perhaps:

Function TT() As Boolean
DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc"
End Function

Macro:

RunCode TT()

Is this the track you are on?

One error I see sometimes is forgetting the parenthesis after the Function
Name in a Macro.

Hope it helps.