The (1) and (2) under the background statement, is the current process being used, using several Access queries and a couple of pass-thru queries to SQL.
I would have though the the VBA approach is faster than the Access Query approach, but not as fast as a SQL approach. I may look into the...
Yes that seemed to correct the problem: Changing the line to
< Set rs2 = db.OpenRecordset("dbo_Daily Orders Booked - Combined", dbOpenDynaset, dbSeeChanges)>
Now on to the next problem. Seems the line:
< rs2.FindFirst "ID = " & rs1!Index> 'does not match the records.
Tried variant...
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...
Figured it out. Ran the utility using a temp AccessDB BE. Imported the created table in the tempDB to SQL, then in theFrontEnd (Master) created a link to the SQL table. Works fine.
Thanks for the inputs. Module Code left as was. Created new hidden field on each form for the next ID in sequence and called it out in the event. Things work as intended.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then
Call AuditChanges("NexID", "NEW")
Else
Call...
Thanks for the reply. I'm calling the module when the form(s) are closed by
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.NewRecord Then
Call AuditChanges("ID", "NEW")
Else
Call AuditChanges("ID", "EDIT")
End If
End Sub
Primary Keys are set in SQL and the...
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...