Importing function

[Guest]

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]

You can use something like:

SELECT CASE YourVariable

 

[Van T. Dinh]

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)