DAO Beginner Question

Thank you for the come-back.

I must be doing something wrong, here. I copied your snippet into Visual
Basic 6, and modified the lines that were table specific. It would not run.
I tried to invoke the mini-wizard by typing DAO period, hoping to see a
listbox with methods under the object DAO, but none came up. Is there
something I am expected to install that I haven't installed, yet? I get the
message, "User Defined Type not defined." I tried it without DAO, and got
the same message. "Database" and "DAO" are not defined in my system.

Is there something in the Add-In manager that I need to install?

This is why I asked the question. Stuff I am reading just isn't working.

"Douglas J. Steele" wrote:

> Dim dbCurr As DAO.Database
> Dim rsCurr As DAO.Recordset
> Dim strSQL As String
>
> strSQL = "SELECT Field1, Field2, Field3 " & _
> "FROM MyTable " & _
> "ORDER BY Field1"
>
> Set dbCurr = OpenDatabase("E:\Folder\File.mdb")
> Set rsCurr = dbCurr.OpenRecordset(strSQL)
>
> Do Until rsCurr.EOF
> Debug.Print rsCurr!Field1
> rsCurr.MoveNext
> Loop
>
> rsCurr.Close
> Set rsCurr = Nothing
> dbCurr.Close
> Set dbCurr = Nothing
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "John Buffum" wrote in message
>
> >I need to have a program I am writing in Visual Basic 6.0 define a "cursor"
> > (sorry for using Oracle terms.) then open a database, open a table, read a
> > few records, and then close the table and database. The MSDN Library is a
> > little confusing, and my VB 6.0 in 21 Days book isn't helpful, either.
> >
> > Anyone point me to a piece of code? That would really help.
>
>
>
 >> Stay informed about: DAO Beginner Question 

John Buffum wrote:
> Thank you for the come-back.
>
> I must be doing something wrong, here. I copied your snippet into
> Visual Basic 6, and modified the lines that were table specific. It
> would not run. I tried to invoke the mini-wizard by typing DAO
> period, hoping to see a listbox with methods under the object DAO,
> but none came up. Is there something I am expected to install that I
> haven't installed, yet? I get the message, "User Defined Type not
> defined." I tried it without DAO, and got the same message.
> "Database" and "DAO" are not defined in my system.

Project/References/Microsoft DAO 3.6 Object Library

Tick the box and click OK.


--
Regards,

Michael Cole
 >> Stay informed about: DAO Beginner Question 

YES! That did'r. Now to work out some minor details.
Thank you.

------------

"Michael Cole" wrote:

John Buffum wrote:
Thank you for the come-back.

I must be doing something wrong, here. I copied your snippet into
Visual Basic 6, and modified the lines that were table specific. It
would not run. I tried to invoke the mini-wizard by typing DAO
period, hoping to see a listbox with methods under the object DAO,
but none came up. Is there something I am expected to install that I
haven't installed, yet? I get the message, "User Defined Type not
defined." I tried it without DAO, and got the same message.
"Database" and "DAO" are not defined in my system.

Project/References/Microsoft DAO 3.6 Object Library

Tick the box and click OK.


--
Regards,

Michael Cole
 >> Stay informed about: DAO Beginner Question