User create table

[joe789]

Hi Folks,

Is it possible for me to create a command button, that when clicked, would ask a user what name s/he wanted to give a table and then to make an exact copy of the already existing table to the table name the user specifies?

Further more, is it possible to create another command button, that when clicked, would ask the user what table that already exists s/he would like to append all records to an already existing table but to delete all data from that already existing table first. If possible, is it possible to have a little windows that would allow the user to select which table s/he would be interested in appending to the already existing table?

Any help would be greatly appreciated.

Thank you very much,

Joe

 

[IMO]

Why would you want to copy an existing table to the same db?

IMO

 

[joe789]

It is a database for a non-profit government agency to perform aduit control (make sure no one is abusing the system). The database is pretty complicated, but I was thinking that each time someone goes on an audit, they can use the database to create a template/input form that they can use to chart everything given criteria that they select which populates the template in a very unique way. Given the nature of the database, I would like the ability to copy the template table to a new table that the user would specify when s/he is finished with the audit. In this way, the audits would be archieved and saved. In order to clean the template, it would be deleted and re-created with new criteria for a new audit. If the user wanted to load an archieved template, the system would dump the template and load the archieved table that the user would select, thus populating the query again. Since the audit control people don't know access very well, I automatted the entire process and it is now very easy for them to use. However, the only other option I can think of adding would be two command buttons:

The first would enable the user to copy the template table to another table that s/he specifies (that is where a prompt after the user hits a command button asking them to specify a detailed and meaningful name of the table to create that would copy the template table would come handy.)

The second would enable the user to load an archieved template (dump all data already in the template and append all data in the archieved template to the template) table, thus enabling them to use all the report features in the database easily for the previous audits. To make it easier for the user, it would be nice if once this 2nd command button is clicked a pop-up window would show all the tables in the database and the user can select a table to load. If that isn't possible, a prompt would be nice where the user can enter the name of the archieved table to be appending to the template table right after the template table is dumped of data automatically.

Is this possible and any help would be very greatly appreciated.

Thank you very much,

Joe

 

[joe789]

I figured out how to do it. Everything work great. I would like to add one more option, but I have no idea if this is possible and I don't know VBA very well ... the users of the database may not remember ALL the table names they specify for archieved audits. Therefore, would it be possible to somehow show a list of all table that exist in the database in a subform or a box so that the user can see all the archieved tables s/he has created? Is this possible? If not, perhaps each time the user archieves a table, the name of that table that the user specifies can be appended to a table, so that a subform in the mainform can show all the tables the user has created. This I think would involve taking the string that is passed from the user to the program when creating the archieved table and somehow appending that string to a table. Any ideas?

Any help would be greatly appreciated,

Thank you very much,

Joe