docmd. run sql syntax error for update query.

[usaccess]

All,

Can you please let me know what I am doing wrong. I am getting an error
24 object required.

Also do I need to do a refresh or a requery to stay in the same
location.

thanks for your help.

us.

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) And tbldeliverabletrackingalt.Sort =
CLng(Me.Sort)

 

[Douglas J. Steele]

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) & " And tbldeliverabletrackingalt.Sort = " &
CLng(Me.Sort)

 

[usaccess]

Doug,

Thanks for your help. The object error went but now I am getting a
error message cannot update database, conversion error, and validation
run violations.

Would greatly appreciate any suggestions.

US

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) & " And tbldeliverabletrackingalt.Sort = " &
CLng(Me.Sort)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

All,

Can you please let me know what I am doing wrong. I am getting an error
24 object required.

Also do I need to do a refresh or a requery to stay in the same
location.

thanks for your help.

us.

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) And tbldeliverabletrackingalt.Sort =
CLng(Me.Sort)

 

[usaccess]

Finally figured out the problem. I had it as an after update event,
when I changed it to an after exit even, there were no record locks and
the logic worked.

thanks

Doug,

Thanks for your help. The object error went but now I am getting a
error message cannot update database, conversion error, and validation
run violations.

Would greatly appreciate any suggestions.

US

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) & " And tbldeliverabletrackingalt.Sort = " &
CLng(Me.Sort)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

All,

Can you please let me know what I am doing wrong. I am getting an error
24 object required.

Also do I need to do a refresh or a requery to stay in the same
location.

thanks for your help.

us.

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) And tbldeliverabletrackingalt.Sort =
CLng(Me.Sort)

 

[Douglas J. Steele]

Sort's likely a reserved word. If you cannot (or will not) rename the field,
at least put square brackets around it:

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) & " And tbldeliverabletrackingalt.[Sort] = " &
CLng(Me.Sort)

If that doesn't solve it, are both CaseRecordNumber and Sort numeric fields?
(That's what your SQL implies). If, for example, CaseRecordNumber happens to
be text, you'll need to put quotes around the value:

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " & Chr$(34) &
CLng(Me.CaseRecordNumber) & Chr$(34) & " And
tbldeliverabletrackingalt.[Sort] = " & CLng(Me.Sort)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Doug,

Thanks for your help. The object error went but now I am getting a
error message cannot update database, conversion error, and validation
run violations.

Would greatly appreciate any suggestions.

US

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) & " And tbldeliverabletrackingalt.Sort = " &
CLng(Me.Sort)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

All,

Can you please let me know what I am doing wrong. I am getting an error
24 object required.

Also do I need to do a refresh or a requery to stay in the same
location.

thanks for your help.

us.

DoCmd.RunSQL "UPDATE tblDeliverableTrackingAlt SET
[ActCompDate]=Date(),[EstHourstoComplete]= 0 WHERE
tbldeliverableTrackingAlt.CaseRecordNumber = " &
CLng(Me.CaseRecordNumber) And tbldeliverabletrackingalt.Sort =
CLng(Me.Sort)