Sabtu, 27 Februari 2021

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

Thanks Paul,

I have renamed my footer tbl field from CheckRightOT  to "Verified " and then tried with following 
 
strSql = "DELETE * FROM T_EmpOTFooter WHERE OTID= " & Forms!F_EmpOTHeader!OTID & "  And  " & Verified = 0         
   Debug.Print strSql
    CurrentDb.Execute strSql, dbFailOnError

It says Verified variable not defined. Whereas Verified is checkmark of reach record in footer table

Please help. The only Idea is to delete all those records from footer tbl (form) which are not checked.




_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

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

_._,_._,_

Tidak ada komentar:

Posting Komentar