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