<

MS Access – Using DLookup

Posted on
8,267 Points
1,967 Views
3 Endorsements
Last Modified:
Published
Experience Level: Beginner
7:22
Jim Dettman (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
0 Comments
Pseudo random numbers are right at hand in VBA. Obtaining truly random numbers, however, requires an external source. One is the Swiss Quantis QRNG Chip. The output from one of these has been made public by ETH Zürich, and here we present a complete…
This is a rather simple but effective way of searching while typing on a Microsoft Access Combobox.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month