Microsoft Access DLOOKUP Function

[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

[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,

[damodiggler]

CustomerID= customerID ?! .. which one of which is from what table or query ?! ... totally confusing

[timboljermaine]

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

[AutismWorks]

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

[AutismWorks]

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

[3100745]

Thank you! It helps.

[maicopr]

Great tutorial!

Thank you.

Obrigado!

[easyletgo]

nice

[sinsirful]

god bless you ))

thnx for the help!

[wobbygongman]

Thank you!

[Shahdathlete]

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

[pdedecker]

Thanks for your help. I do have a minor issue though. I've noticed that if I leave the field that triggers the automatic fill-in blank, the form generates a VBA error. How do I prevent that?

[antareing]

thanks for the great tutorial! :)

[tain3221]

Thanks!!!!!!

[untij]

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

[adlyiousz06]

i just love your tutorials!

[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.

[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.

[bpekhoul]

Richard,

You made it so easy.

Thanks for sharing.

Bo