Home > Runtime Error > Dlookup Run-time Error 3464

Dlookup Run-time Error 3464

Contents

I haven't tested it against one that isn't in the system yet. I use the query qry_Personnel_Current_Status to determine the most recent value for [CBD_Code] in relation to the [Employee ID]. 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. Text uses quotes Dates use hash marks (#) Numbers - no delimiters so your syntax should be (drop the single quotes since AccommodationID is a numeric field): Expand|Select|Wrap|Line Numbers AccommodationType=DLookup("AccommodationType","Accommodations","AccommodationID="&Me.Accommodation.Value) Share

I have tried where CCNo is both null and has a value. "ruralguy via AccessMonster.com" wrote: > Did you change > Dim CCNo As Variant > to > Dim CCNo As Tips for work-life balance when doing postdoc with two very young children and a one hour commute Should I serve jury duty when I have no respect for the judge? Your name or email address: Do you already have an account? Anyway, thanks and sorry it wasn't a very easy to describe problem.

Runtime Error 2471 Dlookup

Not the answer you're looking for? No, create an account now. Does the code now run on "....the front line comptuers running XP Pro SP3 / Office 2003 SP3"? -- Steve S -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck Run time error 3464 Type mismatch in criteria expression P: 10 daisyMay1 Hello, I am trying to fix a db that was written by someone else.

I don't know why you get the error message on some > computers but not on others, but I did find an error in the SQL statement. > > I rewrote When the form is submitted the value of the selected option is passed into the following routine: Dim valSelectedDate AsIntegerDim dateParameter AsDatevalSelectedDate = ddlDate.SelectedValuedateParameter = DateAdd("m", valSelectedDate, (Date.Now))cmdSelectEvents.Parameters("@date").Value = dateParameter When My new code is as follows: ====== CODE STARTS HERE ====== Function mcr_SafetyTimerReset() Dim dbs As Database Dim rst As DAO.Recordset Dim strSQL As String strSQL = "SELECT tbl_OrganizationMembers.OM_Timer, tbl_OrganizationMembers.OM_Expiration, tbl_OrganizationMembers.OM_UnitID, A CCNo is not > >applicable to all records, so variant was used to handle the null. > > > >> My guess is you are getting a Null in the

You are trying to > filter on a date type, but the value is text .. Otherwise I'll consider it resolved for now, and mark each of you for helpful posts. dmckie250 View Public Profile Find More Posts by dmckie250

Tags access , dlookup , form , runtime error '3464' , vba « Previous Thread | Next view publisher site View 14 Replies View Related Criteria For Date Field Causing 'data Type Mismatch' Error Jul 31, 2005 Hi,I have a query with a field defined in the query as follows:Next Bill

Time for bed.. -- Steve S -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck around.) "ruralguy via AccessMonster.com" wrote: > I would think it would resolve at run time, Already a member? If it should be a sub, I'll change it, but it's working. When the user enters the loan # into frm_CE, I want it to use Dlookup to get this and other information from tbl_GetInfo and put that into tbl_CE.

Runtime Error 2471 Access Dlookup

You are trying to > >filter on a date type, but the value is text .. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Runtime Error 2471 Dlookup I can't put a picture, title and author in the same page Incorrect method to find a tilted asymptote What is the most befitting place to drop 'H'itler bomb to score The data type for the field: "AccommodationType" is Number 3.

Post your question and get tips & solutions from a community of 418,497 IT Pros & Developers. Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Jul 2 '15 #4 reply Expert Mod 2.5K+ P: 2,543 Stewart Ross To rule out problems with your definition of keyNo simply change its definition from variant to string. Any ideas why, then, that it's falling over??

Shar Jul 2 '15 #1 Post Reply ✓ answered by Stewart Ross To rule out problems with your definition of keyNo simply change its definition from variant to string. A type mismatch normally arises when an argument of a specific type is not supplied in compatible form - e.g. If either of you have any more suggestions, I'm open to them. The answer to the important questions - Yes, the code is now working on the front line computers.

Again it works > >fine on the computer running Vista, but not on ones running XP. > > > >> Why not use the Nz() function and turn a Null into The colum RelationID comes out of an oracle table and the data type is Number. Thanks for any assistance.

Same error. > > > >> How about if you use Nz() this way? > >> CCNo = Nz(DLookup("UL_CCNo", "qry_UnitSts2", "[Unit]='" & rst.Fields(2) & "'") > >[quoted text clipped - 14

When I do this it returns the following error message:- Run-time error '3464': Data type mismatch in criteria expression Below is the first few lines of code behind this button:- Dim I > >> >> apologize for the earlier confusion. > > -- > RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro > Please post back I will try and let you know what happens. Jul 9 '15 #7 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account.

The query is: Me.cmdSelectEvents.CommandText = "SELECT eventDetails.id, eventDetails.subject, " & _"eventDetails.title, eventDetails.trainers, eventDetails.type, eventDetails.summary, " & _"eventDetails.url, eventDates.date " & _"FROM eventDates INNER JOIN eventDetails ON eventDates.id = eventDetails.id " & Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. Try importing everything into a new mdb and > >> see if that solves anything. > >[quoted text clipped - 7 lines] > >> >> >> >> >> > > >> The criteria i am applying in the query is simply <0.01.

tbl_CE is populated by the user working with a form frm_CE. Or a control on > the form is referenced. MDAC/Jet/ACE downloads .. View 3 Replies View Related Queries :: Data Type Mismatch In Criteria Error Aug 8, 2013 I am getting this error in a query.

The even stranger thing is that I do not get this error message on my machine. By joining you are opting in to receive e-mail.