Hiya, this is pretty much Excel related.
I offered to use MS Access for what i'm doing but everyone prefers Excel.. here goes...
I have a query to the Sage SQL server. It brings back all open invoices. 62,000 lines and growing. Is there a way i could manipulate MS Query with VBA?
If so.. this is what i need:
I would like to change the filters on the query.
strCustomer would be the tables 'Customer' field.
strOP would be the tables 'open_indicator' field.
I've never manipulated any queries in VBA before, can you help me with this, or send me on to another resource for it?
Thanks
__________________
This can also be found here:
http://www.utteraccess.com/forums/s...1705458&page=0&view=collapsed&sb=5&o=&fpart=1
I offered to use MS Access for what i'm doing but everyone prefers Excel.. here goes...
I have a query to the Sage SQL server. It brings back all open invoices. 62,000 lines and growing. Is there a way i could manipulate MS Query with VBA?
If so.. this is what i need:
I would like to change the filters on the query.
strCustomer would be the tables 'Customer' field.
strOP would be the tables 'open_indicator' field.
I've never manipulated any queries in VBA before, can you help me with this, or send me on to another resource for it?
Thanks
__________________
This can also be found here:
http://www.utteraccess.com/forums/s...1705458&page=0&view=collapsed&sb=5&o=&fpart=1
Last edited: