Setting "Tabbed Documents" via VBA on an MS Access 2010 database
Posted on 2014-03-31
To whom it may concern:
Could you tell me how to programmatically (VBA) set an MS Access 2010 database to "Tabbed Documents" instead of "Overlapping Windows"? I am creating a new MS Access 2010 database and I would like it to have this feature when a user opens the database. I have tried the two sets of code below and they both don't seem to work. I am not sure why either.
Call SetPropertyDAO(db, "AllowDatasheetSchema", dbBoolean, False, strMsg)
Call SetPropertyDAO(db, "DesignWithData", dbLong, mlngcAllowLayoutView, strMsg)
'Preferences for child windows.
Call SetPropertyDAO(db, "UseMDIMode", dbByte, 0, strMsg)
Call SetPropertyDAO(db, "ShowDocumentTabs", dbBoolean, True, strMsg)
db.Properties("UseMDIMode") = 0
Thank you for your help.