Using date function in access

  • Thread starter Thread starter gltoons
  • Start date Start date
G

gltoons

I am writing a "make table" query to backup an existing table. I want
the table name to reflect the current date but I do not want to have
to enter the table name everytime I run this query. Is there a way to
get access to insert the current date in a table name for you?
 
You don't really need to use a 'make table' query for this. Calling the
CopyObject method in code will do it, e.g.

DoCmd.CopyObject _
NewName:="YourTable" & Format(VBA.Date,"yyyymmdd"), _
SourceObjectType:=acTable, _
SourceObjectName:="YourTable"

using the yyyymmdd format for the date means that the new table names will
automatically sort in date order in the database window.

Ken Sheridan
Stafford, England
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
VBA - retrieve data on last create named range from previous inserted named range 0
Using the latest date in a table as criteria 4
Updating tables when you input new data 0
How to export table from outlook into ms access table? 0
Stored date is not being recognised 1
Add current date to file name when exporting to Excel 2
DB2 linked tables have underscore in column names. 0

Back
Top