Microsoft Visual Basic 6.0 for PC Logo

Related Topics:

Posted on Jul 20, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

SYntax error in from clause

Whenever I am running the project, in some forms there is as an error as mentioned below. "Syntax error in From clause"Here table name is also correct but the above error is occuring in the line below rs.Open "user", db, adOpenKeyset, adLockOptimistic, adCmdTable .I haven't used any From clause

1 Answer

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

  • Expert 76 Answers
  • Posted on Jul 20, 2009
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Hot-Shot:

An expert who has answered 20 questions.

Joined: Jul 15, 2009
Answers
76
Questions
0
Helped
55426
Points
193

Hi

Try to run the record set query (the one rs.open uses ) directly in the db you are using .

If you are not sure what is the query concatenate it into variable and get the full query just before you open the record set.

once you do that you will get better idea of what is wrong with the query .

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Why am i getting Parse error: syntax error, unexpected end of file in C:\xampp\htdocs\conditionalssf.php on line 66

Google:

Parse error: syntax error, unexpected end of file in C:\xampp\htdocs\conditionalssf.php

Error fix explained.
0helpful
1answer

I have a casio fx-9750 g2.Whenever i try to dra w a graph it always get a syntax error the manual has not helped.kindly assist.

Please give the exact examples you were trying to graph. The syntax error points to an error in the input line, such as using the minus sign instead of the change sign (-).
1helpful
1answer

What does error syntax mean

You enter a command. It is like an English sentence with a syntax (correct structure). If the structure of the command is wrong, you have a syntax error. You could use a minus - sign, instead of a change sign (-) that constitutes a syntax error.
0helpful
1answer

Cannot view my own website. it reads: "Parse error: syntax error, unexpected $end..." in my index.php file. HELP

Syntax errors are the most common problem for developers. A single syntax error can cripple even the best applications and websites. You can correct syntax errors easily once you find them. Typical errors include missing commas, semicolons and parenthesis. Debuggers are available in many software development kits to aid you in the location of syntax errors. However, you can find and correct syntax errors manually as well. Learning how to correct syntax errors is an essential part of being a software developer.

Locate the syntax error manually. Step through each section of your code. Most code will be sectioned off into groups or functions. Carefully proof your code. Be sure to pay close attention to how lines are grouped. A common syntax mistake is incorrect grouping.

For instance, if you have an If Else statement embedded in another If Else statement, be sure the embedded statement is surrounded by a separate set of parenthesis or brackets, depending on your language. Double-check notes sections. Notes are only for the developer to see. However, if the syntax isn't correct, the notes may become part of your application, which may not agree with existing code. Ensure the syntax around your notes is correct. Run a debugger if possible. This will make locating errors much easier. A debugger will be found under a menu such as Debug, Run or Tools or as part of your SDK's toolbar. Allow the debugger to run. Errors will be listed at the bottom or right side of your screen. Many debuggers will highlight possible errors in your code as well. A line number, along with the possible error, will be listed in the error message. Locate your syntax error if the debugger isn't correct. Sometimes a debugger will show you where your application stopped working correctly. The syntax error itself may be above or below the line listed in the debugger message. Check all syntax within the surrounding area, especially within the line's function. Run your application after correcting the syntax error. Check every possible function of your application to ensure it works correctly. If you find a problem, double-check the syntax in your code that surrounds the problem area. For instance, if your application has a log-in screen that isn't accepting passwords correctly, check the code for the log-in screen. Remove Syntax Error syntax error typically occurs when the Web page you are loading causes a script error in the browser. This is caused by incorrect code that displays an error message or results in a Web page that does not load correctly. You can remove a syntax error by making a change to the settings of your Web browser. Common Web browsers that can experience this type of error include Internet Explorer, Mozilla Firefox and Safari.
Double-click the "Internet Explorer" icon to open the program. Click the "Tools" drop-down menu and select "Internet Options." This will display the Internet Options window. Go to the "Advanced" tab and scroll down to the "Browsing" section. Remove the check from the box for "Disable script debugging (Internet Explorer)," "Disable script debugging (Other)" and "Display a notification about every script error." Click the "Apply" button to save the changes. Click the "OK" button to close the Internet Options window. Close and restart the Internet Explorer browser for the changes you made to take effect. b> Mozilla Firefox b> Double-click the "Mozilla Firefox" icon to open the program. Type "about:config" into the address bar and press the "Enter" key. Type "dom.max_script_run_time" into the Filter text box and press the "Enter" key. Double-click "dom.max_script_run_time" to display the Enter Integer Value dialog box. Enter a value of "10" or "15" into the text box and click the "OK" button to save the change. Close and then restart the Firefox browser for the change to take effect. b> Safari b> Click the "Safari" icon to open the Web browser. Select the option for "Preferences" from the menu bar. Go to the Advanced tab and click the option for "Show Develop menu in menu bar." Click the option for "Develop" from the menu bar. Click the option for "Disable Runaway JavaScript Timer." Close and re-open the browser for the change to take effect.

b>

b>
1helpful
1answer

