Access 2007 VBA recordset

[Crilen007]

Whats the new proper way to do recordsets in VBA for Access 2007?


Any examples would be great, thanks.

 

[boblarson]

Same way as in previous versions, why do you ask? You can use DAO or ADO (for ACCDB files, DAO is the default).

 

[Crilen007]

Hmm...


There a way to select a record set using an SQL statement instead of the query name?

 

[boblarson]

Yep, you can set the recordset in the On Load event:

Me.Recordset = "SELECT whatever FROM whateverTable WHERE WhateverField = WhateverValue"

etc.

 

[Crilen007]

Well...


What I'm trying to do is calculate the time difference between records in a table using VBA and cycling records.

So I was hoping to select the records using SQL so I can choose what day and person it should be etc... It's been a while since I've had to use access lol, I would normally use PHP to do something like this.

 

[Crilen007]

Well I guess I can use SQL instead of the Query Name, I love VBA sometimes lol

 

[boblarson]

I thought you wanted a SQL Statement instead of the query name. You can also use

Me.Recordsource = "NameOfSavedQuery"

that will work too.