Home > General > 2147217904

2147217904

The parameter is:[Forms]![Form1]![txtQuantity]If you just want to use the query in code when the form itreferences is open then use DAO and open the recordset using thename of the query. Join Now For immediate help use Live now! Set rs = New ADODB.Recordset 'assign memory to the recordset 'ConnectionString Open '--5 aguments-- 'Source, ActiveConnection, CursorType, LockType, Options rs.Open StrSql, cnn GetDistinctValue = rs("UniqueRecordsCount") MsgBox (GetDistinctValue) UserForm1.Controls("txtCrt6").Value = rs!UniqueRecordsCount 'Check Reference Sheets Code Snippets C Snippets C++ Snippets Java Snippets Visual Basic Snippets C# Snippets VB.NET Snippets ASP.NET Snippets PHP Snippets Python Snippets Ruby Snippets ColdFusion Snippets SQL Snippets Assembly Snippets

RUNTIME ERROR :NO VAL GIVEN FOR ONE OR MORE REQ PARAMETERS No Value Given For One More Required Parameters Run-time Error '5' Invalid Procedure Call Or Argument - Vba In Excel I hope that you don't mind me asking one more question. Option Compare Database Option Explicit Private Sub Form_Load() Call Compute85_Percent_Compl_Pack DoCmd.Close End Sub Sub Compute85_Percent_Compl_Pack() Dim objRec As New ADODB.Recordset Dim sSQLCode As String Dim lNum As Long Dim lRec As Should look like this.Code:StrSQL = "Update [tblApply Percentage To Base] " & _ "Set [tot prev budget] = " & _ "[tot prev budget]*[percentage] " & _ "Where [function id] = http://www.vbforums.com/showthread.php?431051-RESOLVED-Help-on-Run-Time-Error-2147217904(80040e10)-in-ADOdatabase

Is it not the case that DAO can't resolve control references? -- David W. Get 1:1 Help Now Advertise Here Enjoyed your answer? I've spent a couple days on something that I thought would only take me a little while, and the only trouble I thought I was going to have with this was Thissurprisedme and I looked to see if there is a size limit on VBA string.

You currently have 0 posts. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda… MS Access Advertise Here 707 members asked questions and received personalized In my reading on this topic they said that if you were going to use any backend except an Access DB I should use ADO instead of DAO. I will double check my code!nbeni, | Post Points: 5 < Previous Topic | Next Topic > Page 1 of 1 (7 items) | RSS Copyright 1998-2016 vbCity.com LLC The .NET

Similar topics ADO Recordset Error run-time error '-2147217904 (80040e10)': No value given for one or more parameters run time error 2147217904(80040e10) VBA run-time error Dynamic report Run time error '-2147217904'(80040e10) Need You could try and let us know I hope. -- Lyle Fairfield Dec 22 '05 #11 P: n/a oraustin using DAO doesn't fix it - strange - I would have thought Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply ← Previous Topic VB6 Next Topic → Page 1 of 1 Related VB TopicsbetaNo Value Given For One I only discovered the difference after copying the SQL statement to notepad and retrying it.

I must have missed that. Dynamic Array)Public myDatabase() As DVD the form lay out: [IMG]untitled[/IMG] Im using Dynamic array to combine to the database Please reply soon...Thanks.. Join them; it only takes a minute: Sign up Error 2147217904 No value given for one or more required parameters when querying Access from Excel up vote 1 down vote favorite There is probably some minor problem with my code that I can't figure out.

George Home | Blog Reply With Quote 03-19-07,10:21 #5 healdem View Profile View Forum Posts Jaded Developer Join Date Nov 2004 Location out on a limb Posts 13,692 Provided Answers: 59 http://vbcity.com/forums/t/58294.aspx Dec 22 '05 #12 P: n/a Lyle Fairfield Maybe dynamic SQL strings? The time now is 11:44. Fenton or******@hotmail.com wrote in news:11*********************@f14g2000cwb.googlegro ups.com: sorry david, maybe I am being a bit dim but I don't quite understand.

Either way - isn't that similar to "dynamic" SQL ( a phrase from above) which seems to mean a string of SQL language with a variable embeded in it - in Bill Mosca www.thatlldoit.com http://tech.groups.yahoo.com/group/MS_Access_Professionals Thursday, January 24, 2013 8:49 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. First, put a break point on the spot in the code that is opening the ADODB.Recordset - rs.Open Line 41 in your posted code. Are human fetal cells used to produce Pepsi?

Obviously I was wrong. Application.ScreenUpdating = True 'error handler On Error GoTo 0 Exit Sub errHandler: 'clear memory Set rs = Nothing Set cnn = Nothing MsgBox "Error " & Err.Number & " (" & Thanks again for your help. Using OR would return anything which starts with "a" plus anything which starts with "b" plus anything which starts with "c".

Which line does it highlight as being the error? __________________ Free tools, code and samples here: To view links or images in signatures your post count must be 10 or greater. SQL Server downloads .. Eventually we're planning to move this application to a SQL Server backend.

If the saved queries don't have WHERE clauses, yes, the saved queries return all the records.

Appreciate the help.... Suggested Solutions Title # Comments Views Activity MS Date Picker 64 bit 32 bit issue 12 42 23d Access 2013 has NO Stepped Layout for reporting 6 19 21d Display multiple On the way to work yesterday I decided that I would try calling the query that would call the other query route. Thedda View Public Profile Find More Posts by Thedda

09-18-2009, 08:43 AM #4 boblarson Former Moderator Join Date: Jan 2001 Location: Oregon, USA Posts:

MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Oct 3rd, 2006,08:37 PM #3 1g0r View Profile View Forum Posts Thread Starter Junior Member Join Date Oct 2006 Posts 31 I rarely use ADO myself, so am not sure of the syntax, but here's a snippet of code for mail-merging which does this using DAO, where strQuery is an argument passed Word for that which is symbolized by a symbol Where are my downvotes? Thread Tools Rate Thread Display Modes 09-18-2009, 06:41 AM #1 Thedda Registered User Join Date: Aug 2002 Location: Austin, Tx.

rs.Close cnn.Close 'clear memory Set rs = Nothing Set cnn = Nothing 'Enable the screen. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. They may be low, but I have them!" - Bette Middler "It's a book about a Spanish guy named Manual. Register Help Remember Me?

That is, don't include a WHERE clause in your stored query, and add the WHERE clause based on the value from the form when you need it. -- David W.