S
sgbotsford
Office XP Pro with SP3 applied.
Database 'ControlData' has a field labeled 'Zone'
Query ZoneQuerry extracts data from ControlData and selects fields for
use in another program, OziExplorer.
I would like to maintain a macro that would run ZoneQuery for each
possible value of Zone, and produce Zone-A.txt, Zone-B.txt ...
I'm not a VBA programmer.
I tried this in a macro:
OpenQuery ZoneQuery
ApplyFilter ZoneQuery Zone="A"
TransferText ZoneQuery Export-Delimited, ...
ApplyFilter ZoneQuery Zone='B'
....
The query part works. I can get a 1 second view of each appropriate
data chunk.
But transfertext doesn't seem to pay attention to the previously
applied filter, but
runs the query separately, so that I end up with the entire contents
duplicated in each
text file.
Is there a way to get transfer text to work with the currently opened
database with currently applied filter?
Database 'ControlData' has a field labeled 'Zone'
Query ZoneQuerry extracts data from ControlData and selects fields for
use in another program, OziExplorer.
I would like to maintain a macro that would run ZoneQuery for each
possible value of Zone, and produce Zone-A.txt, Zone-B.txt ...
I'm not a VBA programmer.
I tried this in a macro:
OpenQuery ZoneQuery
ApplyFilter ZoneQuery Zone="A"
TransferText ZoneQuery Export-Delimited, ...
ApplyFilter ZoneQuery Zone='B'
....
The query part works. I can get a 1 second view of each appropriate
data chunk.
But transfertext doesn't seem to pay attention to the previously
applied filter, but
runs the query separately, so that I end up with the entire contents
duplicated in each
text file.
Is there a way to get transfer text to work with the currently opened
database with currently applied filter?