Access 2007 forms tips

A good compilation of new Access 2007 forms fetaures and tips made by Luke Chung, FMS.

Access 2007 will ship today!

And it should be free! No official link yet, only this post. Very exciting, let us see what we get today, crossing fingers...

Technorati tags: Access, runtime, ode, developer

Security in Access 2007

Garry Robinson, Access MVP, just posted a Security Considerations and Guidance for Access 2007 article on MSDN, which covers all security aspects in Access 2007, which are different from older versions).

How to lock checkbox on Treeview

When you have a Treeview ActiveX control with checkboxes it could be required to prevent checking or un-checking certain nodes. Unfortunately you can not do this in NodeCheck event, but MouseUp event could help here.

Declare a form class level variable:

Private cNode as Node

In NodeCheck set it to a node you want to lock (in this sample – bold node):

If Node.Bold=True Then
     Set cNode = Node
End If

And reset it to original state in MouseUp event:

If Not cNode Is Nothing Then
     cNode.Checked = true
    Set cNode = Nothing
End If

Technorati tags: ActiveX, Treeview, NodeCheck