Thursday, November 21, 2013

Microsoft Access Dim dbs object

When writing code in previous version of Microsoft Access, the database object could be dimensioned with the following line:

    Dim dbs As Database

That line now cause a compile error. MS Access is able to find the reference by changing it to:

    Dim dbs As DAO.Database

No comments:

Post a Comment

VBA Excel to Double Click change to checkmark or x

 Note that to do this, you need to set the font of the affected cells to Winding 2 first: 1 2 3 4 5 6 7 8 9 10 11 12 Private Sub Worksheet...