I need to change the criteria from VB on a cross-tab query created in Access. I have already created the cross-tab query.
Based on what the user selects on my form, I want to change the criteria from VB, open the query, and export the results to Excel. Its no problem to export but I cannot figure out how to change the criteria.
If it wasn't a cross-tab query then I would just write the sql myself and create a querydef object and export from there - however the cross-tab part makes this a little more complex.
Based on what the user selects on my form, I want to change the criteria from VB, open the query, and export the results to Excel. Its no problem to export but I cannot figure out how to change the criteria.
If it wasn't a cross-tab query then I would just write the sql myself and create a querydef object and export from there - however the cross-tab part makes this a little more complex.