Search results for query: *

Geoff, I have taken your advice have been able to create a query table on the fly and then make some changes to the properties of it i.e. .RefreshStyle = xlOverwriteCells etc.. I just have a little bit of tweaking I need to do but you definitely got me over the hump. I appreciate it. You...

Hi Matt, I just wanted to let you know that the subroutine you posted cleared out all those saved queries. Of course now my query doesn't work at all - but I'm pretty sure it has to do with something I'm doing wrong. I'd rather get no data at this point than data from a database I don't even...

Hi Geoff - I'm not really sure how to create a QueryTable without using ADD. I tried doing this: ------------------------ Dim qTable As QueryTable Sub CreateQueryTable() Sqlstring = "SELECT table1.column1, table2.column2 FROM table1, table2" 'Create a new query table. Set qTable =...

Hi Matt, Thanks for the response. I originally created the query with the macro recorder and then I tweaked it from there. The funny thing is it works great for SQL2005 databases but I'm getting hung up on this problem while querying Access databases. It also appears to have something to do with...

Hi, I am trying to write a macro in Excel that allows a user to enter a parameter into an input box which will be the criteria for a query to an Access database. The input will determine what is returned from the database my worksheet is connecting to. In the sheet's NameBox is a never ending...