=FIND("text","this is the text to search",1) / DoCmd.TransferText

[Guest]

sorry, this is probably really basic, but I left my vba book at home and couldn't find it in the help menu

all i want to know is how to check a variable which holds a string and see whether it holds 'text' or not... ie., something like this in excel
=FIND("text","this is the text to search",1

Actually.. try that one, or expand
I have the following script

DoCmd.TransferText acImportDelim, mySpec, myTable, myFile, True, "

which works and imports a text file.. but i can also import 'myFile' if the headings do not match that of 'myTable'. I just wanted to add a check on the file name to see it was the right file. But it could be to insist that the above command works only when headings match would be even better?

thanks for your ideas
Marcus

 

[Guest]

This was a simple one

No ideas

Any one?

 

[John Vinson]

all i want to know is how to check a variable which holds a string and see whether it holds 'text' or not... ie., something like this in excel:
=FIND("text","this is the text to search",1)

The analogous function in Access is InStr:

If InStr("text", "this is the text to search") > 0 Then
<the text was found>
Else
<it wasn't>
End If