32 – Macro Dlookup Functions

Click here to go to the downloads page
Please download: DbVideo32

Related Posts

1 Video, 1 Database
01 – What is MS Access
02 – Access As A Relational Database
03 – Normalization
04 – Tables A
05 – Tables B
06 – One To Many Relationships
07 – Many To Many Relationships
08 – Basic Tables
09 – Select Queries (Criteria)
10 – Select Queries (Calculated Fields)
11 – SubReports
12 – Banded Reports
13 – Embedding A Sub-Report
14 – Introduction To Macros
15 – Summary Report
16 – Select Queries (Referencing A Form)
17 – Continuous Forms
18 – Sorting a Continuous Form
19 – Filtering A Continuous Form
20 – Data Entry Forms
21 – Opening A Data Entry Form
22 – Creating Consistent Forms
23 – Creating Consistent Detailed Reports
24 – Creating Consistent Summary Reports
25 – Action Queries (Append And Delete)
26 – List Boxes
27 – Action Queries (Update)
28 – Combo Boxes
29 – Select Queries (Returning Null Values)
30 – Requery Statement
31 – Log-In Form
33 – Referencing A Control On A Form
34 – Update Queries, Temporary Variables
35 – Auto-generating a Record (No VBA)
36 – DCount Function
37 – Creating an Invoice A
38 – Creating an Invoice B
39 – Validation Rule
40 – How Access Handles Dates And Times
41 – Pivot Table
42 – Switchboard Form
43 – Styling The Database
44 – Sunken Effect On List, Combo and Text Boxes
45 – Advanced Macros 1 (Preparation)
46 – Advanced Macros 2 (Single Class)
47 – Advanced Macros 3 (Multiple Classes)
48 – Reports (Force New Page)
49 – Logging Attendance
50 – Macro Error Handling
i – Look-Up Fields
ii – Where Condition

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>