Append today's date to the name of the table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Irina - 02 May 2008 19:30 GMT

I have a macro that runs CopyObject command
to copy one table from the database into another access table.
I want to add a current date to the name of the table in the
new database when the macro runs. Is there a way to add a date
at the end of the table name?
for example. instead of objectName tblClient
I want to do something like this

tblClient&" "&Date() so it copies the table as tblClient 05-02-2008
thanks to anyone who can help me with this

Reply to this Message

KARL DEWEY - 02 May 2008 21:51 GMT

I do not know if it will work but it would need to be like this ---
tblClient&" "&Format(Date(), "mm-dd-yyyy")

Signature

KARL DEWEY
Build a little - Test a little

> I have a macro that runs CopyObject command
> to copy one table from the database into another access table.
[quoted text clipped - 6 lines]
> tblClient&" "&Date() so it copies the table as tblClient 05-02-2008
> thanks to anyone who can help me with this

Reply to this Message

Steve Schapel - 02 May 2008 22:36 GMT

Irina,

I think Karl's idea will work, except you would put a = in front, and
also spaces around the &s like this:
="tblClient " & Format(Date(),"mm-dd-yyyy")

Having said that, I would caution that this sounds like a very
suspicious idea, if you don't mind me saying so. I would really suggest
you get some further advice on creating tables based on divisions of data.

Signature

Steve Schapel, Microsoft Access MVP

> I do not know if it will work but it would need to be like this ---
> tblClient&" "&Format(Date(), "mm-dd-yyyy")

Reply to this Message

Irina - 08 May 2008 15:58 GMT

Steve -
the reason why I wanted to export the table as a copy with a date
into another DB is for backup purposes in case something gets screwed up
in the actual db. But instead what I can do is do a backup of the actual
database.
I think... I am not sure if I have to do this using task scheduler or what.
what do you think?

> Irina,
>
[quoted text clipped - 8 lines]
> > I do not know if it will work but it would need to be like this ---
> > tblClient&" "&Format(Date(), "mm-dd-yyyy")

Reply to this Message

Rate this thread: