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
0 Comments
Suggested Videos
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Hashing.
Suggested Courses
Next Video:How To Make a Graph with Microsoft Access