What is the VBA code for creating an empty table from an existing empty table? Thx.
B Bill H. Jan 27, 2009 #1 What is the VBA code for creating an empty table from an existing empty table? Thx.
F fredg Jan 27, 2009 #2 What is the VBA code for creating an empty table from an existing empty table? Thx. Click to expand... DoCmd.CopyObject , "NewTableName", acTable, "OldTableName"
What is the VBA code for creating an empty table from an existing empty table? Thx. Click to expand... DoCmd.CopyObject , "NewTableName", acTable, "OldTableName"
B Bill H. Jan 31, 2009 #3 Thank you! but how to automatically delete the newtablename if it already exists without getting the access prompt?
Thank you! but how to automatically delete the newtablename if it already exists without getting the access prompt?
