property date

[slimjen]

All; Using Access 2010. I have the following code to add the current date to the current table when a new table with the same name is imported. The code is fine except now I need the date the current table was created instead the current date added. Ex. Current table name tblCur when the new tblCur is imported; the current tbl becomes tblCur05112015 but it was created on 05052015. How can I get the date the table was created which is the table property date?

'Open backend and add date to tblCur to allow for import of current data
Dim dbBackend As DAO.Database
Dim strBackendDatabase As String
Dim tdf As DAO.TableDef
  strBackendDatabase = "C:\ProjectsaccdbCurFiles.accdb"
  Set dbBackend = OpenDatabase(strBackendDatabase)
   
    For Each tdf In dbBackend.TableDefs
    If tdf.Name = "tblCur" & Format(Date, "yyyymmdd") Then Exit For
    Next tdf
    If tdf Is Nothing Then
    dbBackend.TableDefs("tblCur").Name = " tblCur " & Format(Date, "yyyymmdd")
     dbBackend.Close
     Else
    ' The archive table already exists: Take action (Rename, Delete, Warns...)
End If

[ranman256]

I have a field: IMPORTDATE, default = NOW()

It shows when the date/time the data was imported.
This uses ZERO CODE.

[John_G]

In your loop, something like tdf.datecreated should give you the information you need, without having to know what the actual table name is.

[slimjen]

So; Do I replace

If tdf Is Nothing Then
    dbBackend.TableDefs("tblCur").Name = " tblCur " & Format(Date, "yyyymmdd")
     dbBackend.Close
     Else

with

If tdf Is Nothing Then
    dbBackend.TableDefs("tblCur").Name = " tblCur " & tdf.datecreated & Format(Date, "yyyymmdd")
     dbBackend.Close
     Else

Although this doesn't look right.

[John_G]

If what you want to do is rename the table with tblCur + its own creation date try:

dbBackend.TableDefs("tblCur").Name = " tblCur " & Format(dbBackend.TableDefs("tblCur").datecreated, "yyyymmdd")

[June7]

Why are you creating new tables instead of just appending records to existing table with a field for this date value?

[orange]

slimjen,

With over 500 posts in this forum I think you should be able to give readers a better description of what exactly you are trying to do. People should not have to guess at what you are asking.

You have told us HOW you have done something, but you have not told us What that something is.

How about giving us a complete description - simple English?

[slimjen]

thank you for all of your help and comments