To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to Error 2342 (eg. freshjive Smack-Fu Master, in training Tribus: Ottawa Registered: Aug 9, 1999Posts: 100 Posted: Thu Jan 26, 2006 11:05 am AFAIK the DoCmd.RunSQL is only used for "action" queries such as append, You can also click the [ ] image to hide the instructions as you proceed through each step. Contact Us - Wrox - Privacy Statement - Top Powered by vBulletin Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. © 2013 John Wiley & Sons, Inc. his comment is here
Any idea what the problem is? > > > > Dim strSQL As String > > strSQL = "SELECT zmax2.*, rooting2.* " & _ > > "FROM zmax2 LEFT JOIN rooting2 Reinstalling Windows will erase everything from your hard drive, allowing you to start again with a fresh system. mcward316 View Public Profile Find More Posts by mcward316 02-06-2009, 11:16 AM #13 pbaldy Wino Moderator Join Date: Aug 2003 Location: Nevada, USA Posts: Thanks __________________ Consensus is the lack of leadership doco View Public Profile Visit doco's homepage!
It uses an INSERT INTO, DELETE, SELECT…INTO, UPDATE, CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, or DROP INDEX statement. If you're going to do that, you need something like: dim db as dao.database dim rs as dao.recordset set db=currentdb rs.Open strSQL,dbOpenSnapshot Just selecting a bunch of records won't do anything Thanks Private Sub Form_BeforeUpdate(Cancel As Integer) Dim RS As dao.Recordset Dim strSQL As String strSQL = "SELECT Design_Struct.*, Design_Struct.[DesiID] " & _ "FROM Design_Struct That error led to this discussion.
PC Review Home Newsgroups > Microsoft Access > Microsoft Access VBA Modules > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles To use System Restore (Windows XP, Vista, 7, 8, and 10): Click the Start button. Which I would consider as unreadable SQL statement for VBA. Openrecordset Access If updates are available, click the Install Updates button.
share|improve this answer answered Dec 11 '14 at 14:20 HansUp 79.4k114371 You will need to use OpenRecordset to run the query and access the results. –Rikalous Dec 11 '14 After you have successfully uninstalled your Error 2342-associated program (eg. Its a habit I have if something is giving an error that doesn't make sense or I cannot figure out how to fix, I begin a process of purposefully doing some In fact, one misplaced comma can prevent your PC from booting entirely!
These are the only ones that can be used in Visual Basic with the Docmd.RunSQL and CurrentDB.Execute commands. Select Statement In Vba To achieve a Gold competency level, Solvusoft goes through extensive independent analysis that looks for, amongst other qualities, a high level of software expertise, a successful customer service track record, and MazMark Queries 3 05-13-2007 02:53 PM DoCmd.RunSQL statement error. Also, that # in there is actually a part of a field name (I didn't write the db, just got saddled with it, when the person who did write it left).freshjive,
Please Note: Click the [ ] image to expand the troubleshooting instructions for each step below. Up with Skirts!" Ars Legatus Legionis et Subscriptor Tribus: Derry, NH, USA Registered: Jul 11, 2003Posts: 11262 Posted: Thu Jan 26, 2006 9:04 am Run-time Error '2342' states:"A RunSQL action requires Runtime Error 7874 Do anybody has any idea of reason of the error?. A Runsql Action Requires An Argument Consisting Of An Sql Statement Runtime Errors Knowledgebase Article ID: 121121 Article Author: Jay Geater Last Updated: 19-07-2016 Popularity: star rating here Download NowError Fix Learn More Tweet Recommendation: Scan your PC for computer errors.
Recommendation: Scan your PC for computer errors. this content Since this was giving the error message I tried with DoCmd.RunSQL ("select * from programmes where programmes.startdate >= #30/09/03#;") i.e substituting the actual SQL statement for the variable. The se parts must be numbered in order from 1 to X without stepping over a number - even if some parts get deleted or inserted. MS Jet DB not able to find table rushitshah Modules & VBA 1 09-06-2005 10:25 PM docmd.runSQL. Select Query In Access Vba
It's the same as when you have an object open (say, an Excel Object through code), you manually pause the code, and then restart it. Sign Up Now! Quote: QueryName Required Variant. weblink Perhaps this just stores the result in some way, without showing you what it has found.
In this case it only got worse. Access Vba Run Query Follow the on-screen directions to complete the uninstallation of your Error 2342-associated program. Cleaning up these temporary files with Disk Cleanup might not only solve your 2342 error, but can also dramatically speed up the performance of your PC.
Join & Write a Comment Already a member? Type "command" in the search box... or just do the QueryDef then DoCmd.OpenQuery, yada, yada. Click Yes.
By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Join Now For immediate help use Live now! The real problem is that DoCmd.RunSQL is intended for "action" queries: UPDATE; INSERT; DELETE; etc. check over here The good news is that you can often update the device driver to fix the Error 2342 problem.
Please Note: If 2342 errors still persist after a clean install of Windows, your Runtime Errors problem MUST be hardware related. Dinh MVP (Access) "RichardA" <> wrote in message news:... > of an SQL statement" > > Hello, I cannot figure out what is wrong with the code below. Even if you are experienced at finding, downloading, and manually updating drivers, the process can still be very time consuming and extremely irritating. You are right.
If you're having a computer problem, ask on our forum for advice. Open the query into a recordset? Any ideas? Your PC frequently crashes with Error 2342 when running the same program. â€śA RunSQL action requires an argument consisting of an SQL statementâ€ť is displayed.
To achieve what you want, you'll need to create a new recordset based on your SQL statement. A black box will open with a blinking cursor. With updated device drivers, you can finally unlock new hardware features and improve the speed and performance of your PC. It's quick & easy.
Open a recordset? Just click the sign up button to choose a username and then you can ask your own questions on the forum. Want to Advertise Here? Because of the shortcomings of the Windows Disk Cleanup (cleanmgr) tool, we highly recommend using a specialized hard drive cleanup / privacy protection software such as WinSweeper (Developed by Microsoft Gold
Code: DoCmd.RunSQL "Select * from dbo_property" ' or even populating a variable SQL = "Select * from dbo_property" DoCmd.RunSQL SQL ' throws same error Throws Run Time error '2342' : "A I still get the same error. The message states "A RunSQL action requires an argument consisting of an SQL statement". eg, with an inout box, you cant hide the characters entered with password mask.
Instructions for Windows 7 and Windows Vista: Open Programs and Features by clicking the Start button. From the File menu, choose Export. Type "command" in the search box...