Renaming a file to the current date

  • Thread starter Thread starter NealUK
  • Start date Start date
N

NealUK

Is there a macro that i can run that would allow me to automatically rename
a file from, for example, job1, to 0412job1, where 0412 is the current date
(or at least something similar).
I would then need to take this file, copy, and then paste it back as
structure only.
Is this possible with access macros?
Any help much appreciated
many thanks
Neal


--
 
I am not sure if you are talking about a file or a table.
But here is how to put the Mthday in front of the name
Try this as the filename in macro

="c:/dir/"&Format(Date(),"ddmm")&"filenname"

If you want to copy a table try
=Format(Date(),"ddmm")&"newtablename"

Jim
 
That's exactly what i need to change the name from importlistcont to
0512importlistcont.
Many thanks
When i copy the table in the second part, it makes a copy of the table, so
that i have 0512importlistcont and importlistcont. Both with data.
What i was hoping to do was to copy 0512importlistcont, and paste its
structure rather than contents and structure.
Is this at all possible?
many thanks again
Neal
 
I do not know how to copy table structure only but why
don't you create an empty table and use that like a
template for copying. It won't take up any space

Jim
 
I found out that i can use TransferDatabase, to the existing database, and
copy structure only
 
Back
Top