RE: [MS_AccessPros] UPDATE Statement

Do you have a form open that is bound to the PTbl_Activity?

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: no_reply@yahoogroups.com
Date: Thu, 1 Sep 2011 14:21:44 +0000
Subject: [MS_AccessPros] UPDATE Statement

Can anyone explain why the below Update statement misses one record in every instance? For example, let's say there are 50 records to be updated and there are 2 account numbers. So there are 25 records for each account number. The update statement below updates each account number but leaves only ONE record for that account number NOT updated. When I sort a query on the accounts, I can see that it is probably either the first or last record for that account that's not updated. Can anyone explain why this is happening and how to correct it?

strSQL = "UPDATE PTbl_Activity SET " & _
"QC_Complete = True, " & _
"QC_Complete_DT = Now() " & _
"WHERE PTbl_Activity.[LOAN NUMBER] = '" & iCurrLoan & "' " & _
"AND PTbl_Activity.PORTFOLIO = '" & iPortf & "';"

Thanks!
Mike

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/