How to Disable Shift By Pass Key in MS Access MDE/ACCDE

Disable By Pass Key in Access There might be a time when developing MS Access and you want to prevent user from holding down Shift Key t...

How to Replace String With Regular Expression in MS Access

Regular Expression is a very powerful technique or tools that can help save much of your time in writing your code. Like other development...

How to go back to current record when doing Requery

Sub openDetailForm(p_frm As Form, p_frm_detail_name, Optional p_ctrl_col = Null, Optional p_key_col = Null, Optional p_refresh = True, Opti...

How to Connect to External MS Access File With Password Projected

It is a very good practice to separate your MS Access application (MS Access code file - front end)  away from MS Access data (table - back ...

How to turn off security warning in MS Access

When developing MS Access Application, MS Access 2007 will come with VBA Macro disabled. You will not be able to run MS Access VB Code if t...

How to turn off warning message to confirm when doing update, insert, delete in MS Access

When you are doing DML query in MS Access, you will normally get the confirmation message. If you don't want this message to pop up, her...

How to link read only table from external MS Access

There are times when you need to link table from external MS Access, and MS Access does support that functionality. It can also support m...

VBA Code Does Not Work On ACCDE File

I once have experienced the very strange behavior of MS Access 2007, the one that didn't exist in the previous version. The strange thin...

Option Explicit

One of another best practice for MS Access programming is to use  Option Explicit.  Place Option Explicit on the top of each module Fo...

Solution for Property not Found error on BeforeUpdate event

Property not Found error will occur when you want to cancel the value update on BeforeUpdate event in MS Access Form. When you set the Can...