<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have an Excel file here that contains a UserForm object containing multiple textboxes and comboboxes that I would like to auto-fill with data from MS Access if I can. Specifically, when I'm viewing a particular record within an Access form, I'd like to click a button that launches the Excel application/workbook and references specific textbox and combobox items on the UserForm, populating them with values from that particular database record currently being viewed in MS Access.<br />
<br />
From with Excel VBA, I can currently do this with the following code. 
<pre><code id="code-10-28737098-1">UserForm1.TextBox1 = &quot;This is test data.&quot;</code></pre>
 Just trying to get from MS Access to MS Excel.<br />
<br />
<br />
<br />
Is this possible? Any help or suggestions would be appreciated!
</div>
</div>


Hi,

I have an Excel file here that contains a UserForm object containing multiple textboxes and comboboxes that I would like to auto-fill with data from MS Access if I can. Specifically, when I'm viewing a particular record within an Access form, I'd like to click a button that launches the Excel application/workbook and references specific textbox and combobox items on the UserForm, populating them with values from that particular database record currently being viewed in MS Access.

From with Excel VBA, I can currently do this with the following code. (CODE) Just trying to get from MS Access to MS Excel.



Is this possible? Any help or suggestions would be appreciated!

Populate Excel UserForm textbox with data from MS Access form

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.