copyobject table naming in macro

[benposting]

Simple question, but im fairly new to Access...
What would the easiest way, when creating a macro, with the action -
'copy object', to automatically create the new table name with todays
date?

 

[david epsom dot com dot au]

In the New Name field, put
=Format(Date(),"yymmdd")


That is NOT a good idea.

What you SHOULD want is a table with a date field.

What are you trying to do?

(david)

 

[benposting]

Essentially trying to make a macro to update itself, but in the process
copying the table from current database to a backup database...
So Macro would be as follows: (assuming table name is custsum)
- copyobject (copy custsum to secondary database - which is why i need
it to automatically name itself with current date)
- transfertext (import txt file into new table)
- (would like to also move all the data from new table into custsum
overwriting old data but keeping same format and relationships)

the transfertext got no prob with, the copyobject- just wondering how
to go about naming, and the moving data am having a bit of trouble with
thanks for your help

 

[david epsom dot com dot au]

Glad I could help.

I'm still doubtful. Will you ever want to use this
backup data? It will be a lot easier to handle programmatically
if the backup date is a field value instead of a table name.

(david)