Recent content by cjwilkinson

Can somebody tell me whether it is possible to build a macro that could export all data from a query in access to an excel file where every different value (e.g. productgroup) in a certain filed is stored in a different sheet. Let's says you have 10 productgroups, you would end up with 10 sheets...

Hi guys, I am trying to build a search form based on a form (frmProductSearch) and a subform (frmSubProductSearch). frmProductSearch: has about 5 unbound combo boxes all cascaded to one another and should control the subform (e.g.: cmbProductBrand, cmbProductFamily, cmbProductGroup...