<div>
You probably need to refresh the tables collection between creating the table and actually referencing it. &nbsp;
</div>

You probably need to refresh the tables collection between creating the table and actually referencing it.  

<div>
<div class="content wysiwyg-content">
 
Hi, 
 
I have a table called Button. It has the following fields: ButtonType, CControl_ControlLabel, CControl_Height, CControl_Width. 
 
I want to create a recordset, to later insert it into that table. 
 
mDAORecordSet.Fields.Append &quot;ButtonType&quot;, adVarChar, 255, adFldUpdatable 
mDAORecordSet.Fields.Append &quot;CControl_ControlLabel&quot;, adVarChar, 255, adFldUpdatable 
mDAORecordSet.Fields.Append &quot;CControl_Height&quot;, adInteger, , adFldKeyColumn 
mDAORecordSet.Fields.Append &quot;CControl_Width&quot;, adInteger, , adFldKeyColumn 
mDAORecordSet.OpenRecordset 
 
mDAORecordSet.AddNew 
&nbsp; mDAORecordSet!ButtonType = &quot;Admin&quot; 
&nbsp; mDAORecordSet!CControl_ControlLabel = &quot;No&quot; 
&nbsp; mDAORecordSet.Update 
Next 
 
 
But I have &quot;type mistmatch&quot; error at &quot;ButtonType&quot; 
 
 
Thanks for any help 

</div>
</div>


Hi,

I have a table called Button. It has the following fields: ButtonType, CControl_ControlLabel, CControl_Height, CControl_Width.

I want to create a recordset, to later insert it into that table.

mDAORecordSet.Fields.Append "ButtonType", adVarChar, 255, adFldUpdatable
mDAORecordSet.Fields.Append "CControl_ControlLabel", adVarChar, 255, adFldUpdatable
mDAORecordSet.Fields.Append "CControl_Height", adInteger, , adFldKeyColumn
mDAORecordSet.Fields.Append "CControl_Width", adInteger, , adFldKeyColumn
mDAORecordSet.OpenRecordset

mDAORecordSet.AddNew
  mDAORecordSet!ButtonType = "Admin"
  mDAORecordSet!CControl_ControlLabel = "No"
  mDAORecordSet.Update
Next


But I have "type mistmatch" error at "ButtonType"


Thanks for any help


Create a recordset in DAO under VB6 environment

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.