{"id":1472,"date":"2019-12-04T12:14:49","date_gmt":"2019-12-04T12:14:49","guid":{"rendered":"http:\/\/pt.accessrepairnrecovery.com\/blog\/?p=1472"},"modified":"2021-10-21T07:01:33","modified_gmt":"2021-10-21T07:01:33","slug":"executar-codigo-vba-no-access","status":"publish","type":"post","link":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access","title":{"rendered":"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019"},"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;\">Sem d\u00favida, a cria\u00e7\u00e3o de banco de dados no Access com v\u00e1rios objetos, como relat\u00f3rios, formul\u00e1rios e tabelas, \u00e9 bastante f\u00e1cil. Mas quando se trata de adicionar alguma programa\u00e7\u00e3o para execu\u00e7\u00e3o simult\u00e2nea de objetos de banco de dados ou automatizar determinados processos. Ent\u00e3o isso pode ser uma tarefa assustadora para executar\u2026. n\u00e3o \u00e9?<\/p>\n<p style=\"text-align: justify;\">Principalmente para aqueles que n\u00e3o t\u00eam muito conhecimento de codifica\u00e7\u00e3o de programas. se voc\u00ea tamb\u00e9m estiver entre eles, este post certamente ir\u00e1 ajud\u00e1-lo para conseguir muito mais informa\u00e7\u00f5es sobre a execu\u00e7\u00e3o do c\u00f3digo VBA no Access.<!--more--><\/p>\n<h3 style=\"text-align: justify;\"><strong>Entenda o c\u00f3digo VBA do MS Access com exemplo:<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1478\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/MS-Access-VBA-Code-With-Example.jpg\" alt=\"Entenda o c\u00f3digo VBA do MS Access com exemplo\" width=\"338\" height=\"284\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/MS-Access-VBA-Code-With-Example.jpg 338w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/MS-Access-VBA-Code-With-Example-300x252.jpg 300w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/p>\n<p style=\"text-align: justify;\">No MS Access, a programa\u00e7\u00e3o \u00e9 a maneira pela qual podemos adicionar funcionalidades ao nosso banco de dados. basicamente \u00e9 feito de duas maneiras:<\/p>\n<ul style=\"text-align: justify;\">\n<li>usando macros do Access<\/li>\n<li>ou c\u00f3digo do Visual Basic for Applications (VBA)<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Suponha, por exemplo, que voc\u00ea tenha feito um relat\u00f3rio ou formul\u00e1rio no banco de dados do Access. agora voc\u00ea deseja adicionar um bot\u00e3o de comando nesse formul\u00e1rio. Para que, ao ser clicado, abra automaticamente o relat\u00f3rio.<\/p>\n<p style=\"text-align: justify;\">Nesse caso, a programa\u00e7\u00e3o \u00e9 usada para criar um procedimento de macro ou VBA para definir a propriedade do evento OnClick do bot\u00e3o de comando. Quando voc\u00ea clica no bot\u00e3o de comando, a macro e o procedimento s\u00e3o executados automaticamente em segundo plano. Assim, clicar no formul\u00e1rio do bot\u00e3o de comando do formul\u00e1rio abrir\u00e1 o relat\u00f3rio.<\/p>\n<p style=\"text-align: justify;\">Portanto, tudo o que voc\u00ea pode dizer, o c\u00f3digo VBA no Access permite adicionar automa\u00e7\u00e3o e v\u00e1rias funcionalidades ao seu aplicativo de banco de dados do Access.<\/p>\n<h3 style=\"text-align: justify;\"><strong>O que \u00e9 o editor VBA?<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1487\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Editor.jpg\" alt=\"O que \u00e9 o editor VBA\" width=\"428\" height=\"222\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Bem, para a programa\u00e7\u00e3o no Access, usamos o editor VBA. Para iniciar o editor VBA, primeiro voc\u00ea precisa ir para a op\u00e7\u00e3o de cria\u00e7\u00e3o.<\/li>\n<li>Depois toque no bot\u00e3o do m\u00f3dulo na janela do seu banco de dados.<\/li>\n<li>Isso abrir\u00e1 o editor VBA.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Como voc\u00ea pode ver na figura, existem v\u00e1rias partes nesse editor de VBA. Ent\u00e3o, vamos discutir sobre cada se\u00e7\u00e3o em detalhes:<\/p>\n<ul style=\"text-align: justify;\">\n<li>o canto superior esquerdo \u00e9 chamado de janela do projeto. Isso cont\u00e9m uma lista de todos os elementos e m\u00f3dulos definidos no banco de dados.<\/li>\n<li>abaixo da janela do projeto, h\u00e1 uma janela de propriedades. Neste, voc\u00ea pode especificar atributos diferentes para os objetos que voc\u00ea usou na janela do projeto.<\/li>\n<li>Na parte inferior da tela, h\u00e1 uma janela imediata. Aqui voc\u00ea pode testar as partes do procedimento enquanto isso \u00e9 desenvolvido. Al\u00e9m disso, tamb\u00e9m pode ser usado para obter resultados imediatos de v\u00e1rios comandos. A janela imediata \u00e9 muito \u00fatil durante o procedimento de teste e depura\u00e7\u00e3o.<\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><strong>Benef\u00edcios do uso do c\u00f3digo VBA no Access:<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1474\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Benefits-Of-Using-VBA-Code-In-Access.png\" alt=\"Benef\u00edcios do uso do c\u00f3digo VBA no Access:\" width=\"464\" height=\"306\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Benefits-Of-Using-VBA-Code-In-Access.png 800w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Benefits-Of-Using-VBA-Code-In-Access-300x198.png 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Benefits-Of-Using-VBA-Code-In-Access-768x507.png 768w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e3o algumas raz\u00f5es b\u00e1sicas pelas quais voc\u00ea precisa usar as \u00e1reas de <a href=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/codigo-de-ms-access-vba\"><strong>c\u00f3digo do MS Access VBA<\/strong><\/a>.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Gerenciar procedimentos reutiliz\u00e1veis menores (globalmente)<\/li>\n<li>Crie suas pr\u00f3prias fun\u00e7\u00f5es definidas<\/li>\n<li>na mem\u00f3ria ret\u00e9m vari\u00e1veis (globalmente)<\/li>\n<li>Anexe o c\u00f3digo a um evento, ou seja, um bot\u00e3o em um formul\u00e1rio<\/li>\n<li>Gerenciar procedimentos mais poderosos que uma macro do Access n\u00e3o possui<\/li>\n<li>Terminar facilmente com outros aplicativos e plataformas<\/li>\n<li>manipule de forma inteligente os <a href=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/ms-access-tempo-de-execucao-erros\"><strong>erros de tempo de execu\u00e7\u00e3o do Access<\/strong><\/a><\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Para aprender o C\u00f3digo VBA do Access, voc\u00ea n\u00e3o precisa ser um programador. O fator importante para programar com \u00eaxito com o Access VBA \u00e9 at\u00e9 que ponto voc\u00ea conhece a estrutura do MS Access, geralmente denominada tabelas, consultas, formul\u00e1rios, relat\u00f3rios e macros. \u00c9 um recurso muito poderoso do Access para identificar onde o VBA deve superar e melhorar a funcionalidade.<\/p>\n<h2 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>Como executar o c\u00f3digo VBA no MS Access<\/strong><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1476\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Run-VBA-Code-In-MS-Access-.png\" alt=\"Como executar o c\u00f3digo VBA no MS Access\" width=\"534\" height=\"411\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Run-VBA-Code-In-MS-Access-.png 1000w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Run-VBA-Code-In-MS-Access--300x230.png 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Run-VBA-Code-In-MS-Access--768x590.png 768w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>C\u00f3digo VBA para executar uma consulta no MS Access<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Procurando o c\u00f3digo VBA para executar a consulta no MS Access? Nesse caso, verifique as etapas completas para realizar esta tarefa.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode usar a sintaxe do VBA para executar a consulta no MS Access.<\/p>\n<p style=\"text-align: justify;\">DoCmd.OpenQuery &#8220;Nome da Consulta&#8221;<\/p>\n<p style=\"text-align: justify;\">Lembre-se de que &#8220;nome da consulta&#8221; n\u00e3o deve ser mantido entre colchetes &#8220;[]&#8221;.<\/p>\n<p style=\"text-align: justify;\"><strong>Etapas para criar um VBA para executar uma consulta no MS Access<\/strong><\/p>\n<p style=\"text-align: justify;\">Suponha que voc\u00ea tenha um banco de dados do Access que contenha uma consulta denominada &#8220;max_sales&#8221;.<\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o, aqui est\u00e1 a etapa completa que voc\u00ea precisa seguir para criar um VBA para executar a consulta &#8220;max_sales&#8221;:<\/p>\n<h4 style=\"text-align: justify;\"><strong>Etapa 1: adicionar um formul\u00e1rio de access<\/strong><\/h4>\n<p style=\"text-align: justify;\">Primeiro, abra o aplicativo de acesso ao MS e, em seguida, adicione um formul\u00e1rio de acesso.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1479\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-1.png\" alt=\"C\u00f3digo VBA para executar uma consulta no MS Access 1\" width=\"590\" height=\"311\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-1.png 590w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-1-300x158.png 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/p>\n<p style=\"text-align: justify;\">Para adicionar um formul\u00e1rio, voc\u00ea deve ir para a guia criar e depois tocar no \u00edcone do formul\u00e1rio apresentado sobre a faixa de op\u00e7\u00f5es do MS Access:<\/p>\n<h4 style=\"text-align: justify;\"><strong>Etapa 2: Coloque um bot\u00e3o<\/strong><\/h4>\n<p style=\"text-align: justify;\">Na pr\u00f3xima etapa, voc\u00ea precisa colocar um bot\u00e3o no formul\u00e1rio. Para esta tarefa, clique no \u00edcone do bot\u00e3o presente na faixa de op\u00e7\u00f5es do Access. Depois dessa posi\u00e7\u00e3o, esse bot\u00e3o no seu formul\u00e1rio.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1480\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-2.png\" alt=\"C\u00f3digo VBA para executar uma consulta no MS Access 2\" width=\"681\" height=\"418\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-2.png 681w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-2-300x184.png 300w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea notar\u00e1 que ap\u00f3s colocar o bot\u00e3o no formul\u00e1rio do Access, o Assistente de bot\u00e3o de comando aparecer\u00e1 na sua tela. Se voc\u00ea n\u00e3o precisar deste Assistente de bot\u00e3o de comando, poder\u00e1 pressionar o bot\u00e3o Cancelar.<\/p>\n<h4 style=\"text-align: justify;\"><strong>Etapa 3: abrir a tela do VBA<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para anotar o c\u00f3digo VBA do bot\u00e3o, \u00e9 necess\u00e1rio abrir a tela do editor VBA. Toque com o bot\u00e3o direito do mouse no bot\u00e3o e escolha a op\u00e7\u00e3o \u2018Build Event\u2026\u2018.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1481\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-3.png\" alt=\"C\u00f3digo VBA para executar uma consulta no MS Access 3\" width=\"431\" height=\"256\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-3.png 431w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-3-300x178.png 300w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/p>\n<p style=\"text-align: justify;\">Depois, escolha a op\u00e7\u00e3o Code Builder e toque na op\u00e7\u00e3o OK:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1482\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-4.png\" alt=\"C\u00f3digo VBA para executar uma consulta no MS Access 4\" width=\"231\" height=\"285\" \/><\/p>\n<h4 style=\"text-align: justify;\"><strong>Etapa 4: escreva o VBA para executar a consulta<\/strong><\/h4>\n<p style=\"text-align: justify;\">\u00c9 hora de escrever o c\u00f3digo VBA para executar a consulta.<\/p>\n<p style=\"text-align: justify;\">Confira o c\u00f3digo VBA completo, como mostrado no exemplo abaixo (onde &#8220;max_sales&#8221; \u00e9 o nome da consulta):<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Private Sub Command0_Click()\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>DoCmd.OpenQuery &#8220;max_sales&#8221;\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">\u00c9 assim que o VBA aparecer\u00e1 no Access:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1483\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-5.png\" alt=\"C\u00f3digo VBA para executar uma consulta no MS Access 5\" width=\"425\" height=\"204\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-5.png 425w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-5-300x144.png 300w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><strong>Etapa 5: visualizar os resultados<\/strong><\/h4>\n<p style=\"text-align: justify;\">Ap\u00f3s anotar esses c\u00f3digos VBA, economize seu tempo. Agora volte ao seu formul\u00e1rio do Access e mude para a exibi\u00e7\u00e3o de formul\u00e1rio.<\/p>\n<p style=\"text-align: justify;\">Para alternar facilmente para a exibi\u00e7\u00e3o de formul\u00e1rio, clique no \u00edcone de exibi\u00e7\u00e3o presente na guia Design. Agora, na lista suspensa, escolha a exibi\u00e7\u00e3o do formul\u00e1rio.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1484\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-6.png\" alt=\"C\u00f3digo VBA para executar uma consulta no MS Access 6\" width=\"556\" height=\"380\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-6.png 556w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-6-300x205.png 300w\" sizes=\"auto, (max-width: 556px) 100vw, 556px\" \/><\/p>\n<p style=\"text-align: justify;\">Por fim, toque no bot\u00e3o para executar a consulta &#8220;max_sales&#8221;. Agora voc\u00ea pode executar uma consulta usando o c\u00f3digo VBA simplesmente tocando no bot\u00e3o<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1485\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-7.png\" alt=\"C\u00f3digo VBA para executar uma consulta no MS Access 7\" width=\"309\" height=\"204\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-7.png 309w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Query-In-MS-Access-7-300x198.png 300w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>C\u00f3digo VBA para executar\u00a0 relat\u00f3rio no Access<\/strong><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1486\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Report-In-Access.png\" alt=\"C\u00f3digo VBA para executar\u00a0 relat\u00f3rio no Access\" width=\"592\" height=\"464\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Report-In-Access.png 1000w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Report-In-Access-300x235.png 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/VBA-Code-To-Run-Report-In-Access-768x602.png 768w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/p>\n<p style=\"text-align: justify;\">O m\u00e9todo DoCmd.OpenReport \u00e9 usado para abrir o relat\u00f3rio. Voc\u00ea pode usar esse m\u00e9todo DoCmd.OpenReport para abrir um relat\u00f3rio no modo de design, Imprimir relat\u00f3rio, Exibir relat\u00f3rio, Visualizar impress\u00e3o, Exibir layout.<\/p>\n<p style=\"text-align: justify;\"><strong>Aqui est\u00e1 a sintaxe que voc\u00ea deve usar:<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>DoCmd.OpenReport (ReportName, View, Filter, WhereCondition, DataMode, WindowMode, OpenArgs)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\">Descri\u00e7\u00e3o da sintaxe acima:<\/p>\n<p style=\"text-align: justify;\"><strong>&#8211; ReportName:<\/strong><\/p>\n<p style=\"text-align: justify;\">Indica o nome do relat\u00f3rio no banco de dados atual. Precisa de argumento e deve ser escrito entre aspas duplas.<\/p>\n<p style=\"text-align: justify;\"><strong>&#8211; Vis\u00e3o:<\/strong><\/p>\n<p style=\"text-align: justify;\">Alguns tipos comuns de exibi\u00e7\u00e3o de relat\u00f3rio, como acViewNormal, acViewPreview, acViewLayout, acViewDesign e assim por diante.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode selecionar qualquer um desses tipos para especificar seu relat\u00f3rio quando ele for aberto.<\/p>\n<p style=\"text-align: justify;\"><strong>&#8211; Filtro:<\/strong><\/p>\n<p style=\"text-align: justify;\">\u00c9 um nome de consulta que aparece no banco de dados atual. ent\u00e3o, defina-o entre aspas duplas.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>voc\u00ea tamb\u00e9m pode gostar:<\/strong><\/p>\n<p style=\"text-align: center;\"><strong><a class=\"row-title\" href=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/ms-access-colar-erro\" aria-label=\"\u201c4 corre\u00e7\u00f5es r\u00e1pidas e f\u00e1ceis para corrigir erros de colar no Access\u201d (Edit)\">4 corre\u00e7\u00f5es r\u00e1pidas e f\u00e1ceis para corrigir erros de colar no Access<\/a><\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>&#8211; WhereCondition:<\/strong><\/p>\n<p style=\"text-align: justify;\">Nesse local, a cl\u00e1usula SQL \u00e9 usada sem a palavra WHERE. Portanto, voc\u00ea precisa mant\u00ea-lo entre aspas duplas.<\/p>\n<p style=\"text-align: justify;\"><strong>&#8211; DataMode:<\/strong><\/p>\n<p style=\"text-align: justify;\">Nesse argumento, voc\u00ea deve especificar o modo de entrada de dados para o seu relat\u00f3rio. bem, o modo pode ser o modo de edi\u00e7\u00e3o ou apenas o modo de leitura.<\/p>\n<p style=\"text-align: justify;\"><strong>&#8211; Modo janela:<\/strong><\/p>\n<p style=\"text-align: justify;\">Quando um relat\u00f3rio for aberto, especifique o modo da janela.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, voc\u00ea pode abrir o relat\u00f3rio no seguinte modo: acDialog, acHidden, acIcon ou acWindowNormal.<\/p>\n<p style=\"text-align: justify;\">\u00a0\u00a0\u00a0\u00a0\u00a0+ acDialog: o relat\u00f3rio aberto \u00e9 fixo e n\u00e3o pode ser movido.<\/p>\n<p style=\"text-align: justify;\">\u00a0\u00a0\u00a0\u00a0\u00a0+ acHidden: nesse modo, o relat\u00f3rio aberto fica oculto.<\/p>\n<p style=\"text-align: justify;\">\u00a0\u00a0\u00a0\u00a0\u00a0+ acIcon: o relat\u00f3rio aberto aparece como um \u00edcone.<\/p>\n<p style=\"text-align: justify;\">\u00a0\u00a0\u00a0\u00a0\u00a0+ acWindowNormal: nesse modo, o relat\u00f3rio aberto aparece como o relat\u00f3rio de exibi\u00e7\u00e3o.<\/p>\n<p style=\"text-align: justify;\"><strong>&#8211; OpenArgs:<\/strong><\/p>\n<p style=\"text-align: justify;\">Usando esse argumento, voc\u00ea precisa especificar o registro quando o relat\u00f3rio for aberto.<\/p>\n<p style=\"text-align: justify;\">E voc\u00ea precisa mant\u00ea-lo entre aspas duplas.<\/p>\n<p style=\"text-align: justify;\"><strong>Observa\u00e7\u00e3o:<\/strong><\/p>\n<p style=\"text-align: justify;\">Todos os argumentos mencionados acima na sintaxe DoCmd.OpenReport s\u00e3o opcionais, excluindo o argumento ReportName.<\/p>\n<p style=\"text-align: justify;\">suponha que voc\u00ea tenha um formul\u00e1rio como este:<\/p>\n<p style=\"text-align: justify;\">se voc\u00ea estiver abrindo um formul\u00e1rio pela primeira vez, o registro atual \u00e9 Cate001. Para imprimir esta categoria, toque no bot\u00e3o Imprimir relat\u00f3rio. Ele exibir\u00e1 o relat\u00f3rio Cate001 junto com os produtos que ele continha.<\/p>\n<p style=\"text-align: justify;\">Para imprimir o registro Cate002, primeiro \u00e9 necess\u00e1rio alternar para esse registro. Depois toque no bot\u00e3o Imprimir relat\u00f3rio.<\/p>\n<p style=\"text-align: justify;\">Mas se voc\u00ea precisar imprimir Cate003, Cate004, Cate005 e assim por diante. Ent\u00e3o voc\u00ea deve criar um relat\u00f3rio de detalhes mestre, como mostra a figura:<\/p>\n<p style=\"text-align: justify;\">Depois disso, voc\u00ea precisar\u00e1 aplicar o c\u00f3digo VBA no procedimento de evento CmdPrint_Click, assim:<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Private Sub\u00a0CmdPrint_Click()<\/em><br \/>\n<em>DoCmd.OpenReport &#8220;RptProductByCategory&#8221; _<\/em><br \/>\n<em>, acViewReport, , &#8220;CategoryID='&#8221; &amp; txtCategoryID &amp; &#8220;&#8216;&#8221;<\/em><br \/>\n<em>End Sub<\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>Para chamar o relat\u00f3rio do VBA, tente o seguinte c\u00f3digo VBA:<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Sub runReport()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 Dim con As ADODB.Connection<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Set con = New ADODB.Connection<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 con.Open &#8220;Provider=Microsoft.Jet.OLEDB.4.0;&#8221; &amp; _<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 &#8220;Data Source=C:\\mydb.mdb;&#8221;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 DoCmd.OpenReport &#8220;rptCustomer&#8221;, acViewPreview<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>C\u00f3digo VBA do MS Access para abrir outro banco de dados<\/strong><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1477\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/MS-Access-VBA-Code-To-Open-Another-Database.jpg\" alt=\"C\u00f3digo VBA do MS Access para abrir outro banco de dados\" width=\"385\" height=\"290\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/MS-Access-VBA-Code-To-Open-Another-Database.jpg 626w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/MS-Access-VBA-Code-To-Open-Another-Database-300x226.jpg 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/MS-Access-VBA-Code-To-Open-Another-Database-320x240.jpg 320w\" sizes=\"auto, (max-width: 385px) 100vw, 385px\" \/><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea sabia que pode iniciar outro banco de dados dentro do banco de dados atual? Bem, isso pode ser feito de tr\u00eas maneiras diferentes. Ent\u00e3o \u00e9 s\u00f3 conferir\u2026!<\/p>\n<ul style=\"text-align: justify;\">\n<li>M\u00e9todo FollowHyperlink<\/li>\n<li>Concha<\/li>\n<li>Automa\u00e7\u00e3o de acesso<\/li>\n<\/ul>\n<h4 style=\"text-align: justify;\"><strong>M\u00e9todo 1: M\u00e9todo FollowHyperlink<\/strong><\/h4>\n<p style=\"text-align: justify;\">O FollowHyperlink \u00e9 um m\u00e9todo nativo do banco de dados do Access e o usu\u00e1rio pode abrir qualquer tipo de arquivo usando o programa padr\u00e3o associado a ele.<\/p>\n<p style=\"text-align: justify;\">Como \u00e9 um comando nativo do MS Access, voc\u00ea n\u00e3o pode usar outros programas como (Word, Excel, PowerPoint &#8230;).<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong><em>Public<\/em><\/strong><em> <strong>Function<\/strong> OpenDb3(sDb <strong>As<\/strong> <strong>String<\/strong>)\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0<strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> Error_Handler\u00a0\u00a0\u00a0\u00a0 <\/em><\/p>\n<p style=\"text-align: justify;\"><em>Application.FollowHyperlink sDb\u00a0Error_Handler_Exit:\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0 \u00a0<strong>On<\/strong> <strong>Error<\/strong> <strong>Resume<\/strong> <strong>Next<\/strong>\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0<strong>Exit<\/strong> <strong>Function<\/strong>\u00a0Error_Handler:\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>MsgBox &#8220;The following error has occurred&#8221; &amp; vbCrLf &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0&#8220;Error Number: &#8221; &amp; Err.Number &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0&#8220;Error Source: OpenDb3&#8221; &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0 \u00a0&#8220;Error Description: &#8221; &amp; Err.Description &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0 Switch(Erl = 0, &#8220;&#8221;, Erl &lt;&gt; 0, vbCrLf &amp; &#8220;Line No: &#8221; &amp; Erl) _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 , vbOKOnly + vbCritical, &#8220;An Error has Occurred!&#8221;\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0<strong>Resume<\/strong> Error_Handler_Exit<\/em><\/p>\n<p style=\"text-align: justify;\"><strong><em>End<\/em><\/strong><em> <strong>Function<\/strong><\/em><\/p>\n<\/blockquote>\n<h4 style=\"text-align: justify;\"><strong>M\u00e9todo 2: Concha<\/strong><\/h4>\n<p style=\"text-align: justify;\">Shell \u00e9 um comando universal que pode ser usado para executar muitas tarefas. Al\u00e9m de ter uma longa lista de recursos, tamb\u00e9m \u00e9 usado para iniciar programas e abrir arquivos. Voc\u00ea deve atribuir o arquivo .exe ap\u00f3s o que a linha de comando sempre reconhece por cada um dos arquivos exe.<\/p>\n<p style=\"text-align: justify;\">Como o MS Office \u00e9 bem registrado, \u00e9 parte da vari\u00e1vel do caminho. Portanto, voc\u00ea n\u00e3o precisa fornecer o caminho para o arquivo msaccess.exe, basta fornecer o arquivo ou o caminho para abrir.<\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea possui v\u00e1rias vers\u00f5es do MS Office instaladas no seu PC e precisa usar uma vers\u00e3o espec\u00edfica. nesse caso, voc\u00ea precisar\u00e1 incluir o caminho \/ arquivo do banco de dados execut\u00e1vel do Access.<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong><em>Public<\/em><\/strong><em> <strong>Function<\/strong> OpenDb2(sDb <strong>As<\/strong> <strong>String<\/strong>)<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0 \u00a0<strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> Error_Handler<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 Shell &#8220;cmd \/c &#8221; &amp; Chr(34) &amp; sDb &amp; Chr(34), vbHide\u00a0Error_Handler_Exit:\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0<strong>On<\/strong> <strong>Error<\/strong> <strong>Resume<\/strong> <strong>Next<\/strong>\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0<strong>Exit<\/strong> <strong>Function<\/strong>\u00a0Error_Handler:\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0 MsgBox &#8220;The following error has occurred&#8221; &amp; vbCrLf &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0&#8220;Error Number: &#8221; &amp; Err.Number &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 \u00a0&#8220;Error Source: OpenDb2&#8221; &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0 \u00a0&#8220;Error Description: &#8221; &amp; Err.Description &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0\u00a0 Switch(Erl = 0, &#8220;&#8221;, Erl &lt;&gt; 0, vbCrLf &amp; &#8220;Line No: &#8221; &amp; Erl) _<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0 \u00a0 , vbOKOnly + vbCritical, &#8220;An Error has Occurred!&#8221;\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0<strong>Resume<\/strong> Error_Handler_Exit<\/em><\/p>\n<p style=\"text-align: justify;\"><strong><em>End<\/em><\/strong><em> <strong>Function<\/strong><\/em><\/p>\n<\/blockquote>\n<h4 style=\"text-align: justify;\"><strong>M\u00e9todo 3: Access automa\u00e7\u00e3o de<\/strong><\/h4>\n<p style=\"text-align: justify;\">Access automa\u00e7\u00e3o de \u00e9 a excelente op\u00e7\u00e3o para executar qualquer a\u00e7\u00e3o desejada e, obviamente, abrir o banco de dados tamb\u00e9m.<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong><em>Public<\/em><\/strong><em><strong>Function<\/strong> OpenDb(sDb <strong>As<\/strong><strong>String<\/strong>)\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>On<\/strong><strong>Error<\/strong><strong>GoTo<\/strong> Error_Handler\u00a0 \u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>&#8216;Early binding\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>&#8216;Use a seguinte linha se estiver sendo usado no Access ou usando a refer\u00eancia do Access<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 &#8216;fornece intellisense!<\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>Dim<\/strong> oAccess\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<strong>As<\/strong> Access.Application \u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0&#8216;Late binding\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>&#8216;Use a seguinte linha se estiver sendo usado fora do Access sem uma refer\u00eancia do Access&#8217;<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Dim oAccess\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0As Object\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>Set<\/strong> oAccess = <strong>CreateObject<\/strong>(&#8220;Access.Application&#8221;)\u00a0\u00a0 \u00a0&#8216;Create a new Access instance\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>With<\/strong> oAccess\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0 .OpenCurrentDatabase sDb\u00a0\u00a0 \u00a0&#8216;Open the specified db\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0 .Visible = <strong>True<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0&#8216;Ensure it is visible to the end-user\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>.UserControl = <strong>True<\/strong>&#8216;\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 .DoCmd.OpenForm &#8220;YourFormName&#8221;\u00a0\u00a0\u00a0&#8216;Open a form?&#8217;\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0 .DoCmd.RunMacro &#8220;YourMacroName&#8221;\u00a0 &#8216;Run a Macro?\u00a0\u00a0 \u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><strong><em>End<\/em><\/strong><em><strong>With<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\"><em>Error_Handler_Exit:\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>On<\/strong><strong>Error<\/strong><strong>Resume<\/strong><strong>Next<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>If<\/strong><strong>Not<\/strong> oAccess <strong>Is<\/strong><strong>Nothing<\/strong><strong>Then<\/strong><strong>Set<\/strong> oAccess = <strong>Nothing<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>Exit<\/strong><strong>Function<\/strong><\/em><\/p>\n<p style=\"text-align: justify;\"><em>Error_Handler:\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0 MsgBox &#8220;The following error has occurred&#8221; &amp; vbCrLf &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 \u00a0&#8220;Error Number: &#8221; &amp; Err.Number &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 \u00a0&#8220;Error Source: OpenDb&#8221; &amp; vbCrLf &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0\u00a0 \u00a0&#8220;Error Description: &#8221; &amp; Err.Description &amp; _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 Switch(Erl = 0, &#8220;&#8221;, Erl &lt;&gt; 0, vbCrLf &amp; &#8220;Line No: &#8221; &amp; Erl) _\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0\u00a0\u00a0 , vbOKOnly + vbCritical, &#8220;An Error has Occurred!&#8221;\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em><strong>Resume<\/strong> Error_Handler_Exit<\/em><\/p>\n<p style=\"text-align: justify;\"><strong><em>End<\/em><\/strong><em><strong>Function<\/strong><\/em><\/p>\n<\/blockquote>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>Automatize o Access de outro aplicativo do MS Office usando o VBA<\/strong><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1473\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Automate-Access-From-Other-MS-Office-Application-Using-VBA.jpg\" alt=\"Automatize o Access de outro aplicativo do MS Office usando o VBA\" width=\"622\" height=\"381\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Automate-Access-From-Other-MS-Office-Application-Using-VBA.jpg 1000w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Automate-Access-From-Other-MS-Office-Application-Using-VBA-300x184.jpg 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/Automate-Access-From-Other-MS-Office-Application-Using-VBA-768x470.jpg 768w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><strong>Biblioteca de Objetos de Access VBA<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para automatizar o acesso de outro aplicativo do MS office usando o VBA. Ou se voc\u00ea precisar usar objetos de outros aplicativos como Microsoft Excel ou Word no Access. Para tornar essas tarefas poss\u00edveis, adicione refer\u00eancias \u00e0 biblioteca de objetos. Basicamente, existem duas op\u00e7\u00f5es para executar esta tarefa:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Vincula\u00e7\u00e3o antecipada<\/li>\n<li>Liga\u00e7\u00e3o tardia<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">O primeiro m\u00e9todo \u00e9 usado para adicionar refer\u00eancia \u00e0 Microsoft Access Object Library, imediatamente antes da execu\u00e7\u00e3o. Ele \u00e9 executado mais rapidamente e voc\u00ea ter\u00e1 acesso f\u00e1cil ao editor VBA intellisense.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, h\u00e1 chances de haver problemas de compatibilidade ao executar um programa de PC com uma vers\u00e3o diferente da biblioteca instalada.<\/p>\n<h4 style=\"text-align: justify;\"><strong>M\u00e9todo 1: Vincula\u00e7\u00e3o antecipada<\/strong><\/h4>\n<p style=\"text-align: justify;\">Neste m\u00e9todo espec\u00edfico, voc\u00ea precisa adicionar refer\u00eancia ao Microsoft Access Object.<\/p>\n<ol style=\"text-align: justify;\">\n<li>V\u00e1 para a janela do editor VBA e toque no bot\u00e3o &#8220;Ferramentas&#8221; presente na barra de menus.<\/li>\n<li>Agora, na lista suspensa, escolha a op\u00e7\u00e3o \u201cRefer\u00eancias\u201d.<\/li>\n<li>Posteriormente, a caixa de di\u00e1logo &#8220;Refer\u00eancias &#8211; Projeto 1&#8221; ser\u00e1 exibida.<\/li>\n<li>Nesta caixa de di\u00e1logo, voc\u00ea pode arrastar a barra de rolagem at\u00e9 buscar o que deseja como \u201cBiblioteca de Objetos do Microsoft Access14.0\u201d.<\/li>\n<li>Agora, marque a caixa de sele\u00e7\u00e3o presente na frente deste objeto.<\/li>\n<li>Por fim, toque na op\u00e7\u00e3o &#8220;OK&#8221;.<\/li>\n<li>Ap\u00f3s esta etapa, voc\u00ea adicionou com \u00eaxito a refer\u00eancia da biblioteca de objetos do Access.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Bem, voc\u00ea pode usar as etapas acima para adicionar bibliotecas de objetos conforme sua exig\u00eancia.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><em><strong>Ter um olhar:<\/strong><\/em><\/p>\n<p style=\"text-align: center;\"><em><strong><a class=\"row-title\" href=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/converter-accdb-para-mdb-formato-arquivo\" aria-label=\"\u201cComo converter banco de dados Access de Accdb para formato de arquivo Mdb?\u201d (Edit)\">Como converter banco de dados Access de Accdb para formato de arquivo Mdb?<\/a><\/strong><\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>Nota:<\/strong><\/p>\n<p style=\"text-align: justify;\">Use o c\u00f3digo a seguir para definir um objeto Access.Application e inici\u00e1-lo:<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Dim\u00a0objAccess\u00a0As\u00a0Access.Application<\/em><br \/>\n<em>set objAccess = new Access.Application<\/em><\/p>\n<\/blockquote>\n<h4 style=\"text-align: justify;\"><strong>M\u00e9todo 2: vincula\u00e7\u00e3o tardia<\/strong><\/h4>\n<p style=\"text-align: justify;\">Este m\u00e9todo n\u00e3o requer nenhuma adi\u00e7\u00e3o de refer\u00eancia \u00e0 biblioteca de objetos. O objeto Access.Application \u00e9 declarado como um objeto normal e iniciado como mostrado aqui:<\/p>\n<p style=\"text-align: justify;\"><em>Dim\u00a0objAccess\u00a0As\u00a0Object<\/em><br \/>\n<em>Set\u00a0objAccess = CreateObject(&#8220;Access.Application&#8221;)<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><strong>Como conectar o Access e o Excel atrav\u00e9s do VBA:<\/strong><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1475\" src=\"http:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Connect-Access-And-Excel-Through-VBA.png\" alt=\"Como conectar o Access e o Excel atrav\u00e9s do VBA\" width=\"460\" height=\"360\" srcset=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Connect-Access-And-Excel-Through-VBA.png 800w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Connect-Access-And-Excel-Through-VBA-300x235.png 300w, https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/How-To-Connect-Access-And-Excel-Through-VBA-768x601.png 768w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/p>\n<p style=\"text-align: justify;\">Nesta se\u00e7\u00e3o, discutiremos sobre como conectar o banco de dados do Access ao Excel, usando o c\u00f3digo VBA.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e1 como voc\u00ea pode configurar a conex\u00e3o com o banco de dados do Access. A cadeia de conex\u00e3o usada para o acesso 2003 (*. Mdb) e o Access 2007\/2010 (* .accdb) \u00e9 diferente porque a vers\u00e3o do banco de dados possui drivers diferentes.<\/p>\n<p style=\"text-align: justify;\">Para o banco de dados do Access 2003, o provedor \u00e9: Provider = Microsoft.Jet.OLEDB.4.0.<\/p>\n<p style=\"text-align: justify;\">Para o Access 2007\/2010, o provedor \u00e9 Provider = Microsoft.ACE.OLEDB.12.0<\/p>\n<p style=\"text-align: justify;\">Antes de executar o c\u00f3digo mencionado abaixo, voc\u00ea precisa adicionar refer\u00eancias para a Conex\u00e3o do DB do ADO.<\/p>\n<p style=\"text-align: justify;\">\u00a0Siga estas etapas para Adicionando refer\u00eancia:<\/p>\n<p style=\"text-align: justify;\"><strong>Como adicionar refer\u00eancias no excel<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Abra a tela do VB Editor pressionando Alt + F11<\/li>\n<li>Ferramentas -&gt; Refer\u00eancias\u2026<\/li>\n<li>Na lista de refer\u00eancias dispon\u00edveis, procure a &#8220;Biblioteca Microsoft ActiveX Data Objects 2.0&#8221;. Escolha a vers\u00e3o 2.0 ou qualquer outra refer\u00eancia de vers\u00e3o superior.<\/li>\n<li>Toque na op\u00e7\u00e3o OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>Conex\u00e3o com o banco de dados Access 2003<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Sub ADO_Conn()\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Dim conn As New Connection<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Dim rs As New Recordset\u00a0\u00a0\u00a0\u00a0 <\/em><\/p>\n<p style=\"text-align: justify;\"><em>strcon = &#8220;Provider=Microsoft.Jet.OLEDB.4.0;&#8221; &amp; _\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>&#8220;Data Source=E:\\Student.accdb;&#8221; &amp; _\u00a0\u00a0 <\/em><\/p>\n<p style=\"text-align: justify;\"><em>&#8220;User Id=admin;Password=&#8221;\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>conn.Open (strcon)\u00a0\u00a0\u00a0\u00a0 <\/em><\/p>\n<p style=\"text-align: justify;\"><em>qry = &#8220;SELECT * FROM students&#8221;\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>rs.Open qry, conn, adOpenKeyset\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>rs.Close\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>conn.Close\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>Conex\u00e3o com o banco de dados Access 2010\/2007<\/strong><\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><em>Sub ADO_Conn()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Dim conn As New Connection<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Dim rs As New Recordset\u00a0\u00a0\u00a0\u00a0 <\/em><\/p>\n<p style=\"text-align: justify;\"><em>strcon = &#8220;Provider=Microsoft.ACE.OLEDB.12.0;&#8221; &amp; _\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0&#8220;Data Source=E:\\Student.accdb;&#8221; &amp; _\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>&#8220;User Id=admin;Password=&#8221;\u00a0\u00a0\u00a0\u00a0 conn.Open (strcon)\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>qry = &#8220;SELECT * FROM students&#8221;\u00a0 \u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>rs.Open qry, conn, adOpenKeyset\u00a0\u00a0\u00a0\u00a0<\/em><\/p>\n<p style=\"text-align: justify;\"><em>rs.Close\u00a0\u00a0\u00a0 <\/em><\/p>\n<p style=\"text-align: justify;\"><em>conn.Close<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><strong>Embrulhar:<\/strong><\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea entender o conceito de <strong>como executar o c\u00f3digo VBA no Access<\/strong> em v\u00e1rias circunst\u00e2ncias, comece bem usando essas t\u00e9cnicas. n\u00e3o tenha medo de experimentar &#8230;!<\/p>\n<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>Sem d\u00favida, a cria\u00e7\u00e3o de banco de dados no Access com v\u00e1rios objetos, como relat\u00f3rios, formul\u00e1rios e tabelas, \u00e9 bastante &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019\" class=\"read-more button\" href=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#more-1472\" aria-label=\"Read more about Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1491,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1448],"tags":[1096,1104,1101,1106,1105,1107,1099,1098,1097,1103,1102,1100,1108],"class_list":["post-1472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-beneficios-do-uso-do-vba-no-access","tag-biblioteca-de-objetos-de-access-vba","tag-codigo-vba-do-ms-access-para-abrir-outro-banco-de-dados","tag-codigo-vba-para-executar-a-consulta-no-access","tag-codigo-vba-para-executar-o-formulario-no-access","tag-codigo-vba-para-executar-o-relatorio-no-access","tag-como-executar-o-codigo-vba-na-macro-de-access","tag-como-executar-o-codigo-vba-no-acesso","tag-conecte-o-access-and-excel-atraves-do-vba","tag-executar-codigo-vba-no-access-a-partir-do-excel","tag-execute-o-codigo-vba-no-access","tag-ms-access-codigo-vba","tag-o-que-e-o-editor-vba","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>Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019<\/title>\n<meta name=\"description\" content=\"Capture informa\u00e7\u00f5es completas sobre o c\u00f3digo VBA do MS Access e seus benef\u00edcios. Aprenda tamb\u00e9m como executar o c\u00f3digo VBA no Access em v\u00e1rias circunst\u00e2ncias.\" \/>\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\/executar-codigo-vba-no-access\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019\" \/>\n<meta property=\"og:description\" content=\"Capture informa\u00e7\u00f5es completas sobre o c\u00f3digo VBA do MS Access e seus benef\u00edcios. Aprenda tamb\u00e9m como executar o c\u00f3digo VBA no Access em v\u00e1rias circunst\u00e2ncias.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Reparo e Recuperacao do MS Access\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-04T12:14:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-21T07:01:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/run-vba-code-in-access-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"626\" \/>\n\t<meta property=\"og:image:height\" content=\"471\" \/>\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=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access\"},\"author\":{\"name\":\"Pearson Willey\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#\\\/schema\\\/person\\\/a38175469c0746d451eead783463bc78\"},\"headline\":\"Como executar o c\u00f3digo VBA no Access 2007\\\/2010\\\/2013\\\/2016\\\/2019\",\"datePublished\":\"2019-12-04T12:14:49+00:00\",\"dateModified\":\"2021-10-21T07:01:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access\"},\"wordCount\":2875,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/run-vba-code-in-access-pt.png\",\"keywords\":[\"Benef\u00edcios do uso do vba no Access\",\"Biblioteca de Objetos de Access VBA\",\"C\u00f3digo VBA do MS Access para abrir outro banco de dados\",\"c\u00f3digo vba para executar a consulta no Access\",\"c\u00f3digo vba para executar o formul\u00e1rio no Access\",\"c\u00f3digo vba para executar o relat\u00f3rio no Access\",\"como executar o c\u00f3digo vba na macro de Access\",\"como executar o c\u00f3digo vba no acesso\",\"Conecte o Access And Excel atrav\u00e9s do VBA\",\"executar c\u00f3digo vba no Access a partir do excel\",\"execute o c\u00f3digo vba no Access\",\"MS Access c\u00f3digo vba\",\"O que \u00e9 o Editor VBA\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access\",\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access\",\"name\":\"Como executar o c\u00f3digo VBA no Access 2007\\\/2010\\\/2013\\\/2016\\\/2019\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/run-vba-code-in-access-pt.png\",\"datePublished\":\"2019-12-04T12:14:49+00:00\",\"dateModified\":\"2021-10-21T07:01:33+00:00\",\"description\":\"Capture informa\u00e7\u00f5es completas sobre o c\u00f3digo VBA do MS Access e seus benef\u00edcios. Aprenda tamb\u00e9m como executar o c\u00f3digo VBA no Access em v\u00e1rias circunst\u00e2ncias.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access#primaryimage\",\"url\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/run-vba-code-in-access-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/run-vba-code-in-access-pt.png\",\"width\":626,\"height\":471,\"caption\":\"Como executar o c\u00f3digo VBA no Access\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\\\/executar-codigo-vba-no-access#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.accessrepairnrecovery.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como executar o c\u00f3digo VBA no Access 2007\\\/2010\\\/2013\\\/2016\\\/2019\"}]},{\"@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":"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019","description":"Capture informa\u00e7\u00f5es completas sobre o c\u00f3digo VBA do MS Access e seus benef\u00edcios. Aprenda tamb\u00e9m como executar o c\u00f3digo VBA no Access em v\u00e1rias circunst\u00e2ncias.","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\/executar-codigo-vba-no-access","og_locale":"en_US","og_type":"article","og_title":"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019","og_description":"Capture informa\u00e7\u00f5es completas sobre o c\u00f3digo VBA do MS Access e seus benef\u00edcios. Aprenda tamb\u00e9m como executar o c\u00f3digo VBA no Access em v\u00e1rias circunst\u00e2ncias.","og_url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access","og_site_name":"Blog de Reparo e Recuperacao do MS Access","article_published_time":"2019-12-04T12:14:49+00:00","article_modified_time":"2021-10-21T07:01:33+00:00","og_image":[{"width":626,"height":471,"url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/run-vba-code-in-access-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":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#article","isPartOf":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access"},"author":{"name":"Pearson Willey","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#\/schema\/person\/a38175469c0746d451eead783463bc78"},"headline":"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019","datePublished":"2019-12-04T12:14:49+00:00","dateModified":"2021-10-21T07:01:33+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access"},"wordCount":2875,"publisher":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#primaryimage"},"thumbnailUrl":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/run-vba-code-in-access-pt.png","keywords":["Benef\u00edcios do uso do vba no Access","Biblioteca de Objetos de Access VBA","C\u00f3digo VBA do MS Access para abrir outro banco de dados","c\u00f3digo vba para executar a consulta no Access","c\u00f3digo vba para executar o formul\u00e1rio no Access","c\u00f3digo vba para executar o relat\u00f3rio no Access","como executar o c\u00f3digo vba na macro de Access","como executar o c\u00f3digo vba no acesso","Conecte o Access And Excel atrav\u00e9s do VBA","executar c\u00f3digo vba no Access a partir do excel","execute o c\u00f3digo vba no Access","MS Access c\u00f3digo vba","O que \u00e9 o Editor VBA"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access","url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access","name":"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019","isPartOf":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#primaryimage"},"image":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#primaryimage"},"thumbnailUrl":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/run-vba-code-in-access-pt.png","datePublished":"2019-12-04T12:14:49+00:00","dateModified":"2021-10-21T07:01:33+00:00","description":"Capture informa\u00e7\u00f5es completas sobre o c\u00f3digo VBA do MS Access e seus benef\u00edcios. Aprenda tamb\u00e9m como executar o c\u00f3digo VBA no Access em v\u00e1rias circunst\u00e2ncias.","breadcrumb":{"@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#primaryimage","url":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/run-vba-code-in-access-pt.png","contentUrl":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-content\/uploads\/2019\/12\/run-vba-code-in-access-pt.png","width":626,"height":471,"caption":"Como executar o c\u00f3digo VBA no Access"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.accessrepairnrecovery.com\/blog\/executar-codigo-vba-no-access#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.accessrepairnrecovery.com\/blog"},{"@type":"ListItem","position":2,"name":"Como executar o c\u00f3digo VBA no Access 2007\/2010\/2013\/2016\/2019"}]},{"@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\/1472","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=1472"}],"version-history":[{"count":4,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/1472\/revisions"}],"predecessor-version":[{"id":2429,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/posts\/1472\/revisions\/2429"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media\/1491"}],"wp:attachment":[{"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=1472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=1472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.accessrepairnrecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=1472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}