I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to figure out how to display the results of a procedure in an unbound text box on a form, I just can’t figure out how to get the results of a recordset into fields in a table. Can you help with the following DAO code explaining a step-by-step process?
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = OpenDatabase("C:Acc07_ByExampleNorthwind 2007.accdb")
Set rst = db.OpenRecordset("Customers", dbOpenTable)
Do Until rst.BOF 'Beginning of File
SendKeys "^g" 'send to Immediate window
Set rst = Nothing
Set db = Nothing
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!