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.
SQL Append looking for end of statment
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?
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?
Asked:
3
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
strSQL = "FROM test WHERE test.rHid = 'Rused' "