Hello all, I have a database that I would like to create a process that after the user fills in the form the data in the table is copied to another database as a table.
I was goofing around last night with some old databases to get the code to work. I was successful getting the table to copy over to the other database, but what I need to try and get to work is to have the option to enter a table name at the time of the process. Many users will be entering data into their own database and copying the table to the master database. But I cannot have names to be the same. I would like the table be the name from a text field on a form. I cannot use a link table scenario because of the permissions nightmare that would ensue and the type of sensitive data that would be entered. We have been drafting this database for a month and keep coming up with roadblocks because of the security issues. What I have so far that works getting the table to the other database. I tried to dim a string for the text field for a form reference. But when I run the process an error appears that states that it cannot find the table. The table does not exist yet. Is there a way to have a sql statement create a table based on a form reference? Private Sub Command0_Click() Dim stText As String stText = txtName DoCmd.CopyObject "Computer Systems", tblSupervisor, acTable, "NonSupervisor" End Sub Jim Wagner
