-
okay, i figured it out..
i assign the name and time to a variable..
dim thyme as string
thyme = "NewTable_" & Format(Now(),"hhnnssAMPM")
this works:
strSQL = "SELECT * INTO " & thyme & _ etc...etc..
thankx for your replys,
i would like to add the time this table was
created by appending it to the name of the
newly created table, eg: NewTable083354PM
i have tried to concenate a format(now(),"hhnnss")
to the [NewTable] part with no success.
is this even possible?
strSQL = "SELECT * INTO [NewTable] " & _
"FROM MyTable " & _
"WHERE MyTable.Process_Time = " & Me.Text1(1)
db.Execute strSQL, dbFailOnError
tried this with no luck:
thyme = Format(Now(), "hhnnssAMPM")
//gets the correct time but doesn't append it to table name
strSQL = "SELECT * INTO [NewTable]" & thyme & _ etc..etc..
[Edited by larryn on 06-05-2000 at 01:07 PM]
-
I think that if you try this it will work
str1 = Format(Now, "hh") & Format(Now, "mm") _
& Format(Now, "ss")
-
Your problem might be with the right bracket(]). I would try this:
strSQL = "SELECT * INTO [NewTable" & _
Format(Now(), "hhnnssAMPM") & _
"] FROM MyTable " & _
"WHERE MyTable.Process_Time = " & Me.Text1(1)
