asked on Sql code problem
Can some one see what I am doing wrong here? I get variable not defined on ChangeCheck. Probably missed a dammed commer somewhere
strSQL = _
"INSERT INTO Sets (ItemNumber, DoorNumber, Batch, Location, ChangeCheck) " & _
"SELECT " & lngNewID & " AS ItemNumber, DoorNumber, Batch, Location, ChangeCheck " & _
"FROM Sets " & _
"WHERE (ItemNumber=" & lngOldID And ((ChangeCheck) = -1)
CurrentDb.Execute strSQL, dbFailOnError
strSQL = _
"INSERT INTO Sets (ItemNumber, DoorNumber, Batch, Location, ChangeCheck) " & _
"SELECT " & lngNewID & " AS ItemNumber, DoorNumber, Batch, Location, ChangeCheck " & _
"FROM Sets " & _
"WHERE (ItemNumber=" & lngOldID And ((ChangeCheck) = -1)
CurrentDb.Execute strSQL, dbFailOnError
Microsoft Access
Last Comment
Derek Brown
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you
ASKER
Gustav are you on the list of people that can contract for projects? I have a simple one that need help
Yes, feel free: gustav[@]cactus.dk
ASKER
Hi Gustav
I believe it has to go through EE How do I find you?
I believe it has to go through EE How do I find you?
ASKER
Hi Gustav
Here is the Link to project
Normally I would suggest reading the posts but I would not if I were you. The problem as Pat Hartman says is simple. each expert commenting has made it more and more difficult. If you just leave a message I will post you a simple question
https://www.experts-exchange.com/gigs/2507/Solving-a-query-problem.html
Here is the Link to project
Normally I would suggest reading the posts but I would not if I were you. The problem as Pat Hartman says is simple. each expert commenting has made it more and more difficult. If you just leave a message I will post you a simple question
https://www.experts-exchange.com/gigs/2507/Solving-a-query-problem.html