How to Filter Records

 Keywords: DAO Filter records ,MDB 

---

Sample code:

Make sure DAO.DBEngine.35 exists on those computers. Maybe try searching the registry for that application object. Search under HKEY_Classes_Root for DAO.DBEngine....

And make sure that version 3.5 (35 above) is installed. Open up the registry editor on the PC and do a search for:

DAO.DBEngine

If it's installed it will show up as: DAO.DBEngine.35

---

dao=ObjectOpen("DAO.DBEngine.35")
ws=dao.CreateWorkspace("JetWorkspace","admin","")
user_db=ws.OpenDatabase("Users.mdb")
user_rs=user_db.OpenRecordset("select * from usernames")

This code will filter records where censored = 0 AND id >= 1024.

user_rs.filter="censored = 0"
user_rs=user_rs.OpenRecordset
user_rs.filter="id >= 1024"
user_rs=user_rs.OpenRecordset

This code will filter records where censored = 0 OR id >= 1024.

user_rs.filter="censored = 0 OR id >= 1024"
user_rs=user_rs.OpenRecordset

This code will sort by id DESC.

user_rs.sort="id DESC"
user_rs=user_rs.OpenRecordset