Search results for query: *

I've been handed a macro recorded some time ago by one of our users which creates a pivot table using data from an external database. A new requirement has arisen whereby the users want to be able to define the criteria for the pivot table i.e. rows, columns and data fields. (They cannot use...

I've been handed a macro recorded some time ago by one of our users which creates a pivot table using data from an external database. A new requirement has arisen whereby the users want to be able to define the criteria for the pivot table i.e. rows, columns and data fields. (They cannot use...

The original program was passed to me by a user who had written (or recorded I'm guessing) a hardcoded version of the query. I hadn't tried removing the Array function but now you mention it removing it works. Stupid me Thanks

I have a function which is querying an external database. It is called by another program which creates the where clause which is then passed dynamically into the SQL query. The WHERE clause is passed in as a string parameter and the function works perfectly until the string exceeds a certain...