Importing function

Guest · Oct 22, 2003

Hi,

In the "Docmd.Transfertext" command, can you set
the "TransferText" as a variable?
If so how would you insert the variable, I have tried but
the command keeps coming up incorrect

DoCmd. & import_format &

Regards
Ian

Guest · Oct 23, 2003

You can use something like:

SELECT CASE YourVariable

Van T. Dinh · Oct 23, 2003

You can use SELECT CASE statement like:

SELECT CASE import_format
CASE "TransferText"
DoCmd.TransferText ...
CASE "Soome other thing"
DoCmd. ...
CASE ELSE
...
END SELECT

HTH
Van T. Dinh
MVP (Access)

Importing function

Guest

Guest

Van T. Dinh