Microsoft Access DLOOKUP Function

[@untij]

this tutorial literally saved my life. well, not literally.

[@montimial]

Thank you, this is the most useful DLookup guide on youtube , I got it immediately contrary to trying with some other tutorials ,this one is concise and to the point

[@timboljermaine]

5:20 i understand it now when you said the functions of each inside the dlookup! Great tutorial thanks!

[@Shahdathlete]

you have done a wonderful job. you really are helping me out. so nice of you. thanks!

[@jgposner]

Where's my comment. I had more to say. May be it goes to you for approval. The continued part was that I also had to put a single quote after the = in the criteria part of the function. Thanks for the help. I subscribed to you and look forward to viewing more of your videos.

[@599CD]

Your DLOOKUP statement looks correct. I assume you have a CustomerID on the current form/query. Make sure that value isn't NULL.

[@599CD]

Assuming you don't have everything on one line as you posted it there, your code looks fine to me. I'd need to see your database to tell you for sure what the problem is.

[@599CD]

How are you getting the data? You need some way to look it up - either a combo box or a text box that you type an ID of some kind into. When you do that, make a button that pulls in the rest of the data using DLOOKUP. Without knowing a lot more about exactly what you're trying to accomplish, it's difficult for me to help you further.

[@bpekhoul]

Richard, You made it so easy. Thanks for sharing. Bo

[@autismworks5929]

What is the 301 tutorial? Searched the entire chanenl and found nothing.

[@thinnairr]

This helped a lot, even with access 2010

[@599CD]

I don't understand what you're trying to do. Can you elaborate, please?

[@599CD]

A "please" would be nice. I don't know your field data types, so you probably want either one of these: DLookUp("[Name]","CustomerT","T­INNo =" & [TINNo]) or DLookUp("[Name]","CustomerT","T­INNo=""" & [TINNo] & """") You're welcome.

[@chiungkokuo]

Hi Ben, Thanks for the video. I copy the way did. It does not work. I do not know where go wrong. Would you please give me more tips. Thanks. Joan

[@autismworks5929]

How do I know what the identifier is for the field to use as the address= or city= for example?

[@599CD]

Well, it looks like you spelled CUSTOMERS wrong, and if TINNo is a string value, you'll need to add some quotes. Plus I don't recommend using "NAME" as a field name. It's a reserved word in Access, so you'd need to enclose it in square brackets everywhere.

[@conquer12]

Hi, I need to know about de function select of access How can I use it? Please create a video, For example i want to link two table with the same titule,

[@599CD]

If you're trying to DLOOKUP a value with TEXT as your criteria, you must enclose the criteria in quotes: MyAge = DLOOKUP("Age","CustomerT","CustomerName=""" & CustName & """")

[@SirEmbrooos]

Thanks but what if im looking a value depending of two different fields on a form like look up x where Y and z = y and z

[@599CD]

Then use an AND condition in your criteria.

[@markcarino1294]

Nice tutorial sir, I learned alot :) I have a question sir, is DLOOKUP will function in image or attachment thanks

[@MsDiDi159]

Dear Sir, does DLookup change the values of the address,City,State feilds in the CallService table ?? thanks

[@jgposner]

My first coment was lost so I am rewriting it. I followed you instructions substituting your info for mine and got "Syntax error (missing operator) in query expression 'Category=Black to normal'." I fixed it by putting single quotes around the value being looked up. It now reads like this. Issue = DLookup("Description", "Category", "Category='" & Category & "'") There is a singe quote after Category= The end of the line reads double quote, single quote, double quote, parentheses.

[@iProRyan]

OMG THANK YOU SO MUCH!!! YOU HAVE LITERALLY SAVED MY LIFE! :D

[@wawanst3334]

Hi, sir thx for your sharing. But in my test that is just for numeric data type only, how about data text, thx

[@599CD]

Good point. They're all treated differently. Text requires quotes, and dates have to be enclosed in # signs. Feel free to submit this at 599cd.com/TechHelp and maybe you'll get a video about it. :)

