I do have the Microsoft Scripting Run Time enabled. My Access version is 2019 though the modules must cause it to show as Access 2007-2016 File Format. I am attaching an excel file that has my code ...

I have a recordset (rst) which I have created using an OpenRecordset Method on an existing table...call it t_Employee: Set rst = db.OpenRecordset("t_Employee", dbOpenDynaset) I want to be able to ...

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

You only be able to search the VBA code in applications that do not have the VBA editor locked (unfortunately, there is no way to programmatically unlock the VBA editor). For some Excel spreadsheets, ...

Incorrect sort order setting in Access options Fields in Access are set to an incompatible data type Hyperlink settings, such as the ‘DisplayAsHyperlink’ property and the ‘ForeColor’ property, are not ...