Lab Sql

I'm new to VBA and Access in general and ran into this problem whilst trying to use the propose… Read more Vba/access Recordset Per Form Record Problem

I've updated the code with the suggestion given below, which I've tested and works great, f… Read more How To Specify Primary Key When Using Vba To Create Tables

Having a problem with VBA. I have written sql code (300 lines) which works perfect in SQL giving ou… Read more Sql Query Output In Vba Is Different Than In Sql Oracle

I am trying to assign salespeople (rsSalespeople) to customers (rsCustomers) in a round-robin fashi… Read more Looping Through Recordset With Vba

General explanation: my query 2_Total returns a single value: Run the VBA function that exports … Read more Ms Access Openredcordset Reading Wrong String