create form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am new to this and any support is greatly appreciated.

I need to create a database that holds several records by month. I would
like to keep these records in separate tables. I want to create a form that
has two command buttons (Create a new table and Exit). I would like for the
Create a New Table button to automatically create tables and allow me to name
the tables and then began entering data once created. I have created the
dataentry table and TableList to hold each new table created.

Hope I explained enough. Thanks.
 
Loulou said:
Hello, I am new to this and any support is greatly appreciated.

I need to create a database that holds several records by month. I
would like to keep these records in separate tables. I want to
create a form that has two command buttons (Create a new table and
Exit). I would like for the Create a New Table button to
automatically create tables and allow me to name the tables and then
began entering data once created. I have created the dataentry table
and TableList to hold each new table created.

Hope I explained enough. Thanks.
Click to expand...
If you mean keep the records for each month in a separate table. DON'T.
It is a very bad idea.
Just keep everything in one table and build queries to view by month.
That way when you decide to compare months or view by week, quarter, or year
it's just another query.
 
Rather than create a new table for each month, simply add a field to your
table to record the date of each record. Then you can, easily, filter your
data entry form and reports by month.
 
Back
Top