Quote: I've had a go at both Mile-O and Pat's suggestions for starters. The upshot is you don't have to recode your query/create a new one at all. Assuning it is numeric (ID's usually are), you don't need the quotes mSQL = "Select * from [Member Medical] where EMPL_ID = " & EID & ";" Incidently, you will get Then with Pat's I started putting it on the OnExit of the field that was giving me the error, then realized it would have to go on the OnClick of the check over here

Expected 1” Related 6Run-time error '3061'. MakeItSo (Programmer) 26 Apr 04 11:09 Hi Mike.If you don't need to store the SQL statement or use a recordset, you can use the DoCmd.RunSQL command:CODEDim strSQL As StringstrSQL= "UPDATE Work You can copy this string: Select glosssary.meaning,glossary.description, glossary.specification, glossary.hyperlink from Glossary where word = 'xyz'; You can open the query editor and find the SQL view by right-clicking in the top The users will then update the status and forecast of these sub-objectives. http://stackoverflow.com/questions/18516396/error-3061-too-few-parameters-2-expected

Run Time Error 3061 Too Few Parameters Expected 1

Therefore my problem is (yet again) a relationship one I feel. CapnOats (Programmer) (OP) 26 Apr 04 11:41 that works brilliantly but nowCODEDoCmd.RunSQL "INSERT INTO Work VALUES ('" & seRefText & "', '" & fmRefText & "', '" & techCombo & "', I have a database which users will access to update the status and forecast of business objectives and sub-objectives on a monthly basis.

By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Too Few Parameters. Expected 2 Microsoft Query Expected 1. Expected 1 CSV Import1Error with Allen Browne's ELOOKUP: Too Few Parameters Hot Network Questions What is the origin of the story that Santa Claus lives at the North Pole? Pulp Fiction.

Posts: 18 Thanks: 0 Thanked 0 Times in 0 Posts Duh! Openrecordset Too Few Parameters Expected 1 I've opened the query direct from the database window after the query has been run and all the correct information is visible. You currently have 0 posts. - UK Ally View Public Profile Find More Posts by Ally

Too Few Parameters. Expected 2 Microsoft Query

SQL Server downloads .•. Get the weekly newsletter! Run Time Error 3061 Too Few Parameters Expected 1 Get the weekly newsletter! Too Few Parameters. Expected 2 Excel Join Date: Dec 2002 Location: Glasgow, UK Posts: 11,312 Thanks: 4 Thanked 112 Times in 107 Posts OKay, I recreated it and found that I couldn't get it to work either.

Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? http://dailyerp.net/too-few/runtime-error-3061-too-few-parameters-expected-1.html Posts: 18 Thanks: 0 Thanked 0 Times in 0 Posts then it isnt neccessary to even have: strSQL = "SELECT * FROM qryEnablerLookup WHERE [fkMonthID]" & " = '" & Forms!frmCriteria!cboMonth Again SHOW THE SQL OF QUERY1. –PaulFrancis Sep 11 '14 at 9:39 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google I don't know how to do this with ADO but ADO does not have a parameters collection so the method would be different. Too Few Parameters. Expected 3

After changing the data source to a new database > suddenly it throws the 3061 error. > > The error occurs whether the Original line or the Test line was used. I think I have found that it comes up almost 100% of the time if I have a reference to a form's field in the query. Office UI Fabric Microsoft Graph Better with Office Word Excel Powerpoint Access Project OneDrive OneNote Outlook SharePoint Skype Yammer Android ASP .NET iOS JavaScript Node.js PHP (coming soon) Python (coming soon) this content Posts: 10 Thanks: 0 Thanked 0 Times in 0 Posts Thanks again but unfortuantely I'm still experiencing the same error message.

Yes, my password is: Forgot your password? Odbc Microsoft Access Driver Too Few Parameters. Expected 2 You can even populate this recordset like this on form load and set it to the recordset of the form. –Brad Jun 21 '14 at 2:31 Or, once you You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions.

Set rs = CurrentDb.OpenRecordset("select distinct report-period from Reports;") Is "report-period" the name of a field? A gotcha here is that the parameters did not like when I set them as date types (#xx/xx/xx#), even if the field were dates. Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Access VBA Discuss using VBA for Access programming. Run Time Error 3061 Too Few Parameters Expected 3 So, the easiest way to get it to work was to build the actual query in SQL within the code as a string (strSQL) and then use: Set r = db.OpenRecordset(strSQL)

Maybe is a problem to make rst = CurrentDb.OpenRecordset from Query1, maybe it should be done from Table. –Artec Sep 8 '14 at 19:48 Which means Query 1 is Related 2Access 2003 VBA: query works when run directly, but run-time error 3061 when run from code?1Access Run-time error '3061': Too few parameters. tblACPData and PtCoExistProb are both related to tblAdminDischData by EpisodeID. Post your question and get tips & solutions from a community of 419,088 IT Pros & Developers.

Know39 Guest The following is SQL code from a function that works fine in our current database. Dev Center Explore Why Office? If you don't see the problem then, you can paste the result here for us to look at. Linked 0 strSQL formatting in Access 0 MS Access vba “Too Few Parameters.