pass through

Hi, Have cobbled together from different parts of the web a nifty snippet to deal with limitations of In Cell Data Validation Lists. I'm using the Worksheet_BeforeDoubleClick (ByVal Target As Range, Cancel As Boolean) event to invoke a Flash Combo Box (Usually hidden away) to select a...

Hi, I wrote a dynamic pass through query and I'm getting the annoying pop up saying that "This Recordset is not updateable" I don't want my recordset to be updateable. This is intended. Can it not bother me? Is there something I can do to turn this messaging off?

MS Access 2003 Oracle 10g Windows 7 I am basically running data updates every night into local MS Access tables from source data tables in Oracle. This worked fine, until some change on the network which produced a timeout error for all append queries that used pass-through queries. In order...

How can I replace the sheet name with a passed through named variable? MasterWB.Names("HC_Results").RefersToR1C1 = _ "=OFFSET(Results!R1C1,0,0,COUNTA(Results!C1),COUNTA(Results:Results!R1))" Does't work when I just do this: MasterWB.Names("HC_" & wsR & "").RefersToR1C1 = _...

My current Access + Excel solution: I use an Access database to create two pass through queries. Each pass through query selects records from different AS400 data source. I then use a third (regular... not pass through) query to INNER JOIN the two tables on a common field. The records returned...

I have a pass-through query that is running on a remote database (through ODBC connection). If I try to save the results of the query, it gets saved to the remote database and not on my Machine. How can I save these results on my local machine. Due to IT restrictions I am not allowed to save...

I have created several pass through queries in Access, but I would like to execute one in VBA because I want to create a dynamic SQL string. I am using Access 2007. Here is the existing SQL I am using in my pass through query (Oracle 11g): SELECT ticket_id, short_code FROM...