Senin, 01 Maret 2021

Re: [MSAccessProfessionals] HIDE BY DEFAULT MSG

hello Sayyed,

>"remove by default msg"

do you mean the feedback when you run the code?

Use Currentdb.Execute SQL
or db.Execute WHERE db is CurrentDb and then released when the procedure is done

not DoCmd

~~~

this syntax looks wrong:
"DELETE * FROM T_EmpOTFooter WHERE CheckRightOT.value = false " And " OTID = " & Forms!F_EmpOTHeader!OTID

perhaps this, if OTID is a number?
"DELETE * FROM T_EmpOTFooter WHERE CheckRightOT.value = false And OTID = "
& Forms!F_EmpOTHeader!OTID

if OTID is text,  then this:
& "'" & Forms!F_EmpOTHeader!OTID & "'"

kind regards,
crystal

On 3/1/2021 12:06 AM, SAYYED ASHFAQUE HUSSAIN via groups.io wrote:

Hi,  I need to remove by default msg of my below code. Is this possible?    strSQL = "DELETE * FROM T_EmpOTFooter WHERE CheckRightOT.value = false " And " OTID = " & Forms!F_EmpOTHeader!OTID    Thanks in advance.

Tidak ada komentar:

Posting Komentar