[@599CD]

You're missing a single quote right after the equal sign: DLookup("InvoiceAmount", "InvoiceT", "InvoiceNumber='" & InvoiceNumber & "'") You can also try double-double quotes: DLookup("InvoiceAmount", "InvoiceT", "InvoiceNumber=""" & InvoiceNumber & """")

[@steveo9211]

Hello Sir, Is there a way to auto populate data into a table with data from another table without making a combo box. I trying to create a database for rental equipment and I am trying to create a rental history table. I'm trying to make it where you don't have to input any data into this table. I couldn’t get the DLookup function to work, not even sure it is the right function for the job. Any input would be great. Thanks, Steve O.

[@bwanampishi3586]

Hi. Can I use DLOOKUP to grab data from a query field and have that data appear in a field in a table? The field in question is "UniqueID". UniqueID is a query field which I programmed telling the query to combine data from several existing table fields (DOB, race, sex, schoolID). I want this UniqueID to appear as a field in the table where DOB, race, sex and schoolID came from...

[@jennylenesmith-drayton8677]

Amazing. I never knew u could do that. Thanks again

[@599CD]

Welcome

[@husy143]

im sorri sir, but i dont know what im going wrong here.. can i send u my database..?? so that u can check it for me please please

[@Stache987]

"Or more importantly, if the customer ...", is addressed where ? this would involve a multi-address lookup, say work location, summer home, subsequent address..

[@599CD]

Sure. I recommend if you need multiple addresses to store them in a 2nd related table.

[@Initial_Gain]

Strong sound 👍

[@599CD]

WHAT? I CAN'T HEAR YOU!? LOL

[@MrShagoon69]

I get the error "Variable not defined", any help on that?, I copied the exact code as you have in the video, changed according to my values Private Sub ProductName_AfterUpdate() Price = DLookup("UnitPrice", "Products", "ProductID =" & ProductID) End Sub

[@KeebasLife]

You my friend are the, BOMB! Great videos!

[@sumana9864]

Hi Sir, I wanted to learn how to create voting forms for my ICT exam and was wondering if you could help me?

[@599CD]

Probably kinda late now, eh?

[@lonniekizer715]

