News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, May 24, 2007

Access 2007 forms tips

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

Tuesday, May 15, 2007

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: , , ,

Wednesday, May 09, 2007

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).

Wednesday, May 02, 2007

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: , ,