Result of SQL query?

[vvilan]

In php, we could get the result from the query by executing it and then use mysql_fetch_array($queryresult). How can we use something of this nature in access? Thanks!

PS. Does access have an API for their vba?

 

[Golom]

I am a vast well of ignorance about php (among other things) but in Access you would use a recordset.

Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = CurrentDb()
Set rs = db.Openrecordset("Select * From SomeTable")

Do Until rs.EOF
   SomeValue = rs![SomefieldName]
   ' ... etc. ...
   rs.MoveNext
Loop

 

[TheAceMan1]

How are ya vvilan . . .

[blue]Golom[/blue] has the exact answer you require. [blue]Recordsets[/blue] are the replacement for what you ask and is a well deversified subject. Look it up in VBA help!

BTW: Welcome to [blue]Tek-Tips![/blue] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] . . . [blue]Its Worthy Reading![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886