I use a For Each... Next loop like this:
For Each varFnm In Array("This", "That", "OtherThing ", "Foo", "Bar")
RunSql ("UPDATE.... bla bla bla)
Next
But the exact same elements of the Array are contained in a Table -- Is
there some way to use a query to set the Array, or some other way to avoid
using the Array?
Here's some pseudo code ...
For Each varFnm in qryStuff
RunSql("UPDATE. .. bla bla bla)
Next
Can someone suggest a correct way to do this?
Thanks in advance!
For Each varFnm In Array("This", "That", "OtherThing ", "Foo", "Bar")
RunSql ("UPDATE.... bla bla bla)
Next
But the exact same elements of the Array are contained in a Table -- Is
there some way to use a query to set the Array, or some other way to avoid
using the Array?
Here's some pseudo code ...
For Each varFnm in qryStuff
RunSql("UPDATE. .. bla bla bla)
Next
Can someone suggest a correct way to do this?
Thanks in advance!
Comment