Developer

Murray Brown

Gustav Brock

<div>
Like Dale said above, just create unbound form and attach a button with a macro or allow the macro to fire when the form is opened.<br><br>But again you have not explained the objectives of this , if you did we could have have helped to give a comprehensive answer
</div>


Like Dale said above, just create unbound form and attach a button with a macro or allow the macro to fire when the form is opened.

But again you have not explained the objectives of this , if you did we could have have helped to give a comprehensive answer

<div>
<div class="content wysiwyg-content fr-view">
Hi<br><br>I have the following three queries in Access. What VBA code would I use to run the query in a pop up form?<br>The second image shows one of the queries as run. They are all small<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w27/1564916/Image1.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w27/1564916/Image1.png" class="fr-fic fr-dib"></a><br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w27/1564917/Image2.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w27/1564917/Image2.png" class="fr-fic fr-dib"></a>
</div>
</div>


Image1.png

Image2.png


Hi
I have the following three queries in Access. What VBA code would I use to run the query in a pop up form?
The second image shows one of the queries as run. They are all small

Access VBA - show query in pop up

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.