[AccessD] CopyObject macro

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Tue Nov 4 16:01:37 CST 2003


Thanks a lot Stuart, I did put it as RunCode in Macro and called the
function (this had to be a part of one large macro)
:--)

> 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.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail




More information about the AccessD mailing list