<div>
Thanks for the prompt reply anyway what I'm trying to do is &nbsp;to have command button will auto type text into boxes from already specific open webpage based on the word before and the word after
</div>


Thanks for the prompt reply anyway what I'm trying to do is  to have command button will auto type text into boxes from already specific open webpage based on the word before and the word after

<div>
<div class="content wysiwyg-content">
Hi, What I'm trying to do is a button for pasting the last copied in the clipboard into a table, manualy it does what I want by selecting the table right click and Paste, <br />
I did this code below will paste into a textBox but my intention is to paste in the table<br />
Private Sub Command100_Click()<br />
On Error Resume Next<br />
Me!Text9.SetFocus<br />
&nbsp; &nbsp;DoCmd.RunCommand acCmdPaste<br />
&nbsp; &nbsp;Exit Sub
</div>
</div>


Hi, What I'm trying to do is a button for pasting the last copied in the clipboard into a table, manualy it does what I want by selecting the table right click and Paste, 
I did this code below will paste into a textBox but my intention is to paste in the table
Private Sub Command100_Click()
On Error Resume Next
Me!Text9.SetFocus
   DoCmd.RunCommand acCmdPaste
   Exit Sub

MS Access Macro for paste whole table from clipboard

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.