Question
Entering multiple records into one database
Hi Guys,
I have created a form that repeats the text fields. I want to record all the entries into an access database. I am trying to use the SQL Insert Command but I am receiving a mismatch criteria error. Here is the command:
Command1.CommandText = "INSERT INTO tblWeek (Classdate, Week, Day, Activity, Location) VALUES ('strDate', 'strWeek', 'strDay', 'strActivity', 'strLocation') "
Any help would be greatly appreciated
I have created a form that repeats the text fields. I want to record all the entries into an access database. I am trying to use the SQL Insert Command but I am receiving a mismatch criteria error. Here is the command:
Command1.CommandText = "INSERT INTO tblWeek (Classdate, Week, Day, Activity, Location) VALUES ('strDate', 'strWeek', 'strDay', 'strActivity', 'strLocation') "
Any help would be greatly appreciated