I keep getting a box on my screen every time i try to do anything. it says EvalInsandbox:SyntaxError:syntaxerror

Correct a Syntax Error Syntax errors are the most common problem for developers. A single syntax error can cripple even the best applications and websites. You can correct syntax errors easily once you find them. Typical errors include missing commas, semicolons and parenthesis. Debuggers are available in many software development kits to aid you in the location of syntax errors. However, you can find and correct syntax errors manually as well. Learning how to correct syntax errors is an essential part of being a software developer.

Locate the syntax error manually. Step through each section of your code. Most code will be sectioned off into groups or functions. Carefully proof your code. Be sure to pay close attention to how lines are grouped. A common syntax mistake is incorrect grouping.

For instance, if you have an If Else statement embedded in another If Else statement, be sure the embedded statement is surrounded by a separate set of parenthesis or brackets, depending on your language. Double-check notes sections. Notes are only for the developer to see. However, if the syntax isn't correct, the notes may become part of your application, which may not agree with existing code. Ensure the syntax around your notes is correct. Run a debugger if possible. This will make locating errors much easier. A debugger will be found under a menu such as Debug, Run or Tools or as part of your SDK's toolbar. Allow the debugger to run. Errors will be listed at the bottom or right side of your screen. Many debuggers will highlight possible errors in your code as well. A line number, along with the possible error, will be listed in the error message. Locate your syntax error if the debugger isn't correct. Sometimes a debugger will show you where your application stopped working correctly. The syntax error itself may be above or below the line listed in the debugger message. Check all syntax within the surrounding area, especially within the line's function. Run your application after correcting the syntax error. Check every possible function of your application to ensure it works correctly. If you find a problem, double-check the syntax in your code that surrounds the problem area. For instance, if your application has a log-in screen that isn't accepting passwords correctly, check the code for the log-in screen. Remove Syntax Error syntax error typically occurs when the Web page you are loading causes a script error in the browser. This is caused by incorrect code that displays an error message or results in a Web page that does not load correctly. You can remove a syntax error by making a change to the settings of your Web browser. Common Web browsers that can experience this type of error include Internet Explorer, Mozilla Firefox and Safari.
Double-click the "Internet Explorer" icon to open the program. Click the "Tools" drop-down menu and select "Internet Options." This will display the Internet Options window. Go to the "Advanced" tab and scroll down to the "Browsing" section. Remove the check from the box for "Disable script debugging (Internet Explorer)," "Disable script debugging (Other)" and "Display a notification about every script error." Click the "Apply" button to save the changes. Click the "OK" button to close the Internet Options window. Close and restart the Internet Explorer browser for the changes you made to take effect. b> Mozilla Firefox b> Double-click the "Mozilla Firefox" icon to open the program. Type "about:config" into the address bar and press the "Enter" key. Type "dom.max_script_run_time" into the Filter text box and press the "Enter" key. Double-click "dom.max_script_run_time" to display the Enter Integer Value dialog box. Enter a value of "10" or "15" into the text box and click the "OK" button to save the change. Close and then restart the Firefox browser for the change to take effect. b> Safari b> Click the "Safari" icon to open the Web browser. Select the option for "Preferences" from the menu bar. Go to the Advanced tab and click the option for "Show Develop menu in menu bar." Click the option for "Develop" from the menu bar. Click the option for "Disable Runaway JavaScript Timer." Close and re-open the browser for the change to take effect. Hope this helps.

b>

b>
0helpful
1answer

I GET ON FACEBOOK THEN I GO TO WSOP SITE CLICK TO PLAY AND NOTHING HAPPENS OR I GET A MESSAGE TELLING ME THERE IS A SYNTAX ERROR (12) . I DON'T HAVE A CLUE WHAT THAT MEANS. ANY HELP WOULD BE APPRECIATED

syntax error - an error of language resulting from code that does not conform to the syntax of the programming language; "syntax errors can be recognized at compilation time"; "a common syntax error is to omit a parenthesis"...

("syntax error" is a kind of...):

programming errorsoftware error (error resulting from bad code in some program involved in producing the erroneous result)

0helpful
1answer

Can you correct my error message? command line option SYNTAX ERROR I get this message when I try to open a pps file. I have Microsoft Power Point installed on the computer. Thea.

In computer science a syntax error ( IPA: /ˈsɪntæks ɛrə(ɹ)/ ) refers to an error in the syntax of a sequence of characters or tokens that is intended to be written in a particular programming language.
For compiled languages syntax errors occur strictly at compile-time. A program will not compile until all syntax errors are corrected. For interpreted languages however syntax errors cannot be detected until runtime and it is not necessarily simple to differentiate a syntax error from a semantic error.
A syntax error may also occur when an invalid equation is entered into a calculator. This can be caused, for instance, by opening brackets without closing them, or less commonly, entering several decimal points in one number.

copy and paste this link in your internet address bar for more information:

http://www.google.com/search?q=SYNTAX+ERROR&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a


feel free to ask any other questions
0helpful
2answers

Syntax lcos

The lamp is dead. Call syntax/olevia and pay em a 100 bucks for a new one.
Not finding what you are looking for?

406 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...