Recent content by Ctimson

Yes, all table column names are now exactly the same, I have double checked that all spelling is correct for the text boxes also. I however tested it without any data in the text boxes it and comes up with a syntax error in the actual UPDATE INTO statement. I am using Access 2010, so I don't...

I have changed it too this now: Private Sub cmdadd_Click() CurrentDb.Execute "INSERT INTO Crit_Code(crit_code, model_year, launch_series_mixed) VALUES (" & Me.CritCode & ", " & Me.model & ", " & Me.launch & ");" End Sub And I now get a runtime error of 3061 - I looked at the links, but they...

Hi guys - I have a problem with my simple insert statement! It gives me the run error of 3134. The code: Private Sub cmdadd_Click() CurrentDb.Execute "INSERT INTO Crit_Code(crit_code, model/year, launch/series/mixed)VALUES (" & Me.CritCode & ", " & Me.model & ", " & Me.launch & ");"...

Hi guys - I need help, I've wrote this query, however I get a 3134 run time error. The code: Private Sub cmdadd_Click() CurrentDb.Execute "INSERT INTO Crit_Code(crit_code, model/year, launch/series/mixed)VALUES (" & Me.CritCode & ", " & Me.model & ", " & Me.launch & ");" End Sub I have...