Dim strSQL As String
Dim RecordName,tableName As String
RecordName = Me.rHid 'changed to Rused- name conflict?
TableName= "table" & me.RN
strSQL = "INSERT INTO tablename ( rHid, Fps1, Fps2, Fps3, Fps4, Fps5, Fps6, Fps7 )" _
"SELECT test.rHid, test.Fps1, test.Fps2, test.Fps3, test.Fps4, test.Fps5, test.Fps6, test.Fps7" _
"FROM test WHERE (((test.rHid)="RecordName"))"
strSQL = "INSERT INTO tableName ( rHid, Fps1, Fps2, Fps3, Fps4, Fps5, Fps6, Fps7 )"
strSQL = "SELECT test.rHid, test.Fps1, test.Fps2, test.Fps3, test.Fps4, test.Fps5, test.Fps6, test.Fps7"
strSQL = "FROM test WHERE ((test.rHid) = "Rused"))"
highlights ^^^^^
CurrentDb.Execute strSQL, dbFailOnError
I tried extra ",extra() and spaces and the two types above
BTY is one better than the other?
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
strSQL = "FROM test WHERE test.rHid = 'Rused' "