Donna Tunstall
Registered User.
- Local time
- Today, 02:05
- Joined
- Aug 16, 2001
- Messages
- 17
Greetings : I'm a first time user of this board. Long time user of Access trying to improve my applications by grappling with VBA.
I have a report which needs to be distributed to about 50 sales reps on a monthly basis - BUT I want each rep to only see their own data. Currently I have it set up so I have 50 queries, each of which has a rep's name as the criteria and my macro runs each query and dumps it into a temp table, then exports the report, then runs the next query, etc, etc.
I'm thinking that there must be a way in VBA to set up the export function for the report, but which reads all the sales reps from a list (i.e. does a loop through a list and exports the report as JoeBloggs.snp, FredSmith.snp, etc and when it gets to the end of the list it stops).
If anyone could help me with where on earth to start with this sort of thing I would be eternally grateful. Thanks in advance.
I have a report which needs to be distributed to about 50 sales reps on a monthly basis - BUT I want each rep to only see their own data. Currently I have it set up so I have 50 queries, each of which has a rep's name as the criteria and my macro runs each query and dumps it into a temp table, then exports the report, then runs the next query, etc, etc.
I'm thinking that there must be a way in VBA to set up the export function for the report, but which reads all the sales reps from a list (i.e. does a loop through a list and exports the report as JoeBloggs.snp, FredSmith.snp, etc and when it gets to the end of the list it stops).
If anyone could help me with where on earth to start with this sort of thing I would be eternally grateful. Thanks in advance.
