<div>
What is your concrete problem?<br />
<br />
E.g.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42359387-1"><span>CurrentDb.Execute &quot;INSERT INTO myTable ( Payload ) VALUES ( '&quot; &amp; Replace(Nz(txtTextBox.Value, &quot;&quot;), &quot;'&quot;, &quot;''&quot;) &amp; &quot;');&quot;</span>
</code></pre>
</div>


<div>
Have an Access database with linked sql server table. &nbsp;<br />
<br />
In Access I have a main form with a textbox that allows user to input number into which will populate another form datasheet (from linked SQL table). &nbsp;Need to dump data into another linked SQL table from the data defined by the textbox value in Access by writing a stored procedure. &nbsp;just need to know how to define this textbox value in SQL Server query
</div>


<div>
<div class="content wysiwyg-content">
MS Access vba create query to Insert data into SQL Server table based on textbox value
</div>
</div>


MS Access vba create query to Insert data into SQL Server table based on textbox value

MS Access vba Insert data into SQL Server table based on textbox value

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.

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.