help with creation of a new table.

[junior1505]

Greetings of the day.
We are creating a new db for our use here. Name of the db is 'samay'.
We are in need of a vba code to create a new dynamic table at the start of every month with the fields, Number, Name, date and time.
can anyone please help me.
Regards.

 

[Shallo9]

Can you not use a Make table Query to accomplish this task and trigger this query every month (or as and when needed).

 

[missinglinq]

Creating a new Table for each month, with identical Fields, smacks of very poor database design! I suspect that you should have a single Table with an additional Field, to be used to identify the month the data pertains to, to replace these multiple Tables.

In the long run this is going to save you work, probably in the short term, as well!

Linq ;0)>