DBA – MySQL, PostgreSQL, MongoDB, Oracle
Background: To make the user interface more friendly in nature it’s a good approach displaying an Alert Message when MS Access Query returns no value to its corresponding recordset. How To: By using the MS Access RecordsetClone and RecordCount Property we can return a message with an empty recordset. If Me.RecordsetClone.RecordCount <= 0 Then MsgBox (“No records…
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…
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 Accès Errors
Background: Sometime it needs calling sub routine in MS Access VBA on another form or in same form to perform certain tasks on the current intended command execution as a pre-requisite of the process. There might also be needed to call a subroutine on the main from the sub-form. In addition to that calling the sub-routine from another…