Create a New Table Automatically in a Database
Posted on 2014-01-13
I have created a database using MS Access 2010. Overall the database is very simple and is used to keep records of quotes that we submit to customers. I am trying to create a way so that once a quote is approved we can then use possibly a macro that will create its own table within the database in which we can then enter the order details. It would be ideal if the new table is created with pre-determined formatting.
Example: a quote is approved. I click on the macro that possible copies an existing template table that has the formatting in place. The table opens. Our representative then enters the order list into the new table and then saves the table using a job specific number that we create internally.
Any help is greatly appreciated!