Ms Access Error 2482
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Microsoft Access Error 2482 up vote 0 down vote favorite I am using MS Access application and I am getting an error on just one user's pc: Microsoft Error: 2482 - Microsoft Access can't find the name ... you entered in the expression.You may have specified a control that wasn't on the current object without specifying the correct form or report context. To refer to a control on another form or report, precede the control name with the name of a collection, usually either Forms or Reports, and the name of the form or report to which the control belongs.For example, Forms![Products]![Units In Stock]. Any help will be appreciated Thanks ms-access share|improve this question edited Sep 25 '14 at 0:38 pnuts 33.9k63769 asked Jun 4 '10 at 7:52 CREFLY 1113 Can you be more specific? What access version do you use? When do you get error? Can you show that code part? –hgulyan Jun 4 '10 at 7:54 the user is working on Access runtime version 2003 and the error is generated when he tried to select any item from the combobox other than the first one Thanks in advance –CREFLY Jun 8 '10 at 6:03 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Check the references in the code window. Missing reference can lead to quite odd error messages and if you are only getting a problem on one PC, a missing reference is not unlikely. From your recent comment on your post, it seems that http://support.microsoft.com/kb/945674 may be relevant to you. Among the problems listed is: 945280 Combo box controls and list box controls display no value or incorrect values in Access 2003 after you install Office 2003 Service Pack 3 share|improve this answer edited Jun 8 '10 at 7:32 answered Jun 4 '10 at 9:43 Fionnuala 77.2k665110 Thank you Remou. We will try to rearrange the references of Access on this pc –CREFLY Jun 8 '10 at 6:22 Missing references will be marked MISSING. There is an issue with Access 2003, and I h
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: runtime error 2482 - Access cannot find Table that is there Visual Studio Languages , .NET Framework > Visual http://stackoverflow.com/questions/2972323/microsoft-access-error-2482 Basic Question 0 Sign in to vote I have an Access VB module that, when I try to run it, reports "Run-time error '2482': Microsoft Office Access can't find the name 'LSAYCollVars_ACIS' you entered in the expression." and highlights the line: par.Value = Eval(par.Name), which I realize means that the problem is somewhere before that line.The code in question is---------Sub CreateCharVars()Dim strVarType https://social.msdn.microsoft.com/Forums/en-US/c323c3e5-23fd-4f77-ac59-da93849c682b/runtime-error-2482-access-cannot-find-table-that-is-there?forum=vbgeneral As String, strCllgVar As String, strCllgFice As StringDim strCllgEnrollYr As String, StrFiceYr As String, strSQL As StringDim iLoop As Integer, jLoop As Integer, kLoop As IntegerDim dbs As DatabaseDim rsVarType As Recordset, rsCllgFice As Recordset, rsCllgVar As RecordsetDim rsCllgEnrollYr As Recordset, rsFiceYr As RecordsetDim qdf As QueryDef 'add these twoDim par As Parameter Set dbs = CurrentDb With CurrentDb Set qdf = dbs.QueryDefs("MyQuery") 'add this For iLoop = 1 To 5 For jLoop = 1 To 18 For kLoop = 1 To 21 Set rsVarType = dbs.OpenRecordset("Select VarType From tblCharacter Where ID = " & iLoop) strVarType = rsVarType!VarType ' Set the first Variable Type string Set rsCllgVar = dbs.OpenRecordset("Select CllgVar From tblCharacter Where ID = " & jLoop) strCllgVar = rsCllgVar!CllgVar ' Set the first College Var string Set rsCllgFice = dbs.OpenRecordset("Select CllgFice From tblCharacter Where ID = " & jLoop) strCllgFice = rsCllgFice!CllgFice ' Set the first College Fice string Set rsCllgEnrollYr = dbs.OpenRecordset("Select CllgEnrollYr From tblCharacter Where ID = " & jLoop) strCllgEnrollYr = rsCllgEnrollYr!CllgEnrollYr ' Set the first College Enrollment Year string Set rsFiceYr = dbs.OpenRecordset("Select FiceYr From t
Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 01-08-2003, 07:31 AM #1 jrmywvr Junior http://www.access-programmers.co.uk/forums/showthread.php?t=39946 Member Join Date: Jan 2003 Location: Othello, WA Posts: 10 Thanks: 0 Thanked 0 Times in 0 Posts Parameter Query based on Form Control I have a question regarding a previous post--using recordset as query criteria? I have a form with several combo boxes corresponding to the fields in a query. The idea is that when a user clicks on the "Find" button on the form, the selections they have made in the combo boxes will ms access be passed to a parameter query. I came up with the following code based on the above post: Dim db As Database Dim qd As QueryDef Dim rs As Recordset Set db = CurrentDb Set qd = db.QueryDefs("qselVariable") qd.Parameters("Manufacturer") = Forms!frmVariable!cboMFR Set rs = qd.OpenRecordset However, when I run this code I receive the following error message: Run-time error '3061': Too few parameters. Expected 20. When I click on debug, the Set rs = qd.OpenRecordset line is the ms access error line causing the error. I am using Access 97 in a windows 98 environment. Any help with this wuold be much appreciated!! jrmywvr View Public Profile Find More Posts by jrmywvr 01-08-2003, 08:49 AM #2 Elana Senior Member Join Date: Apr 2000 Location: Seattle, WA Posts: 232 Thanks: 0 Thanked 0 Times in 0 Posts I think this problem has something to do with needing to use the eval() function. I have used this code after receiving error message 3061 and it solved the issue. Try inserting this code after your "set qd" and see if this helps at all. Add this variable first: Dim prm As Parameter Then add: For Each prm In qd.Parameters prm.value = Eval(prm.Name) Next prm Good luck - hope this gets you started in the right direction. Let me know. E Elana View Public Profile Find More Posts by Elana 01-08-2003, 09:46 AM #3 jrmywvr Junior Member Join Date: Jan 2003 Location: Othello, WA Posts: 10 Thanks: 0 Thanked 0 Times in 0 Posts Well, I think that's a step in the right direction...at least now I'm getting a different error! I'm getting an "item not found in this collection" error when I don't predefine the Manufacturer parameter in the parameter list for the query. This error points to the "qd.parameters" l