Have any other Brits had the same problem as me with the date format when updating the CommissionCheckT table with the Process Check Button in Developer_5 video_3?
The DoCmd.RunSQL code kept swapping the day and month around, and consequently giving me the wrong date in the table..

Turns out, in SQL, the dates are interpreted in the (MM/DD/YYYY) format by default when using the '#' delimiters, regardless of your Country's system settings.
The following answer from chatGPT corrected it: -

Dim FormattedDate As String
FormattedDate = Format(Date, "MM/DD/YYYY")
    DoCmd.RunSQL "INSERT INTO CommissionChequeT " & _
        " (ChequeDate, Amount, EmployeeID) VALUES " & _
        " (# " & FormattedDate & " #, " & Total2 & ", " & EmployeeCombo & ") "

Will I always have to do this every time I use a #Date# input in a SQL statement, or is there a better way?