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

Performance: Filter VS Where Clause

In MS Access there are 2 ways to specific the records to be fetched. One is using Filter and another is using where clause query. Filter: ...

Equivalence DUAL table in MS Access

There might be a time that you want to run query like Oracle select sysdate from dual; Unfortunately, MS Access does not have dual table...

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 update External MS Access table

When linking to external MS Access DB without table link, you may have some problem updating, deleting or inserting the records. The solut...

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

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

MS Access Error Exception

Basic MS Access Error Exception When you are coding, the best programming practice is always include error exception in your code. In MS A...

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