<div>
I think the Copy and/or save as Wizard from Access will prompt whether you will copy the data and/or structure (schema) from one Access db to another.<br />
<br />
HTH,<br />
<br />
Kent
</div>


I think the Copy and/or save as Wizard from Access will prompt whether you will copy the data and/or structure (schema) from one Access db to another.

HTH,

Kent

<div>
<br />
Put this code in a regular VBA module<br />
<br />
Public Function mMakeTable()<br />
<br />
&nbsp; &nbsp; With CurrentDb<br />
&nbsp; &nbsp; &nbsp; &nbsp; .Execute &quot;SELECT Query1.* INTO Table1 FROM Query1&quot; &nbsp;'Make the table<br />
&nbsp; &nbsp; &nbsp; &nbsp; .Execute &quot;DELETE Table1.* FROM Table1&quot; 'delete records<br />
&nbsp; &nbsp; End With<br />
<br />
End Function<br />
<br />
Then you can call mMakeTable() from the vba Immediate Window if you like.<br />
<br />
mx
</div>



Put this code in a regular VBA module

Public Function mMakeTable()

    With CurrentDb
        .Execute "SELECT Query1.* INTO Table1 FROM Query1"  'Make the table
        .Execute "DELETE Table1.* FROM Table1" 'delete records
    End With

End Function

Then you can call mMakeTable() from the vba Immediate Window if you like.

mx

<div>
<div class="content wysiwyg-content">
hi<br />
<br />
how can i in vba access copy a structure from query to another table in the same database<br />
<br />
for example i want to make a table the the name will be table1 and it's will be emtry but the structure will be like the &nbsp;in the query &quot;Query1&quot;<br />
<br />

</div>
</div>


hi

how can i in vba access copy a structure from query to another table in the same database

for example i want to make a table the the name will be table1 and it's will be emtry but the structure will be like the  in the query "Query1"



how can i in access vba copy a query structure in the same database

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.