Search results

Background: I'm using an Access FE to manage data between two linked Excel data sets and a linked SQL table. The excel files = current master data, and the SQL table maintains current and historical data. Initially, I have queries created using the Access GUI to (1) check for changes between...

Novice programmer here so any assistance is appreciated! Have a strange problem here where AuditChanges isn't working quite right after migrating backend DB to SQL. Front End remains in Access. The below AuditChange module is not pulling the PrimaryKey for any new record being created. It...