fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
Home » Posts tagged "access dlookup"

Tag Archives: access dlookup

Access DLookup Function: Why You May Need To Apply This Function


Using the Access DLookup function may be called upon where users need to output a value from other data sources (i.e. tables or queries) where there is no direct relationship. Hang on a moment! I though Microsoft Access was a relational database system (RDBMS) so why calculate to connect to a value? Yes it is an RDBMS but depending on how the database was designed and built or if you had inherited an Access database this could well mean having […]

Tags: , , , ,

Microsoft Access Database: Access DLookup Function Example with Access VBA


Microsoft Access Database

Take a look at this six and half minute video of how to utilise the Access DLookup function using a little of Access VBA code too (not too difficult but necessary in this example). Microsoft Access Database: Access DLookup Function Example with Access VBA Of course you do not have to use Access VBA code when applying the Access DLookup function. Instead, you can populate fields by using a calculation or auto-lookup query instead. With the calculation method however, this […]

Tags: , , , , ,