Recent content by JDog

Thanks for your insights. What I don't understand is where I am using a "transaction". What is defined as a "transaction"? My code executes a whole bunch of statements as follows: Unfortunately I have tried inserting random "doevents" but it still causes access to crash. So you think the key...

Hi, I have written a whole lot of VBA code that extracts data from bloomberg and inserts it into my database that I have created in Access. The problem is that when I try to run my code I always get this error message: Could not start transaction; too many nested transaction and then access...

Thanks the above statement kind of achieves what I want but not exactly. Say I had another weight column called fldWeight2 is it possible to combine the following 2 SQL statements into 1 query? SELECT fldWeight2 FROM tblSectors WHERE fldDate = #12/19/2012# SELECT fldWeight FROM tblSectors...

Hi, Say for example I have a table with 3 fields: Date, Sector, Weight Is it possible for me in the one SQL statement to select the sector field with one set of criteria and the weight field with another set of criteria? ie is it possible to combine the following 2 SQL statements into 1...

Hi, I have an Excel addin that uses an ADODB.connection object to connect to an Access 2007 database that resides on a network drive. The connection string I am using is here: cnFMDB.Open "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = " & strFMDB where cnFMDB is my connection object and...