Search results

Also, this is entered into a Module as opposed to the VBA of a form.

I made the suggested change but still have the same result. Included is the updated SQL code. mySQL = "INSERT INTO [US History] ( Student_ID, Period, Teacher ) " mySQL = mySQL & "SELECT AllStudents.Student_ID, Mid$([AllStudents].[Col1_Class_Name_4],2,1) AS Period...

I have done VBCode in Access 2003 for years and am finally making the jump and am coding in Access 2013. I am getting the error The expression you entered has an invalid . (dot) or ! operator or invalid parenthesis. and I cannot figure out why. Here is my code: Function CreateUSHistory()...