Create copy of a table in Access VBA

[learningthings]

I have frmEmployees where you enter the name of the employee txtEmployeeName
When you click the save button, cmdSave I want access to create a new table with the name: Transaction(employeename) which is a copy of the original table Transaction
I only want the structure to be copied, not the content
For example for an employee name megan the new table would be TransactionMegan

 

[Micron]

This is supposed to be in the Access forum, or are you trying to do this from Excel?
Seems like a bad idea to me, but perhaps take a look at Create Table statement

CREATE TABLE statement (Microsoft Access SQL)

Office developer client VBA reference

learn.microsoft.com

 

[welshgasman]

Sounds like a very terrible, terrible idea?
Perhaps review 'normalization' ?

 

[Joe4]

Yeah, creating a separate table for each person usually isn't good database design. If you wanted to query the data, you would separate queries for each table.
Generally, if you have multiple tables with the exact same structure, that is often a sign of a database that has not been designed well.
What reason do you have for doing this?
Perhaps if we understand why you are doing this, we can offer alternative suggestions that will allow you to have a "normalized" database, which will make it easier to work with.