LEARN MS-ACCESS TIPS AND TRICKS

VBA Module Object and Methods. The VBA Module Object has several interesting methods and properties.  Last week, we saw how to insert a Clic...

Writing VBA code with VBA. To create an Event Procedure in a Form or Report , you can either open the VBA Module and write the procedure m...

Control SetFocus on Tab Page Click. A question was raised in an MS Access Discussion Forum : "When I click on a Tab Control Page, I wa...

Adding Data directly into External Databases. The Back-End/Front-End database design is a common practice in Microsoft Access. The back end...

Users and Groups Listing from Workgroup Information File. How about taking a printout of Users and Groups from the active Workgroup Informat...

Access Security Key Diagram  - Access 2003. Implementing Microsoft Access Security is a serious undertaking. Although this feature was depr...

Updating Sub-Form Recordset from Main Form. A Subform on a Main Form is a common design pattern used to display multiple related records al...

Easy Reference Access2003 Commands in Access2007. If you have been working with Access 2003 Menus and Toolbars, you know how easy design tas...

IIF vs. SWITCH Function in MS Access. The IIF() Function. The IIF() Function definition is reproduced here from the  Microsoft Visual Basic...

Preparing Rank List. We often use an Autonumber field in a table to automatically generate a unique sequence number for each record entered....