You can also access the Rename (macro) command via VBA using the
following code:
DoCmd.Rename objecttype:=acTable, oldname:="tblClubs", newname:="Club
List 2006"
This syntax shows how to do it using Named Arguments. You can change
the order of the arguments if you like; in order to do this, simply put
the argument name a colon and equals sign (":=") and the argument value.
--- In [email protected], "Richard" <[EMAIL PROTECTED]>
wrote:
>
> THere's a "Rename" command in the Macros section of Access. It takes
> the following arguments: "New Name", "Object Type" and "Old
> Name"...You might be able to figure out how to work that into your
> design somehow.
>
> Hope this helps!
>
> Alienwebmaster
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
