Can you help with the following DAO code explaining a step-by-step process?

10 pts.
Tags:
Access 2007
DAO
Microsoft Access
VBA
Visual Basic
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? Sub ReadFromEnd() Dim db As DAO.Database Dim rst As DAO.Recordset Set db = OpenDatabase("C:Acc07_ByExampleNorthwind 2007.accdb") Set rst = db.OpenRecordset("Customers", dbOpenTable) rst.MoveLast Do Until rst.BOF 'Beginning of File Debug.Print rst!Company rst.MovePrevious Loop SendKeys "^g" 'send to Immediate window rst.Close Set rst = Nothing db.Close Set db = Nothing End Sub

Answer Wiki

Thanks. We'll let you know when a new response is added.

This isn’t a direct answer, but you can find some good Access tutorials here:

http://www.fontstuff.com/

Martin is pretty helpful, if you ask him I’m sure he’d be able to provide some sample code.

–JP

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following