error Archives | Kaysar Iqbal

Ms Access Error:Run-time error ’94’: Invalid use of Null

June 21, 2017June 22, 2017Mohammad Kaysar Iqbal TalukdarLeave a comment

Background: In the recordset update form execution the “Ms Access Error:Run-time error ’94’: Invalid use of Null ” Workaround: Generally this error shows up when a variable’s or a control’s in an operation has no value at all i.e NULL. Upon further investigation it seemed that the “Me.txtamount” has no value as in some stage…

MS Access Error: Run-time error ‘3061’: Too few parameters expected 1

June 21, 2017June 29, 2017Mohammad Kaysar Iqbal TalukdarLeave a comment

Background: While updating a record set the MS Access Error: Run-time error ‘3061’ showed up. Workaround: Upon investigation found the column in WHERE clause supplying wrong type of value. In the below code the [suppid] is of String type but the value supplied ” & suppidVar & “” is not a String.

MS Access Error: Run-time error ‘3073’: Operation must use an updateable query.

May 24, 2017June 27, 2017Mohammad Kaysar Iqbal TalukdarLeave a comment

MS Accès Errors