<

MS Access – Using DLookup

Posted on
7,879 Points
1,579 Views
3 Endorsements
Last Modified:
Experience Level: Beginner
7:24
Jim Dettman (Microsoft MVP/ EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.

Video Steps

1. Specify the first argument, which is the expression to be returned

2. Specify the second argument, which is the data source. This may be a table or query

3. Specify the third argument, which is the criteria

4. How to return multiple fields from a single DLookup()

5. Pitfalls to avoid

3
Comment
0 Comments

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
It is not that simple from VBA to display a compressed help file as it should be. API calls and a few tricks are needed. This demo and full code will show you how.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month