OpenDatabase()

[LegBone]

I am new to programming Access in VBA however, I have experience using VB6 to open, and manipulate databases. My question has to do with opening databases and tables to run queries.

In VB I would use this to define and open a database,

Dim DB as Database
Dim RS as Recordset
Dim SQL as String
Set DB = OpenDatabase(somedatabaseName)

Then I would define a string for my query...

SQL = SELECT * from tblName

Then I would run the query...

Set RS = DB.OpenRecordset(SQL)

To start with, do I really need to open the database since I've already opened it when I started access?

If I don't, then how do I define and open a recordset?

[pbaldy]

Try

Set db = CurrentDb

[LegBone]

Try

Set db = CurrentDb

Thank you very much...

[pbaldy]

No problem, and welcome to the site.