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

Run-time error '3061'. Too few parameters. Expected 1.

The solution to MS Access run-time error " Run-time error '3061'. Too few parameters. Expected 1. " If you run into ...

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