TransferText


M

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

Advertisements

D

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

Advertisements

D

dpminusa via AccessMonster.com

Daryl said:
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.
 

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 3
TransferText 1
TransferText 1
TransferText 1
transfertext 1
TransferText Output 1
Using TransferText 1
TransferText(FileName) 3

Top