Re: [MSAccessProfessionals] Type Mismatch Run-time error ...Tired of this issue...

Thanks Duane Hookom,

The debug print is giving following result:

DELETE * FROM T_EmpOTFooter WHERE OTID= 3 And Verified = 0

It means he is not picking up Verified field data. For this main record # 3, there are 5 footer records out of which 2 are unchecked so I  need them to delete from footer tbl and keep rest 3 saved.

And when it is reaching to execute below:
CurrentDb.Execute strSql, dbFailOnError
It produces Run-time error 3622
"You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an Identity Column.

When I tried with below:
 strSql = "DELETE * FROM T_EmpOTFooter WHERE OTID= " & Forms!F_EmpOTHeader!OTID & " And Verified = 0 dbSeeChanges"

Syntax error - Missing Operator

Please advise...

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115870) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_