In this post, we will see how to resolve VB6 data match a recordset current record to an Array and get description text Question: I have table called beacons which has PrimaryCode, SecondaryCode and Description I need to retrieve the ...
In this post, we will see how to resolve VBA – DAO Recordset: How to Identify the New Line Position Question: I need to identify if a DAO recordset is positioned on the new line, once that it’s AbsolutePosition doesn’t ...
Question: I’ve been getting an error that I’ve never seen before. I keep seeing this: Run-time error ‘3048’: Cannot open any more databases. Having Googled it, it seems this happens when there are very complicated forms that have lots of ...
Question: I have developped a VB.Net DLL that can read Postgres, Oracle and OleDb. To allow this DLL to execute some SQL commands, I pass it a Connection object and I use it to execute some SQL SELECT command. My ...
Question: I have a piece of VBScript that queries an MS Access database. When the recordset query is on a table, I can go through my recordset and do a rs.MoveFirst to go back to the beginning. But when the ...