Error 3464 Dlookup
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 Rating: Display Modes 09-01-2010, 01:31 PM #1 dmckie250 Registered User Join Date: Sep 2010 Posts: 12 Thanks: 0 Thanked 0 Times in 0 Posts VBA DLookup gives Runtime Error '3464' Hi everyone, I have been struggling with this control all day - I have a form with a combo box [Employee ID] that looks up the value [Employee ID] from a table called tbl_Personnel_Details This table is linked to another table called tbl_Personnel_Status_Update which contains the field [CBD_Code]. I use the query qry_Personnel_Current_Status to determine the most recent value for [CBD_Code] in relation to the [Employee ID]. I have been trying to use the following VBA code to update the combo box [Charge_Code] with the relevant [CBD_Code] using the AfterUpdate event on [Employee ID]: Code: Private Sub Employee_ID_AfterUpdate() Dim EID, CBD As String EID = Me.Employee_ID.Value 'update charge code with employee's current CBD Code CBD = DLookup("[CBD_Code]", "qry_Personnel_Current_Status", "[Employee ID] = " & EID) Me.Charge_Code.Value = CBD End Sub Whenever I try to run it I get a message saying either "Runtime Error '2001' - you cancelled the previous event" or "Runtime Error '3464' - data type mismatch". I have tried changing the query that it is getting the value for [Employee ID] from and it works fine (although it gives me a different value so this is not suitable). I have also used the correct query with different criteria (I used a field called [Equipment #]) and it works fine. the Employee ID field is a text field. Does anyone have any suggestions why its not working? Or a better way to update the field [Charge_Code] with the CBD_Code that is associated with the selected Employee ID? Thanks, Duncan dmckie250 View Public Profile Find More Posts by dmckie250 09-01-2010, 01:37 PM #2 missinglinq AWF VIP Join Date: Jun 2003 Location: Richmond (Virginia that is!) Posts: 5,649 Thanks: 11 Thanked 552 Times in 522 Posts Re: VBA DLookup gives Runtime Error '3464' If Employee ID is Text the syntax would be "[Employee ID] = '" & EID & "'" Linq ;0)> __________________ The Devil's in the Details! To view li
- WVSP, Jun 28, 2008. Scott Whetsell, A.S. - WVSP Guest Using the code below, I am getting Error 3464 on the line that looks up the CCNo value. The code works fine on my computer running Vista SP1 / Office 2003 SP3 but will not run on the front line comptuers running XP Pro SP3 / Office 2003 SP3. ====== CODE STARTS HERE ====== Function mcr_SafetyTimerReset() Dim dbs As Database Dim rst As DAO.Recordset Dim strSQL As String http://www.access-programmers.co.uk/forums/showthread.php?t=198381 strSQL = "SELECT tbl_OrganizationMembers.OM_Timer, tbl_OrganizationMembers.OM_Expiration, tbl_OrganizationMembers.OM_UnitID " & _ "FROM tbl_OrganizationMembers " & _ "WHERE (((tbl_OrganizationMembers.OM_Timer) = ""ON"") And ((tbl_OrganizationMembers.OM_Expiration) <= Now())) " & _ "ORDER BY tbl_OrganizationMembers.OM_Expiration" Set dbs = CurrentDb Set rst = dbs.OpenRecordset(strSQL) If rst.EOF = True Then GoTo Exit_Function_STR Dim CCNo As Variant Dim EVCD As Variant Dim UNIT As String UNIT = Nz(DLookup("AssignedUnit", http://www.pcreview.co.uk/threads/dlookup-returns-error-3464-data-type-mismatch-in-criteria-expres.3553200/ "qry_AssignedUnit", "[OM_UnitID]='" & rst.Fields(2) & "'"), rst.Fields(2)) CCNo = DLookup("UL_CCNo", "qry_UnitSts2", "[Unit]='" & rst.Fields(2) & "'") '<--- EVCD = DLookup("EventCode", "tbl_CCNo", "[CCNo]='" & CCNo & "'") Call unitLog(CCNo, UNIT, "10-4", "10-50", EVCD) Exit_Function_STR: Set dbs = Nothing Set rst = Nothing Exit Function End Function ====== CODE ENDS HERE====== Code fails on line indicated with '<--- Fields Defined: OM_Timer Text "ON" / "OFF" / "" Values only OM_Expiration Date/Time yyyy-mm-dd hh:nn:ss OM_UnitID Text 3 - 6 AlphaNumeric Characters incl hyphens EVENTCODE Text 3 - 6 AlphaNumeric Characters CCNo fields Text 11 Characters formatted yyyy-000000 AssignedUnit Text 3 - 50 AlphaNumeric Chars incl hypens and space This function is in an Autokeys module. The recordset generally will not have more than one record at a time, but if there is, it should select the oldest record first. unitLog is another function which should have no effect on this function. Thanks for any assistance. Scott Whetsell, A.S. - WVSP, Jun 28, 2008 #1 Advertisements Scott Whetsell, A.S. - WVSP Guest Re: DLookup returns Err
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of http://www.tek-tips.com/viewthread.cfm?qid=1698214 ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining http://dlookup.runtime.error.3464.cl-xml.org/ you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link error 3464 To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Forms Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Forms Forum DlookUp Run Time Error 3464 thread702-1698214 Forum Search FAQs Links MVPs DlookUp Run Time Error 3464 DlookUp Run error 3464 dlookup Time Error 3464 DraGo150 (IS/IT--Management) (OP) 14 Nov 12 11:19 Hello, trying to understand what I am doing wrong. I have a DLookup to search the table for duplicate records before update, but it keeps producing an error. Any help would be appreciated. Private Sub DOB_LostFocus() If (Not IsNull(DLookup("[LastName]", _ "tbl_Client", "[LastName] ='" _ & Me!LastName & "'"))) Then If (Not IsNull(DLookup("[FirstName]", _ "tbl_Client", "[FirstName] ='" _ & Me!FirstName & "'"))) Then If (Not IsNull(DLookup("[DOB]", _ "tbl_Client", "[DOB] ='" _ & Me!DOB & "'"))) Then Else MsgBox "Name has already been entered in the database." Cancel = True Me.Undo Dim strDocName As String strDocName = "rpt_ClientSearch" DoCmd.OpenReport strDocName, acViewReport End If End If End If End Sub RE: DlookUp Run Time Error 3464 PHV (MIS) 14 Nov 12 12:01 Replace this: "tbl_Client", "[DOB] ='" _ & Me!DOB & "'"))) Then with this: "tbl_Client", "[DOB] =#" _ & Format(Me!DOB, "yyyy-mm-dd") & "#"))) Then Hope This Helps, PH. FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions? FAQ181-2886: How can I maximize my chances of getting an ans
Runtime Error 3464) Repair Tool Step 2: Click the "Scan" button Step 3: Click 'Fix All' and you're done! Compatibility: Windows 7, 8, Vista, XP Download Size: 6MB Requirements: 300 MHz Processor, 256 MB Ram, 22 MB HDD Limitations: This download is a free evaluation version. To unlock all features and tools, a purchase is required. Dlookup Runtime Error 3464 Error Codes are caused in one way or another by misconfigured system files in your windows operating system. If you have Dlookup Runtime Error 3464 errors then we strongly recommend that you Download (Dlookup Runtime Error 3464) Repair Tool. This article contains information that shows you how to fix Dlookup Runtime Error 3464 both (manually) and (automatically) , In addition, this article will help you troubleshoot some common error messages related to Dlookup Runtime Error 3464 error code that you may receive. Note: This article was updated on 2016-10-03 and previously published under WIKI_Q210794 Contents 1.What is Dlookup Runtime Error 3464 error? 2.What causes Dlookup Runtime Error 3464 error? 3.How to easily fix Dlookup Runtime Error 3464 errors What is Dlookup Runtime Error 3464 error? The Dlookup Runtime Error 3464 error is the Hexadecimal format of the error caused. This is common error code format used by windows and other windows compatible software and driver vendors. This code is used by the vendor to identify the error caused. This Dlookup Runtime Error 3464 error code has a numeric error number and a technical description. In some cases the error may have more parameters in Dlookup Runtime Error 3464 format .This additional hexadecimal code are the address of the memory locations where the instruction(s) was loaded at the time of the error. What causes Dlookup Runtime Error 3464 error? The Dlookup Runtime Error 3464 error may be caused by windows system files damage. The corrupted system files entries can be a real threat to the well being of your computer. There can be many events which may have resulted