Originally Posted by
TheShabz
Hi all. I'm looking for a bit of code that will make a copy of the final workflow table (tableTemp) name it as something entered in a textbox on a form, then move it into one of the "favorites" folders (finalCampaigns) in access 2003.
Please and thanks.
the copy is simply Shabz. This will get you to the point where you have to move the new table:
Code:
DoCmd.CopyObject , Forms("myform").Controls("textbox"), acTable, "table"
RefreshDatabaseWindow
Good luck finding vb on manipulating the db window!