Linked tables having Calculated field can’t be made Local in MS Access 2016

Background: For the purpose of taking backup of the MS access database, VBA script failed for one of the tables of the source database, showing “Property not found Error: 3270“. Resolution: Compact and repairing didn’t solve the issue, recreated the table also didn’t help. Upon further dig down its been observed that removing the “Calculated”…

MS Access Error: 3162: “You tried to assign the Null value to a variable that is not a Variant data type.”

Background: All of a sudden importing data from spreadsheet in a form produced the above error(it was tested and worked fine over two weeks), the same operation in another form is executing fine. This is bit frustrating when everything seems fine, no errors in logic or elsewhere but things are not working. Solution: Digging down further…

MS Access Tutorial: Displaying an alert message when recordset returns no value

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…