{"id":64549,"date":"2019-04-02T12:33:42","date_gmt":"2019-04-02T12:33:42","guid":{"rendered":"http:\/\/www.accessrepairnrecovery.com\/blog\/?p=64549"},"modified":"2021-08-02T06:29:02","modified_gmt":"2021-08-02T06:29:02","slug":"ways-to-use-ms-access-dlookup-function","status":"publish","type":"post","link":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function","title":{"rendered":"7 Ways To Use MS Access DLookup( ) Function That You Can&#8217;t Miss&#8230;!"},"content":{"rendered":"<div class=\"8e1a49907eb0ebe2b39ac6355e555698\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong><em>Have you heard off or ever tried Access Database DLookup\u00a0function? Want to know about this Access Database DLookup\u00a0function more?<\/em> <\/strong>Then in that case you are at the correct platform.<\/p>\n<p style=\"text-align: justify;\">This tutorial is written with the main perspective of providing you with complete information on <strong>MS Access Dlookup Function<\/strong> and mainly focuses on <strong>how to use dlookup in Access<\/strong>.<!--more--><\/p>\n<div style='margin: 10px 0; clear: both;'><div style='clear: both; border-top: 1px solid #eeeeee; border-bottom: 1px solid #eeeeee; margin: 30px auto; padding: 15px 15px 15px 20px; display: flex; align-items: center; justify-content: space-between;'><div style='margin-bottom: 0; line-height: 1.6; flex-shrink: 1;'><span style='color:#aaa; font-size: 13px;'>Rated <i>Excellent<\/i> on <a rel='nofollow' target='_blank' href='https:\/\/www.trustpilot.com\/review\/www.stellarinfo.com'><span style='color: #aaa;'>Trustpilot<\/span><\/a><\/span><br><strong>Free MS Access Database Repair Tool<\/strong><br>Repair corrupt MDB and ACCDB database files and recover deleted database tables, queries, indexes and records easily. Try Now!<br><div style='margin-top: 5px;'><a style='background: #b10923; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 16px; font-weight: 500; padding: 0 16px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'><span style='color: #ffffff;'><i class='fas fa-arrow-alt-circle-down'><\/i><\/span> Download<\/a><br><span style='font-style: italic; display: block; font-size: 10px; margin-top: 10px;'>By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the <a href='https:\/\/www.accessrepairnrecovery.com\/eula.php' target='_blank'>End User License Agreement<\/a> and <a href='https:\/\/www.accessrepairnrecovery.com\/privacy-policy.php' target='_blank'>Privacy Policy<\/a> of this site.<\/span><\/div><\/div><\/div><\/div>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>What\u2019s This Access Dlookup Function Is?<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-64034\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2017\/10\/74.jpg\" alt=\"What\u2019s This Access Dlookup Function Is\" width=\"387\" height=\"241\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2017\/10\/74.jpg 700w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2017\/10\/74-300x187.jpg 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/p>\n<p style=\"text-align: justify;\">Microsoft Access application has a powerful data handling package with many strong functions to make data extraction like work in an easy way. From this vast collection of <strong>MS Access DLookup function<\/strong>, is the most workful one.<\/p>\n<p style=\"text-align: justify;\">In<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/access.application.dlookup\" rel=\"nofollow\"><strong> MS Access application DLookup\u00a0function<\/strong><\/a> is used to get the value of a particular field from a specified set of records (a domain). You can use this DLookup function in <strong>Visual Basic for Applications (VBA) module<\/strong>, a query expression, a macro, or a calculated control on a form or report.<\/p>\n<p style=\"text-align: justify;\">This function is best to retrieve the value of a particular field from a domain. Here domain can be a specified set of records from table, query, or SQL expression. One can use this<strong>\u00a0<\/strong><strong>DLookup<\/strong> function to display the value of fields which are not present in the underlying recordset.<\/p>\n<p style=\"text-align: justify;\"><strong>For example:<\/strong><\/p>\n<p style=\"text-align: justify;\">Suppose you have a form on <strong>Order Details<\/strong> table. The form will display <strong>Quantity, OrderID, ProductID, UnitPrice, and Discount fields<\/strong>. However, in the product table <strong>\u201cProductName field\u201d<\/strong> is present. In this case, you can use <strong>DLookup<\/strong>\u00a0function in calculated control to display the <strong>ProductName<\/strong> on the same form.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>MS Access DLookup Function Examples<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64562\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/MastersDegree.png\" alt=\"DLookup Function Examples\" width=\"1600\" height=\"800\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/MastersDegree.png 1600w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/MastersDegree-300x150.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/MastersDegree-768x384.png 768w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/MastersDegree-1024x512.png 1024w\" sizes=\"auto, (max-width: 1600px) 100vw, 1600px\" \/><\/p>\n<p style=\"text-align: justify;\">Dim newvar as variant<\/p>\n<p style=\"text-align: justify;\"><em><strong>Newvar = DLookup(&#8220;[student name]&#8221;,&#8221;studentmaster&#8221;,&#8221;[rollno]=1001&#8243;)<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\">From the above example extracts the data from the field [student name] from the table studentmaster for roll number 1001.<\/p>\n<p style=\"text-align: justify;\">Check what will happen if the DLookup function were given without any criteria.<\/p>\n<p style=\"text-align: justify;\"><em><strong>Newvar = DLookup(&#8220;[student name]&#8221;,&#8221;studentmaster&#8221;)<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\">The above code will return data in the field [student name] from the first record of the table studentmaster.<\/p>\n<p style=\"text-align: justify;\">You can use variables in the criteria too. For instance, a form field can be used like&lt;condition&gt;<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><em><strong>You may also like:<\/strong><\/em><\/p>\n<p style=\"text-align: center;\"><strong><a class=\"row-title\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/how-to-create-form-in-access-database\" aria-label=\"\u201cLearn 5 Different Ways To Create Forms In Microsoft Access Database \u2026!\u201d (Edit)\"><em><strong>Learn 5 Different Ways To Create Forms In Microsoft Access Database \u2026!<\/strong><\/em><\/a><\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><em><strong>Newvar = DLookup(&#8220;[student name]&#8221;,&#8221;studentmaster&#8221;,&#8221;[rollno]=Form![rollno]&#8221;)<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\">This will help in comparing the data in [student name] field from the table studentmaster with the one that is in the [rollno] field of the current form.<\/p>\n<p style=\"text-align: justify;\">In order to specify textual criteria which is from a field on a form include the single quotes.<\/p>\n<p style=\"text-align: justify;\"><em><strong>Nvar = DLookup(&#8220;[rollno]&#8221;,&#8221;studentmaster&#8221;,<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>&#8220;[student name]=\u2019 &#8221; &amp; Forms![Marks]![student name] &amp; &#8221; &#8216; &#8220;)<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\">Overall, the moral of the story is <a href=\"https:\/\/support.office.com\/en-us\/article\/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937\" target=\"blank\" rel=\"nofollow noopener noreferrer\"><strong>Access DLookup<\/strong><\/a> is used as an expression in MS Access query or calculated field in form to retrieve foreign values. Well, you can use this also in the Criteria field of the query builder. \u00a0That\u2019s the reason why it is more efficient to make a new query having fields of both tables and use it as base recordset.<\/p>\n<p style=\"text-align: justify;\"><strong>Access DLookup <\/strong>chooses the saved records of the domain.\u00a0 Another unsaved record is not included in the domain.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Microsoft Access DLookup Function Syntax:<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-64564\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/24-512.png\" alt=\"Microsoft Access Dlookup Function Syntax\" width=\"307\" height=\"307\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/24-512.png 512w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/24-512-150x150.png 150w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/24-512-300x300.png 300w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/24-512-65x65.png 65w\" sizes=\"auto, (max-width: 307px) 100vw, 307px\" \/><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em><strong>DLookup(<\/strong>\u00a0<strong>expr, domain\u00a0<\/strong>[<strong>, criteria<\/strong>]\u00a0<strong>)<\/strong><\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">The\u00a0<strong>DLookup<\/strong>\u00a0function syntax has these arguments:<\/p>\n<h3 style=\"text-align: justify;\"><strong>Expr:<\/strong><\/h3>\n<p style=\"text-align: justify;\">The Expression part identifies the field whose value you want to return. This can be a string expression to identify a field in table or query or it can be an expression that performs a calculation on the field data.<\/p>\n<p style=\"text-align: justify;\">In the <strong>DLookup Access<\/strong> Function Syntax\u2019s expression part, you can include name of the field in a table, control or form, constant or function. If this part includes any function then it can be either user-defined or built-in but not SQL aggregate function or any other domain aggregate function.<\/p>\n<h3 style=\"text-align: justify;\"><strong>Domain<\/strong><\/h3>\n<p style=\"text-align: justify;\">String expression which identifies the set of records constitutes the domain portion of the <strong>Access DLookup Function Syntax.<\/strong> It can be a table name or a query name for the query that doesn\u2019t need any parameter.<\/p>\n<h3 style=\"text-align: justify;\"><strong>Criteria<\/strong><\/h3>\n<p style=\"text-align: justify;\">A string expression used to limit the range of data on which DLookup function is performed. Suppose, criteria is equivalent to WHERE clause in SQL expression, without using the word WHERE. If criteria are not mentioned then the DLookup function will be applied over the entire domain. Any field which is included in criteria must be a field in domain otherwise, the function will return a NULL value.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>Have a look:<\/strong><\/p>\n<p style=\"text-align: center;\"><strong><a class=\"row-title\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/microsoft-access-vba-code\" aria-label=\"\u201cLearn All About Microsoft Access VBA Code \u2013 VBA Functions, Shortcuts And Much More\u2026!\u201d (Edit)\"><strong>Learn All About Microsoft Access VBA Code \u2013 VBA Functions, Shortcuts And Much More\u2026!<\/strong><\/a><\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>Access database DLookup() function<\/strong> returns a single value from a single field. If no record matches the criteria or if the domain is empty DLookup() function will return a Null value. \u00a0If more than one record matches the criteria, then in that case DLookup will return the first instance of that &lt;fieldname&gt;.<\/p>\n<p style=\"text-align: justify;\">So, criteria should be defined carefully in order to get a unique field from the DLookup function. If your criteria filed is text then keep that text in single quotation marks.<\/p>\n<p style=\"text-align: justify;\">To calculate date or time values, enclose time, or data value in number signs (#).<\/p>\n<h2 style=\"text-align: left;\"><span style=\"text-decoration: underline;\"><strong>How To Use DLookup() Function In Access?<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64561\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/How-To-Use-DlookupFunction.png\" alt=\"How To Use Dlookup Function\" width=\"750\" height=\"400\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/How-To-Use-DlookupFunction.png 750w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/How-To-Use-DlookupFunction-300x160.png 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/p>\n<p style=\"text-align: justify;\">Here are the following circumstances explained to learn briefly about how to use Dlookup() Function in Access.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>1# DLookup on Empty Data Record<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">If you apply the<strong> Access DLookup function<\/strong> over the table or query that does contain any records then it will show an error message stating <strong>\u201cInvalid Use of Null\u201d<\/strong>. This happens because you are attempting to assign a null value to the variable strX.<\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Dim strX As String<\/em><\/p>\n<p style=\"text-align: justify;\"><em>strX = DLookup(&#8220;HolidayDate&#8221;, &#8220;tblHolidays&#8221;)<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Me.txtResult = strX<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64552\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-on-Empty-Data-Record.png\" alt=\"\" width=\"300\" height=\"174\" \/><\/p>\n<p style=\"text-align: justify;\">In order to avoid this error message, you can make use of the IF statement to check whether there is a record found before allotting the result value to the strX.<\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Correct Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Private Sub Command0_Click()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Dim strX As String<\/em><\/p>\n<p style=\"text-align: justify;\"><em>If IsNull(DLookup(&#8220;HolidayDate&#8221;, &#8220;tblHolidays&#8221;)) Then<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 MsgBox &#8220;No Record Found&#8221;\u00a0 \u2018 or do something<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Else<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 strX = DLookup(&#8220;HolidayDate&#8221;, &#8220;tblHolidays&#8221;)<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Me.txtResult = strX<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End If<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64553\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-on-Empty-Data-Record2.png\" alt=\"\" width=\"300\" height=\"239\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>2# DLookup with Textual Criteria<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">When you use the sign of equality in the code \u201c[UserLoginID] = \u2018John\u2019\u201d, only the record having the entire User Name\u00a0 = \u201cJohn\u201d will appear as a result of this criteria.<\/p>\n<p style=\"text-align: justify;\">The result will be displayed as \u201cNo Record Found\u201d because there is no record with the user name \u201cJohn\u201d, but there are records for \u201cJohn Smith\u201d or \u201cJohn Vang\u201d.<\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Private Sub Command0_Click()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>If IsNull(DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[User Name] = &#8216;john'&#8221;)) Then<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Me.txtResult = &#8220;No Record Found&#8221;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Else<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Me.txtUserName = DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[User Name] = &#8216;john'&#8221;)<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End If<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>3# DLookup without Criteria<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Well, it is the simplest way to use DLookup() function; i.e without specifying any criteria. In this case, the DLookup function will give you the value of the first record in the CustomerName field from tbl_Customer table.<\/p>\n<p style=\"text-align: justify;\">So, the output will be \u201cBarney Rubble\u201d because it is the first record on tbl_Customer table as shown in the below figure.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-64560\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-without-Criteria.png\" alt=\"\" width=\"397\" height=\"205\" \/><\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: left;\">Private Sub Command0_Click()<\/p>\n<p style=\"text-align: left;\">Dim strX As String<\/p>\n<p style=\"text-align: left;\">strX = DLookup(&#8220;CustomerName&#8221;, &#8220;tbl_customer&#8221;)<\/p>\n<p style=\"text-align: left;\">Me.txtResult = strX<\/p>\n<p style=\"text-align: left;\">End Sub<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64568\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/result-no-criteria-300x104.png\" alt=\"DLookup without Criteria\" width=\"300\" height=\"104\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>4# DLookup with a Numeric Criteria that comes from the field on current Form<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">The code \u201c[UserID] = Me.txtUserID\u201d is used here as numeric criteria for <strong>DLookup in Access<\/strong> function.\u00a0 This will show the output \u201cJohn Vang\u201d because the UserID 3 is for the User Name \u201cJohn Vang\u201d as per the tblUser table shown above.<\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Private Sub cmdGetResult_Click()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Me.Refresh<\/em><\/p>\n<p style=\"text-align: justify;\"><em>If IsNull(Me.txtUserID) Then<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 MsgBox &#8220;Please enter a UserID&#8221;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Else<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 If IsNull(DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[UserID] = &#8221; &amp; Me.txtUserID)) Then<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Me.txtUserName = &#8220;No Record Found&#8221;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Else<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Me.txtUserName = DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[UserID] = &#8221; &amp; Me.txtUserID)<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 End If<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End If<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<p style=\"text-align: justify;\"><em>number user id from current form<\/em><\/p>\n<p style=\"text-align: center;\"><em><strong>DON&#8217;T MISS IT:<\/strong><\/em><\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/complete-information-about-ms-access-pivot-table\"><strong><em>How To Create Pivot Table In MS Access And Resolve It\u2019s Related Issue<\/em><\/strong><\/a><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>5# DLookup with Textual Criteria that comes from a Field on Current Form<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">The code \u201c[UserLoginID] = \u2018\u201d &amp; Me.txtLoginID &amp; \u201c\u2018\u201d is used as criteria for DLookup Access function.<\/p>\n<p style=\"text-align: justify;\">Suppose, you want to get the user name for the entered UserLoginID on text box UserLoginID on this form then show it over the User Name text box.<\/p>\n<p style=\"text-align: justify;\">It\u2019s wrong if on the text box UserLoginID you enter jvang, the User Name should be \u201cJohn Vang\u201d. Here two IF Statements are used for this code to check whether the UserLoginID is entered or not and also to avoid error if User Name is left empty for the entered UserLoginID.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64558\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-with-Textual-Criteria-that-comes-from-a-Field-on-Current-Form.png\" alt=\"\" width=\"300\" height=\"173\" \/><\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: left;\"><em>Private Sub cmdGetResult_Click()<\/em><\/p>\n<p style=\"text-align: left;\"><em>Me.Refresh<\/em><\/p>\n<p style=\"text-align: left;\"><em>If IsNull(Me.txtLoginID) Then<\/em><\/p>\n<p style=\"text-align: left;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox &#8220;Please enter a UserLoginID&#8221;<\/em><\/p>\n<p style=\"text-align: left;\"><em>Else<\/em><\/p>\n<p style=\"text-align: left;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0 If IsNull(DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[UserLoginID] = &#8216;&#8221; &amp; Me.txtLoginID &amp; &#8220;&#8216;&#8221;)) Then<\/em><\/p>\n<p style=\"text-align: left;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox &#8220;No User Name for this UserLoginID&#8221;<\/em><\/p>\n<p style=\"text-align: left;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0 Else<\/em><\/p>\n<p style=\"text-align: left;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Me.txtUserName = DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[UserLoginID] = &#8216;&#8221; &amp; Me.txtLoginID &amp; &#8220;&#8216;&#8221;)<\/em><\/p>\n<p style=\"text-align: left;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0 End If<\/em><\/p>\n<p style=\"text-align: left;\"><em>End If<\/em><\/p>\n<p style=\"text-align: left;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64556\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-with-a-Numeric-Criteria-that-comes-from-the-field-on-current-Form.png\" alt=\"\" width=\"300\" height=\"148\" \/><\/p>\n<h3 style=\"text-align: justify;\"><strong><span style=\"text-decoration: underline;\">6# DLookup Query with Date Criteria<\/span><\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>DLookup MS Access function<\/strong> is also used to look at the information on the query.\u00a0 The code \u201c[FinishDate] = #4\/30\/2014#\u201d is been used as the date criteria for the <strong>DLookup in Access<\/strong>. After applying the below code, the output will be \u201cTask 5\u2033 because \u201cTask 5\u201d has the last date 4\/30\/2014 as the query \u201ctask completed\u201d below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64554\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-Query-with-Date-Criteria.png\" alt=\"DLookup Query with Date Criteria\" width=\"507\" height=\"141\" srcset=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-Query-with-Date-Criteria.png 507w, https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-Query-with-Date-Criteria-300x83.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Private Sub Command0_Click()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>If IsNull(DLookup(&#8220;[TaskName]&#8221;, &#8220;task completed&#8221;, &#8220;[FinishDate] = #4\/30\/2014#&#8221;)) Then<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Me.txtResult = &#8220;No Record Found&#8221;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Else<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Me.txtResult = DLookup(&#8220;[TaskName]&#8221;, &#8220;task completed&#8221;, &#8220;[FinishDate] = #4\/30\/2014#&#8221;)<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End If<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64555\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-Query-with-Date-Criteria2.png\" alt=\"\" width=\"300\" height=\"110\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>7# DLookup with Numeric Criteria<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">In this section, the code \u201c[UserID] = 6\u201d is used as numeric criteria for <strong>MS Access DLookup function<\/strong>.\u00a0 This will show the output, the \u201cAdam Smith\u201d because UserID 6 \u00a0is assigned for the User Name \u201cAdam Smith.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64557\" src=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/DLookup-with-Numeric-Criteria.png\" alt=\"DLookup with Numeric Criteria\" width=\"300\" height=\"173\" \/><\/p>\n<h5 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Code:<\/strong><\/span><\/h5>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Private Sub Command0_Click()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>If IsNull(DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[UserID] = 6&#8221;)) Then<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 Me.txtUserName= &#8220;No Record Found&#8221;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Else<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 Me.txtUserName = DLookup(&#8220;[User Name]&#8221;, &#8220;tblUser&#8221;, &#8220;[UserID] = 6&#8221;)<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End If<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>8# DLookup with VBA Code<\/strong><\/span><\/h3>\n<h5>Example in VBA Code<\/h5>\n<p>You can also use the DLookup function with VBA code in Access. Here is the following example to learn how to use <strong>DLookup with VBA Code:<\/strong><\/p>\n<blockquote>\n<pre class=\"notranslate\"><em>Dim LDate As Date\r\n\r\nLDate = DLookup(\"OrderDate\", \"Orders\", \"OrderID = 10248\")<\/em><\/pre>\n<\/blockquote>\n<p style=\"text-align: justify;\">In the above example, LDate is used as a variable that will keep the OrderDate value of the Orders table. From this Orders table, <em>OrderID 10248 is used in the code.<\/em><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Wrap Up:<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Hopefully, all the aforementioned information about<strong> MS<\/strong> <strong>Access DLookup function<\/strong> seems helpful to you in easy access of this <strong>DLookup( ) function in Access Database<\/strong> from now onwards. The DLOOKUP function is quite easy to use but only when you understand how to work with it.\u00a0 So, learn <strong>how to use DLOOKUP Access Function<\/strong> in multiple criteria and try them all.<\/p>\n<p style=\"text-align: justify;\">If you stuck into any further issue regarding DLookup Access function then ask in our comment section. You will surely get an immediate response to your query.<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #e7e7e7; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='display: inline; background: #fff; padding: 10px; border: 1px solid #e7e7e7; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><img src='https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/12\/y-bulb.png' alt='tip' style='vertical-align: middle;' width='30px'><strong style='font-size: 18px; vertical-align: middle;'> Still having issues?<\/strong> Fix them with this Access repair tool: <\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>This software repairs & restores all ACCDB\/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'>Download Stellar Repair for Access <\/a><\/strong> rated <i>Great<\/i> on Cnet (<i>download starts on this page<\/i>).<\/li><li>Click <strong>Browse<\/strong> and <strong>Search<\/strong> option to locate corrupt Access database.<\/li><li>Click <strong>Repair<\/strong> button to repair & preview the database objects.<\/li><\/ol><\/div><\/div><\/div><\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Have you heard off or ever tried Access Database DLookup\u00a0function? Want to know about this Access Database DLookup\u00a0function more? Then &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"7 Ways To Use MS Access DLookup( ) Function That You Can&#8217;t Miss&#8230;!\" class=\"read-more button\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#more-64549\" aria-label=\"Read more about 7 Ways To Use MS Access DLookup( ) Function That You Can&#8217;t Miss&#8230;!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":64551,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[1002,999,1290,998,1004,997,1001,1003,1291,1000],"class_list":["post-64549","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-access-database-dlookup-function","tag-access-dlookup-function","tag-dlookup-access","tag-dlookup-function","tag-dlookup-function-examples","tag-dlookup-function-in-access-database","tag-how-to-use-dlookup-in-access","tag-microsoft-access-dlookup-function-syntax","tag-ms-access-dlookup","tag-ms-access-dlookup-function","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>7 Ways To Use MS Access DLookup( ) Function That You Can&#039;t Miss...!<\/title>\n<meta name=\"description\" content=\"Get complete overview on MS Access Dlookup Function with it\u2019s example. Learn about Microsoft Access Dlookup Function Syntax, ways to use dlookup function under different criteria.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7 Ways To Use MS Access DLookup( ) Function That You Can&#039;t Miss...!\" \/>\n<meta property=\"og:description\" content=\"Get complete overview on MS Access Dlookup Function with it\u2019s example. Learn about Microsoft Access Dlookup Function Syntax, ways to use dlookup function under different criteria.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function\" \/>\n<meta property=\"og:site_name\" content=\"MS Access Repair And Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-02T12:33:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-02T06:29:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png\" \/>\n\t<meta property=\"og:image:width\" content=\"825\" \/>\n\t<meta property=\"og:image:height\" content=\"550\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pearson Willey\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pearson Willey\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\"},\"headline\":\"7 Ways To Use MS Access DLookup( ) Function That You Can&#8217;t Miss&#8230;!\",\"datePublished\":\"2019-04-02T12:33:42+00:00\",\"dateModified\":\"2021-08-02T06:29:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function\"},\"wordCount\":1784,\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png\",\"keywords\":[\"Access Database DLookup\u00a0function\",\"Access DLookup function\",\"dlookup access\",\"DLookup function\",\"DLookup Function Examples\",\"DLookup( ) function in Access Database\",\"how to use dlookup in access\",\"Microsoft Access Dlookup Function Syntax\",\"ms access dlookup\",\"MS Access Dlookup Function\"],\"articleSection\":[\"Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function\",\"name\":\"7 Ways To Use MS Access DLookup( ) Function That You Can't Miss...!\",\"isPartOf\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png\",\"datePublished\":\"2019-04-02T12:33:42+00:00\",\"dateModified\":\"2021-08-02T06:29:02+00:00\",\"description\":\"Get complete overview on MS Access Dlookup Function with it\u2019s example. Learn about Microsoft Access Dlookup Function Syntax, ways to use dlookup function under different criteria.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png\",\"width\":825,\"height\":550,\"caption\":\"Ways To Use MS Access DLookup Function\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 Ways To Use MS Access DLookup( ) Function That You Can&#8217;t Miss&#8230;!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#website\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"name\":\"MS Access Repair And Recovery Blog\",\"description\":\"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More\",\"publisher\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization\",\"name\":\"MS Access Repair And Recovery Blog\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"MS Access Repair And Recovery Blog\"},\"image\":{\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"caption\":\"Pearson Willey\"},\"description\":\"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.\",\"url\":\"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"7 Ways To Use MS Access DLookup( ) Function That You Can't Miss...!","description":"Get complete overview on MS Access Dlookup Function with it\u2019s example. Learn about Microsoft Access Dlookup Function Syntax, ways to use dlookup function under different criteria.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function","og_locale":"en_US","og_type":"article","og_title":"7 Ways To Use MS Access DLookup( ) Function That You Can't Miss...!","og_description":"Get complete overview on MS Access Dlookup Function with it\u2019s example. Learn about Microsoft Access Dlookup Function Syntax, ways to use dlookup function under different criteria.","og_url":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function","og_site_name":"MS Access Repair And Recovery Blog","article_published_time":"2019-04-02T12:33:42+00:00","article_modified_time":"2021-08-02T06:29:02+00:00","og_image":[{"width":825,"height":550,"url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#article","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function"},"author":{"name":"Pearson Willey","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb"},"headline":"7 Ways To Use MS Access DLookup( ) Function That You Can&#8217;t Miss&#8230;!","datePublished":"2019-04-02T12:33:42+00:00","dateModified":"2021-08-02T06:29:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function"},"wordCount":1784,"publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png","keywords":["Access Database DLookup\u00a0function","Access DLookup function","dlookup access","DLookup function","DLookup Function Examples","DLookup( ) function in Access Database","how to use dlookup in access","Microsoft Access Dlookup Function Syntax","ms access dlookup","MS Access Dlookup Function"],"articleSection":["Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function","name":"7 Ways To Use MS Access DLookup( ) Function That You Can't Miss...!","isPartOf":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage"},"thumbnailUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png","datePublished":"2019-04-02T12:33:42+00:00","dateModified":"2021-08-02T06:29:02+00:00","description":"Get complete overview on MS Access Dlookup Function with it\u2019s example. Learn about Microsoft Access Dlookup Function Syntax, ways to use dlookup function under different criteria.","breadcrumb":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#primaryimage","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/04\/Ways-To-Use-MS-Access-Dlookup-Function.png","width":825,"height":550,"caption":"Ways To Use MS Access DLookup Function"},{"@type":"BreadcrumbList","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/ways-to-use-ms-access-dlookup-function#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.accessrepairnrecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"7 Ways To Use MS Access DLookup( ) Function That You Can&#8217;t Miss&#8230;!"}]},{"@type":"WebSite","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","name":"MS Access Repair And Recovery Blog","description":"Your One Stop Destination for MS Access Fixes, Tutorials &amp; More","publisher":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#organization","name":"MS Access Repair And Recovery Blog","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"MS Access Repair And Recovery Blog"},"image":{"@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/9e865a2660c466b5b9c3a485e05f8ecb","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.accessrepairnrecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","caption":"Pearson Willey"},"description":"Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access &amp; sharing tech blogs.","url":"https:\/\/www.accessrepairnrecovery.com\/blog\/author\/pearson-willey"}]}},"_links":{"self":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/64549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=64549"}],"version-history":[{"count":0,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/64549\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/64551"}],"wp:attachment":[{"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=64549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=64549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=64549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}