Maxi2011
Registered User.
- Local time
- Today, 04:48
- Joined
- Aug 6, 2004
- Messages
- 16
I have a table of categories (Tbl Categories) and a table of Suppliers who fall within each category (TblSuppliers) which I need to be able to run mail merges from. I need to give the user the ability to
• Send letters to all suppliers within a category
• Send letters to several categories
• Select which suppliers (from one or several categories) they want to send letters to
The problem is I have over 100 categories with over 1100 contacts within them (these figures cannot be reduced – they are set by the company) so I am struggling to find a way to offer these options to the user without using an insane number of controls on a form…..
I hope someone can tell me otherwise, but I think my options are limited to either an awful lot of checkboxes or a multi-select listbox again with an awful lot of options. I don’t think either of these are anywhere near ideal. Is there a better way to do this?
Even if one of these is my only option, I’m unsure of how I can deal with the user requesting multiple options. For example, if the user checks a box for ‘Category A’ and ‘Category B’ do I need to have a query for this already in place? If so this means I would need to have a query to account for EVERY combination of choices (100s of queries I’m sure!) I know there is probably a way I can use VBA to make an ad-hoc query but I can’t seem to find anything on the web or in my reference books which tells me how to go about this. I’m sure if I knew more specifically what I was looking for this wouldn’t be an issue but I’d be glad if someone could point me in the right direction.
Thanks in advance!
Maxi2011
• Send letters to all suppliers within a category
• Send letters to several categories
• Select which suppliers (from one or several categories) they want to send letters to
The problem is I have over 100 categories with over 1100 contacts within them (these figures cannot be reduced – they are set by the company) so I am struggling to find a way to offer these options to the user without using an insane number of controls on a form…..
I hope someone can tell me otherwise, but I think my options are limited to either an awful lot of checkboxes or a multi-select listbox again with an awful lot of options. I don’t think either of these are anywhere near ideal. Is there a better way to do this?
Even if one of these is my only option, I’m unsure of how I can deal with the user requesting multiple options. For example, if the user checks a box for ‘Category A’ and ‘Category B’ do I need to have a query for this already in place? If so this means I would need to have a query to account for EVERY combination of choices (100s of queries I’m sure!) I know there is probably a way I can use VBA to make an ad-hoc query but I can’t seem to find anything on the web or in my reference books which tells me how to go about this. I’m sure if I knew more specifically what I was looking for this wouldn’t be an issue but I’d be glad if someone could point me in the right direction.
Thanks in advance!
Maxi2011
