Stuart McLachlan
stuart at lexacorp.com.pg
Tue Nov 4 15:42:55 CST 2003
On 4 Nov 2003 at 15:28, Oleg_123 at xuppa.com wrote: > Hey Group > > Is there a way to,(using a CopyObjectMacro) to copy a table, an save under > the same name + today's date ? > > CopyObject macro can't take a function as an argument, it needs a simple string, so without finding the entry in msysAccessObjects and hacking it, there is no way that I can think of. Why do you need to use a CopyObject macro. How about a function: Function CopyTable(TableName as String) DoCmd.CopyObject , TableName & Format$(Date, "yymmdd"), acTable, TableName End Function If you *really* need a macro , create one which calls the function using Runcode. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.