it gives an error when i run a SQL script

Aydiniyom

I'm trying to INSERT INTO with SQL in a table in VBA but it gives a error while running this script. why?

I was expecting it to add the values to the table but it gives an error instead, does anyone has the solution for this?

DoCmd.RunSQL "INSERT INTO tblScores (Student, Score, Date, ExamType, Lesson) VALUES (cbStudent.Value,txtScore.Value,txtDate.Value,cbExamType.value,cbLesson.Value);"

The error message:

this is the error it gives

Mero

Try this: Dim varStudent as String . varStudent = cbStudent . In SQL String: VALUES ( '" & varStudent & "', '" & varTxtScore & "'

'" = SingleQuote DoubleQuote

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Using gets() gives "No such file or directory" error when I pass arguments to my script

npm run always gives error when trying to run scripts

when I run my app on device having api greater then 19 it gives me error

I am working on creating my own UNIX shell and some times when I run 'ls' command it gives an error bad address

In python script i have insert query but when i want insert multiple columns in the same query it gives error

Why does visual studio gives me error when I want to run the GAMS code via C#?

When I run my linkedin URL from my webpage it gives me an error

curl is installed and working but gives error when i run "php composer.phar install"

SQL Error When Run In Site

NaN when I run this script

Attribute error occurs when I run my GUI code in Python. Python gives me no information as to what the error is or what is causing it

Why i get error when run the sql server script in c#?

Running SQL script gives syntax error

SQL or mariadb gives me this error when I try to create a table

In SQL table I have a sql script for dropping column which gives error invalid column does not exists

It gives error when I put button in Carousel

Rmarkdown - code run ok at script, but when knit gives error

Lua: I get error when I try to run a script in Windows

when I "run" it gives an error in Flutter. Photo attached

when I set the value of a cell with google script it gives me an error

Script gives Error only when executed by another script

When I create an 'empty compose activity' project and click run it gives me the following error

Pyinstaller gives an error when I install Python

pytorch gives me an error when I don't run it in ~/ directory

When running a script - Error no test specified appears. How do I make the script run correctly?

Why is not my discord code working? When i run the progam, it gives an error saying: TypeError: 'module' object is not callable

When I run the code, the system gives two error warnings, I wonder what is causing this?

Why I fail to run a shell script generated by a python script, which gives me "cannot execute binary file" error?

Google Apps Script gives error "Something Went Wrong" when I try to authorize my own code