Copy and rename linked table to local table
Posted on 2014-02-15
Hello~ I found the following code that very nicely copies and prompts the end user to enter a date that is included in the copied table's name. Because I am not familiar with VBA, can anyone assist in amending the following so that it will copy and prompt the end user for a date to be concatenated with the table name but for a linked table to a local table:
Dim strOldTable As String
Dim strPrompt As String
strPrompt = InputBox("Enter date table is copied")
DoCmd.CopyObject , "Test Table" & "_" & strPrompt, acTable, "Test Table"
The result is "Test Table_2/15/14" (or whatever date the end user enters). Any help is great appreciated.