Jan 24, 2005 #1 Xenocide Programmer Joined Jan 20, 2005 Messages 76 Location CA Hi strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = txt1.Value WHERE IdEngagementA = lst1.Column(1)" it create an error about a no definition for lst1.Column (the last one) somebody know what it is?
Hi strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = txt1.Value WHERE IdEngagementA = lst1.Column(1)" it create an error about a no definition for lst1.Column (the last one) somebody know what it is?
Jan 24, 2005 1 #2 RoyVidar Instructor Joined Jun 16, 2000 Messages 6,606 Location NO If this is on one line, I suppose [tt]strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = txt1.Value WHERE IdEngagementA = " & lst1.Column(1)[/tt] If IdEngagementA is a text field, you'll need single quotes (text delimiters) Roy-Vidar Upvote 0 Downvote
If this is on one line, I suppose [tt]strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = txt1.Value WHERE IdEngagementA = " & lst1.Column(1)[/tt] If IdEngagementA is a text field, you'll need single quotes (text delimiters) Roy-Vidar
Jan 24, 2005 #3 RoyVidar Instructor Joined Jun 16, 2000 Messages 6,606 Location NO Oh, and concatenation goes also for the text control - and, single quotes should MontantActuel be a text field. [tt]strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = " & txt1.Value & " WHERE IdEngagementA = " & lst1.Column(1)[/tt] Roy-Vidar Upvote 0 Downvote
Oh, and concatenation goes also for the text control - and, single quotes should MontantActuel be a text field. [tt]strSQL1 = "UPDATE [" & Me!lst1.Column(0) & "] SET MontantActuel = " & txt1.Value & " WHERE IdEngagementA = " & lst1.Column(1)[/tt] Roy-Vidar
Jan 24, 2005 Thread starter #4 Xenocide Programmer Joined Jan 20, 2005 Messages 76 Location CA Thanks it's not doing the error anymore.. although it's updating 0 line in my table I'll find what cause that eventually htanks for the help again Upvote 0 Downvote
Thanks it's not doing the error anymore.. although it's updating 0 line in my table I'll find what cause that eventually htanks for the help again
Jan 24, 2005 #5 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR WHERE IdEngagementA = '" & lst1.Column(1) & "'" Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 Upvote 0 Downvote
WHERE IdEngagementA = '" & lst1.Column(1) & "'" Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
Jan 24, 2005 Thread starter #6 Xenocide Programmer Joined Jan 20, 2005 Messages 76 Location CA Thanks for the help but someone was faster then you PHV and if it's for the 0 line updated that's not it.. prally some other error. I'll find it eventually Upvote 0 Downvote
Thanks for the help but someone was faster then you PHV and if it's for the 0 line updated that's not it.. prally some other error. I'll find it eventually
Jan 24, 2005 #7 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR Have you solved your problem selecting IdEngagementA differently for each table ? Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 Upvote 0 Downvote
Have you solved your problem selecting IdEngagementA differently for each table ? Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
Jan 25, 2005 Thread starter #8 Xenocide Programmer Joined Jan 20, 2005 Messages 76 Location CA sorry for the big delay but I left work before yur message and I don't do anything work related after the hours For the selecting of IdEngagement yeah it was solved. Redoing the table seem like it solved it all. Upvote 0 Downvote
sorry for the big delay but I left work before yur message and I don't do anything work related after the hours For the selecting of IdEngagement yeah it was solved. Redoing the table seem like it solved it all.