{"id":1049,"date":"2019-06-03T06:06:37","date_gmt":"2019-06-03T06:06:37","guid":{"rendered":"http:\/\/pt.accessrepairnrecovery.com\/blog\/?p=1049"},"modified":"2021-08-04T09:16:24","modified_gmt":"2021-08-04T09:16:24","slug":"maneiras-de-usar-ms-access-dlookup-function","status":"publish","type":"post","link":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function","title":{"rendered":"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder &#8230;!"},"content":{"rendered":"<div class=\"61a7eaf49d266b7aad494940042015c0\" 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;\"><em><strong>Voc\u00ea j\u00e1 ouviu falar ou j\u00e1 tentou a fun\u00e7\u00e3o Access Database DLookup? Deseja saber mais sobre essa fun\u00e7\u00e3o DLookup do Access Database?<\/strong> Ent\u00e3o, nesse caso, voc\u00ea est\u00e1 na plataforma correta. Como, este tutorial \u00e9 escrito com o principal prospectivo de fornecer a voc\u00ea as informa\u00e7\u00f5es completas sobre a Fun\u00e7\u00e3o Dlookup do MS Access e principalmente se concentrar em como usar o dlookup no Access.<\/em><!--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;'>Avaliado como <i>Excelente<\/i> em <a rel='nofollow' target='_blank' href='https:\/\/www.trustpilot.com\/review\/www.stellarinfo.com'><span style='color: #aaa;'>Trustpilot<\/span><\/a><\/span><br><strong>Ferramenta Gratuita de Reparo de Banco de Dados do MS Access<\/strong><br>Repare arquivos de banco de dados MDB e ACCDB corrompidos e recupere tabelas de banco de dados, consultas, \u00edndices e registros exclu\u00eddos facilmente. Tente agora!<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><\/div><\/div><\/div><\/div>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>O que \u00e9 isso Dlookup de Access Fun\u00e7\u00e3o ?<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1051\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/74.jpg\" alt=\"O que \u00e9 isso Dlookup de Access Fun\u00e7\u00e3o\" width=\"348\" height=\"217\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/74.jpg 700w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/74-300x187.jpg 300w\" sizes=\"auto, (max-width: 348px) 100vw, 348px\" \/><\/p>\n<p style=\"text-align: justify;\">O aplicativo Microsoft Access possui um poderoso pacote de manipula\u00e7\u00e3o de dados com muitas fun\u00e7\u00f5es robustas para fazer a extra\u00e7\u00e3o de dados como o trabalho de maneira f\u00e1cil. A partir dessa vasta cole\u00e7\u00e3o de fun\u00e7\u00f5es do MS Access, o DLookup \u00e9 o mais pr\u00e1tico.<\/p>\n<p style=\"text-align: justify;\">No aplicativo do Microsoft Access, a fun\u00e7\u00e3o DLookup \u00e9 usada para obter o valor de determinado campo do conjunto especificado de registros (um dom\u00ednio). Voc\u00ea pode usar esta fun\u00e7\u00e3o DLookup no m\u00f3dulo Visual Basic for Applications (VBA), uma express\u00e3o de consulta, uma macro ou um controle calculado em um formul\u00e1rio ou relat\u00f3rio.<\/p>\n<p style=\"text-align: justify;\">Essa fun\u00e7\u00e3o \u00e9 melhor para recuperar o valor de determinado campo de um dom\u00ednio. Aqui o dom\u00ednio pode ser um conjunto especificado de registros da tabela, consulta ou express\u00e3o SQL. Pode-se usar esta fun\u00e7\u00e3o DLookup para exibir o valor dos campos que n\u00e3o est\u00e3o presentes no conjunto de registros subjacente.<\/p>\n<p style=\"text-align: justify;\"><strong>Por exemplo:<\/strong><\/p>\n<p style=\"text-align: justify;\">Suponha que voc\u00ea tenha um formul\u00e1rio na tabela Detalhes do pedido. O formul\u00e1rio exibir\u00e1 campos Quantity, OrderID, ProductID, UnitPrice e Discount. No entanto, na tabela de produtos, o campo \u201cProductName\u201d est\u00e1 presente. Nesse caso, voc\u00ea pode usar a fun\u00e7\u00e3o DLookup no controle calculado para exibir o ProductName no mesmo formul\u00e1rio.<\/p>\n<h3 style=\"text-align: justify;\"><strong>Exemplos da Fun\u00e7\u00e3o DLookup<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1060\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MastersDegree.png\" alt=\"Exemplos da Fun\u00e7\u00e3o DLookup\" width=\"565\" height=\"283\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MastersDegree.png 1600w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MastersDegree-300x150.png 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MastersDegree-768x384.png 768w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MastersDegree-1024x512.png 1024w\" sizes=\"auto, (max-width: 565px) 100vw, 565px\" \/><\/p>\n<p style=\"text-align: justify;\">Dim newvar as variant<\/p>\n<p style=\"text-align: justify;\"><strong><em>Newvar = DLookup(&#8220;[student name]&#8221;,&#8221;studentmaster&#8221;,&#8221;[rollno]=1001&#8243;)<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">A partir do exemplo acima, extrai os dados do campo [nome do aluno] da tabela studentmaster para o n\u00famero de rolo 1001.<\/p>\n<p style=\"text-align: justify;\">Verifique o que acontecer\u00e1 se a fun\u00e7\u00e3o DLookup for dada sem nenhum crit\u00e9rio.<\/p>\n<p style=\"text-align: justify;\"><strong><em>Newvar = DLookup(&#8220;[student name]&#8221;,&#8221;studentmaster&#8221;)<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">O c\u00f3digo acima retornar\u00e1 os dados no campo [<strong><em>student name<\/em><\/strong>] do primeiro registro da tabela studentmaster.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea tamb\u00e9m pode usar vari\u00e1veis nos crit\u00e9rios. Por exemplo, um campo de formul\u00e1rio pode ser usado como &lt;condition&gt;<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>VOC\u00ca PODE GOSTAR:<\/strong><\/p>\n<p style=\"text-align: center;\"><strong><a class=\"row-title\" href=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/metodos-para-abrir-o-arquivo-mdb\" aria-label=\"\u201c7 maneiras excelentes para abrir o arquivo Mdb na maneira f\u00e1cil\u2026!\u201d (Edit)\">7 maneiras excelentes para abrir o arquivo Mdb na maneira f\u00e1cil\u2026!<\/a><\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong><em>Newvar = DLookup(&#8220;[student name]&#8221;,&#8221;studentmaster&#8221;,&#8221;[rollno]=Form![rollno]&#8221;)<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">Isso ajudar\u00e1 a comparar os dados no campo [nome do aluno] da tabela studentmaster com o que est\u00e1 no campo [rollno] do formul\u00e1rio atual.<\/p>\n<p style=\"text-align: justify;\">Para especificar crit\u00e9rios textuais que s\u00e3o de um campo em um formul\u00e1rio, inclua as aspas simples.<\/p>\n<p style=\"text-align: justify;\"><strong><em>Nvar = DLookup(&#8220;[rollno]&#8221;,&#8221;studentmaster&#8221;,<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>&#8220;[student name]=\u2019 &#8221; &amp; Forms![Marks]![student name] &amp; &#8221; &#8216; &#8220;)<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">No geral, a moral da hist\u00f3ria \u00e9 fun\u00e7\u00e3o DLookup \u00e9 usada como uma express\u00e3o na consulta do Microsoft Access ou campo calculado no formul\u00e1rio para recuperar valores externos. Bem, voc\u00ea pode usar isso tamb\u00e9m no campo Criteria do construtor de consultas. Essa \u00e9 a raz\u00e3o pela qual \u00e9 mais eficiente fazer uma nova consulta com campos de ambas as tabelas e us\u00e1-la como conjunto de registros base.<\/p>\n<p style=\"text-align: justify;\">O DLookup escolhe os registros salvos do dom\u00ednio. Outro registro n\u00e3o salvo n\u00e3o est\u00e1 inclu\u00eddo no dom\u00ednio.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Sintaxe da fun\u00e7\u00e3o Dlookup do Microsoft Access:<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1050\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/24-512.png\" alt=\"Sintaxe da fun\u00e7\u00e3o Dlookup do Microsoft Access\" width=\"263\" height=\"263\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/24-512.png 512w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/24-512-150x150.png 150w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/24-512-300x300.png 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/24-512-65x65.png 65w\" sizes=\"auto, (max-width: 263px) 100vw, 263px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong><em>DLookup(<\/em><\/strong><em>\u00a0<strong>expr, domain\u00a0<\/strong>[<strong>, criteria<\/strong>]\u00a0<strong>)<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\">The\u00a0<strong>DLookup<\/strong>\u00a0function syntax has these arguments:<\/p>\n<h4 style=\"text-align: justify;\"><strong>Expr:<\/strong><\/h4>\n<p style=\"text-align: justify;\">A parte Expression identifica o campo cujo valor voc\u00ea deseja retornar. Isso pode ser uma express\u00e3o de string para identificar um campo na tabela ou consulta ou pode ser uma express\u00e3o que executa o c\u00e1lculo nos dados do campo.<\/p>\n<p style=\"text-align: justify;\">Na parte de express\u00e3o da Sintaxe da fun\u00e7\u00e3o Dlookup, voc\u00ea pode incluir o nome do campo em uma tabela, controle ou um formul\u00e1rio, constante ou fun\u00e7\u00e3o. Se essa parte incluir qualquer fun\u00e7\u00e3o, ela poder\u00e1 ser definida pelo usu\u00e1rio ou incorporada, mas n\u00e3o \u00e0 fun\u00e7\u00e3o agregada SQL ou a qualquer outra fun\u00e7\u00e3o agregada do dom\u00ednio.<\/p>\n<h4 style=\"text-align: justify;\">Dom\u00ednio<\/h4>\n<p style=\"text-align: justify;\">\u00a0A express\u00e3o de seq\u00fc\u00eancia de caracteres que identifica o conjunto de registros constitui a parte do dom\u00ednio da sintaxe da fun\u00e7\u00e3o Dlookup. Pode ser o nome da tabela ou o nome da consulta para a consulta que n\u00e3o precisa de nenhum par\u00e2metro.<\/p>\n<h4 style=\"text-align: justify;\">Crit\u00e9rios<\/h4>\n<p style=\"text-align: justify;\">Express\u00e3o de string usada para limitar o intervalo de dados no qual a fun\u00e7\u00e3o DLookup \u00e9 executada. Suponha que o crit\u00e9rio seja equivalente \u00e0 cl\u00e1usula WHERE na express\u00e3o SQL, sem usar a palavra WHERE. Se os crit\u00e9rios n\u00e3o forem mencionados, a fun\u00e7\u00e3o DLookup ser\u00e1 aplicada em todo o dom\u00ednio. Qualquer campo que esteja inclu\u00eddo no crit\u00e9rio deve ser um campo no dom\u00ednio, caso contr\u00e1rio, a fun\u00e7\u00e3o retornar\u00e1 um valor NULL.<\/p>\n<p style=\"text-align: justify;\">A fun\u00e7\u00e3o DLookup () do banco de dados de acesso retorna o valor \u00fanico de um \u00fanico campo. Se nenhum registro corresponder aos crit\u00e9rios ou se o dom\u00ednio estiver vazio, a fun\u00e7\u00e3o DLookup () retornar\u00e1 um valor Nulo. Se mais de um registro corresponder aos crit\u00e9rios, nesse caso, DLookup retornar\u00e1 a primeira inst\u00e2ncia desse &lt;fieldname&gt;.<\/p>\n<p style=\"text-align: justify;\">Portanto, os crit\u00e9rios devem ser definidos com cuidado para obter campo exclusivo da fun\u00e7\u00e3o DLookup. Se os seus crit\u00e9rios preenchidos forem texto, mantenha o texto entre aspas simples.<\/p>\n<p style=\"text-align: justify;\">Para calcular valores de data ou hora, coloque a hora ou o valor dos dados em sinais num\u00e9ricos (#).<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Como usar a fun\u00e7\u00e3o Dlookup () no Access?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Aqui est\u00e3o as seguintes circunst\u00e2ncias explicadas para aprender rapidamente sobre como usar a fun\u00e7\u00e3o Dlookup () no Access.<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong># 1 DLookup no registro de dados vazio<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Se voc\u00ea aplicar a fun\u00e7\u00e3o DLookup sobre a tabela ou consulta que cont\u00e9m os registros, ela mostrar\u00e1 a mensagem de erro &#8220;Uso inv\u00e1lido de nulo&#8221;. Isso acontece porque voc\u00ea est\u00e1 tentando atribuir um valor nulo \u00e0 vari\u00e1vel strX.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo:<\/strong><\/p>\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-1052\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/DLookup-on-Empty-Data-Record.png\" alt=\"\" width=\"300\" height=\"174\" \/><\/p>\n<p style=\"text-align: justify;\">Para evitar essa mensagem de erro, voc\u00ea pode usar a instru\u00e7\u00e3o IF para verificar se h\u00e1 registro antes de alocar o valor do resultado \u00e0 strX.<\/p>\n<p style=\"text-align: justify;\"><strong>Correct C\u00f3digo:<\/strong><\/p>\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-1053\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/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 com crit\u00e9rios textuais<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Quando voc\u00ea usa sinal de igual no c\u00f3digo \u201c[UserLoginID] = &#8216;John&#8217;\u201d, somente o registro com o nome de usu\u00e1rio inteiro = \u201cJohn\u201d ser\u00e1 exibido como resultado desse crit\u00e9rio.<\/p>\n<p style=\"text-align: justify;\">O resultado ser\u00e1 exibido como &#8220;Nenhum registro encontrado&#8221; porque n\u00e3o h\u00e1 registro com o nome de usu\u00e1rio &#8220;Jo\u00e3o&#8221;, mas h\u00e1 registros para &#8220;Jo\u00e3o Silva&#8221; ou &#8220;Jos\u00e9 Jo\u00e3o&#8221;.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo:<\/strong><\/p>\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<p style=\"text-align: center;\"><strong>LEIA TAMB\u00c9M<\/strong><\/p>\n<p style=\"text-align: center;\"><strong><a class=\"row-title\" href=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/integrar-ms-access-e-outlook\" aria-label=\"\u201cComo importar o email do Outlook para o banco de dados do Access?\u201d (Edit)\">Como importar o email do Outlook para o banco de dados do Access?<\/a><\/strong><\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#3 DLookup sem crit\u00e9rios<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Bem, \u00e9 a maneira mais simples de usar a fun\u00e7\u00e3o DLookup (); ou seja, sem especificar nenhum crit\u00e9rio. Nesse caso, a fun\u00e7\u00e3o DLookup fornecer\u00e1 o valor do primeiro registro no campo CustomerName da tabela tbl_Customer.<\/p>\n<p style=\"text-align: justify;\">Assim, a sa\u00edda ser\u00e1 &#8220;Barney Rubble&#8221;, porque \u00e9 o primeiro registro na tabela tbl_Customer, como mostrado na figura abaixo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1058\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/DLookup-without-Criteria.png\" alt=\"\" width=\"300\" height=\"155\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo:<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\">Private Sub Command0_Click()<\/p>\n<p style=\"text-align: justify;\">Dim strX As String<\/p>\n<p style=\"text-align: justify;\">strX = DLookup(&#8220;CustomerName&#8221;, &#8220;tbl_customer&#8221;)<\/p>\n<p style=\"text-align: justify;\">Me.txtResult = strX<\/p>\n<p style=\"text-align: justify;\">End Sub<\/p>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1061\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/result-no-criteria-300x104.png\" alt=\"\" width=\"300\" height=\"104\" \/><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#4 DLookup com um crit\u00e9rio num\u00e9rico que vem do campo no formul\u00e1rio atual<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">O c\u00f3digo \u201c[UserID] = Me.txtUserID\u201d \u00e9 usado aqui como crit\u00e9rio num\u00e9rico para a fun\u00e7\u00e3o DLookup. Isso mostrar\u00e1 a sa\u00edda \u201cJohn Vang\u201d, pois o ID do usu\u00e1rio 3 \u00e9 para o nome de usu\u00e1rio \u201cJohn Vang\u201d, conforme a tabela tblUser mostrada acima.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo:<\/strong><\/p>\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<\/blockquote>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>#5 DLookup com crit\u00e9rios de texto que vem de um campo no formul\u00e1rio atual<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">O c\u00f3digo \u201c[UserLoginID] = &#8216;\u201d &amp; Me.txtLoginID &amp; \u201c\u2018 \u201d\u00e9 usado como crit\u00e9rio para a fun\u00e7\u00e3o DLookup.<\/p>\n<p style=\"text-align: justify;\">Suponha que voc\u00ea queira obter o nome de usu\u00e1rio para o UserLoginID inserido na caixa de texto UserLoginID neste formul\u00e1rio e exibi-lo na caixa de texto User Name.<\/p>\n<p style=\"text-align: justify;\">Est\u00e1 errado se, na caixa de texto UserLoginID, voc\u00ea digitar jvang, o nome de usu\u00e1rio deve ser &#8220;John Vang&#8221;. Aqui duas Instru\u00e7\u00f5es IF s\u00e3o usadas para este c\u00f3digo para verificar se o UserLoginID est\u00e1 inserido ou n\u00e3o e tamb\u00e9m para evitar erros se o Nome do Usu\u00e1rio for deixado vazio para o UserLoginID inserido.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1057\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/DLookup-with-Numeric-Criteria.png\" alt=\"\" width=\"300\" height=\"173\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo:<\/strong><\/p>\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.txtLoginID) Then<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0 MsgBox &#8220;Please enter a UserLoginID&#8221;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Else<\/em><\/p>\n<p style=\"text-align: justify;\"><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: justify;\"><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: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0 Else<\/em><\/p>\n<p style=\"text-align: justify;\"><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: justify;\"><em>\u00a0\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<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1056\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/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;\"><span style=\"text-decoration: underline;\"><strong>#6 Consulta DLookup com crit\u00e9rios de data<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">A fun\u00e7\u00e3o DLookup tamb\u00e9m \u00e9 usada para procurar informa\u00e7\u00f5es na consulta. O c\u00f3digo \u201c[FinishDate] = # 4\/30\/2014 #\u201d est\u00e1 sendo usado como crit\u00e9rio de data para a fun\u00e7\u00e3o DLookup. Depois de aplicar o c\u00f3digo abaixo, a sa\u00edda ser\u00e1 &#8220;Tarefa 5&#8221; porque a &#8220;Tarefa 5&#8221; tem a \u00faltima data em 30\/04\/2014 como a consulta &#8220;tarefa conclu\u00edda&#8221; abaixo.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1054\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/DLookup-Query-with-Date-Criteria.png\" alt=\"\" width=\"507\" height=\"141\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/DLookup-Query-with-Date-Criteria.png 507w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/DLookup-Query-with-Date-Criteria-300x83.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo:<\/strong><\/p>\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-1055\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/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 com crit\u00e9rios num\u00e9ricos<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Nesta se\u00e7\u00e3o, o c\u00f3digo \u201c[UserID] = 6\u201d \u00e9 usado como crit\u00e9rio num\u00e9rico para a fun\u00e7\u00e3o DLookup. Isso mostrar\u00e1 a sa\u00edda, o &#8220;Adam Smith&#8221;, porque o UserID 6 \u00e9 atribu\u00eddo ao nome de usu\u00e1rio &#8220;Adam Smith&#8221;.<\/p>\n<p style=\"text-align: justify;\"><strong>C\u00f3digo:<\/strong><\/p>\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<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Embrulhar:<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Espero que todas as informa\u00e7\u00f5es acima mencionadas sobre a fun\u00e7\u00e3o Access DLookup lhe sejam \u00fateis para facilitar o acesso desta fun\u00e7\u00e3o DLookup () no Access Database a partir de agora. A fun\u00e7\u00e3o DLOOKUP \u00e9 silenciosa e f\u00e1cil de usar, mas somente quando voc\u00ea entende como trabalhar com ela. Ent\u00e3o, aprenda como usar a fun\u00e7\u00e3o DLOOKUP em m\u00faltiplos crit\u00e9rios e experimente todos eles. Se voc\u00ea se deparou com algum outro problema relacionado \u00e0 fun\u00e7\u00e3o DLookup, pergunte na nossa se\u00e7\u00e3o FAQ. Voc\u00ea certamente receber\u00e1 uma resposta imediata em sua pergunta.<\/p>\n<p style=\"text-align: justify;\"><div style='margin: 8px 0; clear: both;'><div style='border: 1px solid #b10923; border-radius: 3px; background: #ffffff; color: #000; margin-top: 30px;'><div style='color: #fff; display: inline; background: #b10923; padding: 10px; border: 1px solid #b10923; border-bottom-right-radius: 10px; border-top-left-radius: 10px; border-top-right-radius: 10px; margin-left: -1px;'><i class='fas fa-lightbulb fa-lg'><\/i><strong style='font-size: 18px; vertical-align: middle;'> Ainda est\u00e1 com problemas? Corrija-os com Stellar repara\u00e7\u00e3o para Access:<\/strong><\/div><div style='padding: 1rem; line-height: 1.6;'><p style='margin: 0; font-size: 17px;'>Este software garante sem costura reparo e recupera\u00e7\u00e3o do banco de dados ACCDB e MDB. Ele restaura todos os objetos, incluindo tabelas, relat\u00f3rios, consultas, registros, formul\u00e1rios e \u00edndices, juntamente com m\u00f3dulos, macros, etc. Corrija os problemas do Microsoft Access agora em 3 etapas f\u00e1ceis:<\/p><div><ol style='font-size: 17px;'><li><strong><a href='https:\/\/www.accessrepairnrecovery.com\/blog\/get-access-file-repair-tool' target='_blank'> Baixar Stellar Access banco de dados reparo ferramenta<\/a><\/strong> avaliado <i> Excelente <\/i> sobre Cnet.<\/li><li>Clique nas op\u00e7\u00f5es <strong>Browse <\/strong>e <strong> Pesquisa <\/strong> para localizar um banco de dados corrompido do Access.<\/li><li>Clique no bot\u00e3o <strong> Reparar <\/strong> para reparar e pr\u00e9-visualiza\u00e7\u00e3o os objetos do banco de dados.<\/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>Voc\u00ea j\u00e1 ouviu falar ou j\u00e1 tentou a fun\u00e7\u00e3o Access Database DLookup? Deseja saber mais sobre essa fun\u00e7\u00e3o DLookup do &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder &#8230;!\" class=\"read-more button\" href=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#more-1049\" aria-label=\"Read more about 7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder &#8230;!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1062,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1448],"tags":[829,827,831,826,828,825,824,830],"class_list":["post-1049","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-como-usar-dlookup-no-acesso","tag-dlookup-function-examples","tag-funcao-de-acesso-ms-access","tag-funcao-dlookup","tag-funcao-dlookup-no-banco-de-dados-do-access","tag-funcao-dlookup-de-acesso","tag-funcao-dlookup-do-banco-de-dados-de-acesso","tag-sintaxe-da-funcao-dlookup-do-microsoft-access","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder ...!<\/title>\n<meta name=\"description\" content=\"Obtenha uma vis\u00e3o geral completa sobre a fun\u00e7\u00e3o Dlookup do MS Access com exemplo. Saiba mais sobre o Microsoft Access Dlookup Fun\u00e7\u00e3o Sintaxe, maneiras de usar a fun\u00e7\u00e3o dlookup sob diferentes crit\u00e9rios.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-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 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder ...!\" \/>\n<meta property=\"og:description\" content=\"Obtenha uma vis\u00e3o geral completa sobre a fun\u00e7\u00e3o Dlookup do MS Access com exemplo. Saiba mais sobre o Microsoft Access Dlookup Fun\u00e7\u00e3o Sintaxe, maneiras de usar a fun\u00e7\u00e3o dlookup sob diferentes crit\u00e9rios.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Reparo e Recuperacao do MS Access\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-03T06:06:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-04T09:16:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MS-Access-Dlookup-Function-pt.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:creator\" content=\"@https:\/\/twitter.com\/pearson_willey\" \/>\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=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#\\\/schema\\\/person\\\/a38175469c0746d451eead783463bc78\"},\"headline\":\"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder &#8230;!\",\"datePublished\":\"2019-06-03T06:06:37+00:00\",\"dateModified\":\"2021-08-04T09:16:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function\"},\"wordCount\":1860,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/MS-Access-Dlookup-Function-pt.png\",\"keywords\":[\"como usar dlookup no acesso\",\"DLookup Function Examples\",\"Fun\u00e7\u00e3o de acesso MS Access\",\"Fun\u00e7\u00e3o DLookup\",\"Fun\u00e7\u00e3o DLookup () no banco de dados do Access\",\"Fun\u00e7\u00e3o DLookup de acesso\",\"Fun\u00e7\u00e3o DLookup do banco de dados de acesso\",\"Sintaxe da fun\u00e7\u00e3o Dlookup do Microsoft Access\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function\",\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function\",\"name\":\"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder ...!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/MS-Access-Dlookup-Function-pt.png\",\"datePublished\":\"2019-06-03T06:06:37+00:00\",\"dateModified\":\"2021-08-04T09:16:24+00:00\",\"description\":\"Obtenha uma vis\u00e3o geral completa sobre a fun\u00e7\u00e3o Dlookup do MS Access com exemplo. Saiba mais sobre o Microsoft Access Dlookup Fun\u00e7\u00e3o Sintaxe, maneiras de usar a fun\u00e7\u00e3o dlookup sob diferentes crit\u00e9rios.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function#primaryimage\",\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/MS-Access-Dlookup-Function-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/MS-Access-Dlookup-Function-pt.png\",\"width\":825,\"height\":550,\"caption\":\"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/maneiras-de-usar-ms-access-dlookup-function#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder &#8230;!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/\",\"name\":\"Blog de Reparo e Recuperacao do MS Access\",\"description\":\"Seu Destino \u00fanico para Corre\u00e7\u00f5es, Tutoriais e Muito mais do MS Access\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#organization\",\"name\":\"Blog de Reparo e Recuperacao do MS Access\",\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/accessrepairnrecovery-com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/accessrepairnrecovery-com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Blog de Reparo e Recuperacao do MS Access\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#\\\/schema\\\/person\\\/a38175469c0746d451eead783463bc78\",\"name\":\"Pearson Willey\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g\",\"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 \u00e9 escritor de conte\u00fado de sites e longo- planejador de conte\u00fado do formul\u00e1rio. Al\u00e9m disso, ele tamb\u00e9m \u00e9 um \u00e1vido leitor. Assim, ele sabe muito bem como escrever um conte\u00fado atraente para os leitores. Escrever \u00e9 como uma vantagem crescente para ele. Ele adora explorar seu conhecimento no MS Access e compartilhar blogs de tecnologia.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/pearson-willey-4b8887194\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/pearson_willey\"],\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/author\\\/pearson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder ...!","description":"Obtenha uma vis\u00e3o geral completa sobre a fun\u00e7\u00e3o Dlookup do MS Access com exemplo. Saiba mais sobre o Microsoft Access Dlookup Fun\u00e7\u00e3o Sintaxe, maneiras de usar a fun\u00e7\u00e3o dlookup sob diferentes crit\u00e9rios.","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:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function","og_locale":"en_US","og_type":"article","og_title":"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder ...!","og_description":"Obtenha uma vis\u00e3o geral completa sobre a fun\u00e7\u00e3o Dlookup do MS Access com exemplo. Saiba mais sobre o Microsoft Access Dlookup Fun\u00e7\u00e3o Sintaxe, maneiras de usar a fun\u00e7\u00e3o dlookup sob diferentes crit\u00e9rios.","og_url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function","og_site_name":"Blog de Reparo e Recuperacao do MS Access","article_published_time":"2019-06-03T06:06:37+00:00","article_modified_time":"2021-08-04T09:16:24+00:00","og_image":[{"width":825,"height":550,"url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MS-Access-Dlookup-Function-pt.png","type":"image\/png"}],"author":"Pearson Willey","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/pearson_willey","twitter_misc":{"Written by":"Pearson Willey","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#article","isPartOf":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function"},"author":{"name":"Pearson Willey","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#\/schema\/person\/a38175469c0746d451eead783463bc78"},"headline":"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder &#8230;!","datePublished":"2019-06-03T06:06:37+00:00","dateModified":"2021-08-04T09:16:24+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function"},"wordCount":1860,"publisher":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#primaryimage"},"thumbnailUrl":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MS-Access-Dlookup-Function-pt.png","keywords":["como usar dlookup no acesso","DLookup Function Examples","Fun\u00e7\u00e3o de acesso MS Access","Fun\u00e7\u00e3o DLookup","Fun\u00e7\u00e3o DLookup () no banco de dados do Access","Fun\u00e7\u00e3o DLookup de acesso","Fun\u00e7\u00e3o DLookup do banco de dados de acesso","Sintaxe da fun\u00e7\u00e3o Dlookup do Microsoft Access"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function","url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function","name":"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder ...!","isPartOf":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#primaryimage"},"image":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#primaryimage"},"thumbnailUrl":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MS-Access-Dlookup-Function-pt.png","datePublished":"2019-06-03T06:06:37+00:00","dateModified":"2021-08-04T09:16:24+00:00","description":"Obtenha uma vis\u00e3o geral completa sobre a fun\u00e7\u00e3o Dlookup do MS Access com exemplo. Saiba mais sobre o Microsoft Access Dlookup Fun\u00e7\u00e3o Sintaxe, maneiras de usar a fun\u00e7\u00e3o dlookup sob diferentes crit\u00e9rios.","breadcrumb":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#primaryimage","url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MS-Access-Dlookup-Function-pt.png","contentUrl":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/06\/MS-Access-Dlookup-Function-pt.png","width":825,"height":550,"caption":"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/maneiras-de-usar-ms-access-dlookup-function#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.accessrepairnrecovery.com\/blog"},{"@type":"ListItem","position":2,"name":"7 maneiras de usar a fun\u00e7\u00e3o DLookup () do Microsoft Access que Voc\u00ea n\u00e3o pode perder &#8230;!"}]},{"@type":"WebSite","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#website","url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/","name":"Blog de Reparo e Recuperacao do MS Access","description":"Seu Destino \u00fanico para Corre\u00e7\u00f5es, Tutoriais e Muito mais do MS Access","publisher":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.accessrepairnrecovery.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#organization","name":"Blog de Reparo e Recuperacao do MS Access","url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","contentUrl":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2021\/07\/accessrepairnrecovery-com-logo.png","width":350,"height":70,"caption":"Blog de Reparo e Recuperacao do MS Access"},"image":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#\/schema\/person\/a38175469c0746d451eead783463bc78","name":"Pearson Willey","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1e14359741626aa0b5f1415dc1929323c9923a9826470b578bddbc2a39751640?s=96&d=mm&r=g","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 \u00e9 escritor de conte\u00fado de sites e longo- planejador de conte\u00fado do formul\u00e1rio. Al\u00e9m disso, ele tamb\u00e9m \u00e9 um \u00e1vido leitor. Assim, ele sabe muito bem como escrever um conte\u00fado atraente para os leitores. Escrever \u00e9 como uma vantagem crescente para ele. Ele adora explorar seu conhecimento no MS Access e compartilhar blogs de tecnologia.","sameAs":["https:\/\/www.linkedin.com\/in\/pearson-willey-4b8887194\/","https:\/\/x.com\/https:\/\/twitter.com\/pearson_willey"],"url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/author\/pearson"}]}},"_links":{"self":[{"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/1049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=1049"}],"version-history":[{"count":2,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/1049\/revisions"}],"predecessor-version":[{"id":2293,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/1049\/revisions\/2293"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/1062"}],"wp:attachment":[{"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=1049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=1049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=1049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}