<div>
Create a small form with a textbox for the user to enter the parameter value. &nbsp;Then modify your query to specify the criteria as:<br />
<br />
Forms!YourFormName!YourTex<wbr />tboxName<br />
<br />
<br />
If you leave the form open in the background when that report is running, the parameter will be read from the textbox on that form.
</div>


Create a small form with a textbox for the user to enter the parameter value.  Then modify your query to specify the criteria as:

Forms!YourFormName!YourTextboxName


If you leave the form open in the background when that report is running, the parameter will be read from the textbox on that form.

<div>
<div class="content wysiwyg-content">
hey,<br />
<br />
I have a series of queries that I export to an excel document via a macro that runs multiple transferspreadsheet commands. &nbsp;All of the queries that it pulls however have a parameter to imput, all are the same parameter with identical name ( it is a date). &nbsp;Currently I have to input this date for as many times as I have transferspreadsheet commands. &nbsp;Is there a way to set this parameter as part of the macro whether it be via vba code run or whatever??<br />
<br />
Thanks for any advice.<br />
<br />
Rusty
</div>
</div>


hey,

I have a series of queries that I export to an excel document via a macro that runs multiple transferspreadsheet commands.  All of the queries that it pulls however have a parameter to imput, all are the same parameter with identical name ( it is a date).  Currently I have to input this date for as many times as I have transferspreadsheet commands.  Is there a way to set this parameter as part of the macro whether it be via vba code run or whatever??

Thanks for any advice.

Rusty

access macro - can i automate parameter input for multiple transfer spreadsheet export lines in a macro?

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

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.