Thank you, the text version listed below helped me use dlookup for the first time! But I am having trouble using the dlookup inside a nested if/then/else statement. My if then works fine, but returns blanks with anything other than "S/E" checkbox. =IIf([selfedge]=Yes,"S/E",IIf([KITCHEN]=Yes,DLookup("Kitchen","tblEdgeProfile","Edge=""" & [Edge] & """"),IIf([VANITY]=Yes,DLookup("Vanity","tblEdgeProfile","Edge=""" & [Edge] & """"),IIf([BAR]=Yes,DLookup("Bar","tblEdgeProfile","Edge=""" & [Edge] & """"),IIf([FLAT]=Yes,DLookup("flat","tblEdgeProfile","Edge=""" & [Edge] & """"),""))))) appreciate any thoughts here.

[@599CD]

Simplify it.

[@Chalbuilder2012]

Very userful. many thanks for that

[@SPGaur-ps4jx]

Sir I have multiple data in access or excel. I want to create search button for lookup In all databases via enter multiple I'd and I want to receive multiple results in one file How can I do for above process plz suggest database is very big

[@599CD]

Huh?

[@599CD]

Thanks!

[@3100745]

Thank you! It helps.

[@dulalmandal8282]

I can't Successfully run the formula with ms office 2016 . Do there any valid reason for office 2016 .Though I have no confidence with me.

[@599CD]

I guarantee you that DLOOKUP has worked in every version of Access going back at least as far as I can remember, and of course in 2016 and 2019. It's one of the most popular functions.

[@husy143]

Can u tell me what im doing wrong: =DLookUp("Name","CutomersT","TINNo =" & [TINNo])

[@maicopr]

Great tutorial! Thank you. Obrigado!

[@ThousanWhite]

This didn't work for me when I tried to run it

[@SadiqAliSheikh21]

Price=Dlookup("[Price]","PrdctTable", "[PrdctNme]=[forms]![urFormName]![PrdctNme]") Price is field wch u wnt 2 updte ie ur field from ur form Dlookup is funciton, [Price] is from tbl frm wher u wnt 2 cpy vlue to ProdctTbl is the name of the table from wher u wnt get the values to ur form [Prdct_Name] is the vlue from table wher u get values from [forms]![urformname]![PrdctName] is the feild which u selct prduct name from ur frm n the price field will be updtd like VLOOKUP IN EXCEL,

[@randypaul7563]

Hi - Can the ID being looked up be alpha numeric? Regards

[@599CD]

Sure

[@imodem]

good day sir, a little help if you may. ive created a table with 2 fields, namely: names and address. ive created another table with fields names, address1 and address2. i followed your video re dlookup, but failed to transfer the address to its new location from 1st table to 2nd table. here's the code: Private Sub Combo7_AfterUpdate() add = DLookup("add", "names", "add =" & add) End Sub

[@jrvicenio]

Error Message on this, Contact = DLookup("supcontact", "suppliersdata", "id=" & Supplier)

[@599CD]

Jhun Vicenio Your syntax looks OK to me. What's the error message?

[@ShefiyullaMI]

Thanks a lot dear

[@wobbygongman]

Thank you!

[@antareing]

thanks for the great tutorial! :)

[@moyomartin4501]

please i have a subform with a look up filed that displays a list of items with coressponding prices ,buh i want to filter it basing on another field value dynamically,is thea anyway i can do tht,if so plse can smeone help..thx in advance

[@599CD]

I'm very sorry for taking so long to reply to your comment. I wasn't very good at keeping up with the comments 4 years ago, but I've been trying to make an effort to get back to everyone. If you still need help with this problem, please feel free to submit your question on my web site at 599cd.com/TH.

[@parklange_fx3080]

how to link Price and Item or Service...? Sorry with my grammar mistakes..I'm good in English...!!!!

[@599CD]

599cd.com/Invoicing

[@receipt.mug.shirtagsaludpr2752]

What if my command in event procedure is debug what would i do? The message error is "Syntax error (missing operator) in query expression Outs = DLookup ("Outs", "Product", "Size=" & Size)

[@599CD]

+receipt.mug.shirt agsalud printing The syntax of your statement looks fine to me. Of course, I can't tell the CONTEXT of it without knowing more.

[@israelmcculley2927]

I get the same error message. My code is this: Me.txtPhoneNumber = DLookup("PhoneNumber", "Customers", "ID=" & ID)

[@599CD]

Nope. DLOOKUP does not change any values. It simply looks them up for you.

[@inducto]

god bless you )) thnx for the help!

[@TheRiaz54800]

Sir What is meaning of & ?

[@599CD]

You mean the ampersand? 599cd.com/Concatenation

[@Theburqan]

It still not working with me, the error #name? still appears. i checked all the names of the feilds

[@599CD]

Well, since you spelled "fields" wrong, I'll bet you spelled the field name wrong.

[@husy143]

can u type the correct formula..!!!

[@nonsookafor722]

how do i autocomplete using text box and not combo box

[@599CD]

+nonso okafor You can't without programming

[@RafaelDuarteGago]

Perfect tuto mate, it helped me a lot :D Like + sub

[@599CD]

My pleasure

[@mostafas2604]

شكرا thank you

[@599CD]

Welcome

[@brandyschuerman7160]

the volume is not working on your videos

[@599CD]

It's working for the other 37 MILLION views I've received. Sure it's not your PC?

[@tain3221]

Thanks!!!!!!

[@599CD]

You can send it to me here: 599CD(dot)COM/TechHelp

[@kiranideal]

It only work for first record

[@599CD]

DLookup only returns one record at a time.

[@kostasdrosatos329]

still nothing ... :-(

[@standman007]

That was easy

[@599CD]

Indeed! :)

[@RickyRisnandar]

nice

[@IskeSRB]

Saviour!!!

[@funniq]

Great tut... thanks