Question about Microsoft Visual Basic 6.0 for PC

1 Answer

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

Posted by on

Ad

1 Answer

  • 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

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 .

Posted on Jul 20, 2009

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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 (-).

Aug 08, 2014 | Office Equipment & Supplies

1 Answer

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.

May 27, 2014 | Texas Instruments TI-84 Plus Silver...

1 Answer

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>

Apr 06, 2013 | Computers & Internet

1 Answer

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>

Dec 06, 2012 | Mozilla Firefox

1 Answer

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)

Apr 25, 2011 | Playdom WSOP Poker

1 Answer

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

Oct 13, 2009 | Microsoft Windows Vista Home Premium with...

1 Answer

Cannot load office outlook 2003


Try uninstalling Outlook then reinstalling it. Good Luck!

Nov 15, 2008 | Microsoft Office Outlook 2003 for PC

2 Answers

Syntax lcos


The lamp is dead. Call syntax/olevia and pay em a 100 bucks for a new one.

Mar 28, 2007 | Syntax Olevia 50" Rear Projection...

Not finding what you are looking for?
Microsoft Visual Basic 6.0 for PC Logo

Related Topics:

372 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2905 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18411 Answers

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

Answer questions

Manuals & User Guides

Loading...