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

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

MS Access Tables and Relationships

Access 2007 Tutorial Tables and Relationships This is the video from youtube.com that teaches basic MS Access. This tutorial video teaches...

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

A little bit of my background on MS Access

Here are my brief background related to MS Access. I really started working with MS Access in the year 2000. However, my MS Access learning...