{"id":281,"date":"2021-07-23T11:18:22","date_gmt":"2021-07-23T06:48:22","guid":{"rendered":"https:\/\/officebaz.ir\/ac\/?p=281"},"modified":"2022-07-17T17:53:08","modified_gmt":"2022-07-17T13:23:08","slug":"%da%a9%d8%af-%d9%85%d9%84%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3","status":"publish","type":"post","link":"https:\/\/officebaz.ir\/ac\/%da%a9%d8%af-%d9%85%d9%84%db%8c-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d8%b3\/","title":{"rendered":"\u0628\u0631\u0631\u0633\u06cc \u0635\u062d\u062a \u06a9\u062f \u0645\u0644\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0627\u06a9\u0633\u0633"},"content":{"rendered":"<p>\u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06a9\u0633\u0633 \u0646\u0648\u0634\u062a\u0647 \u0645\u06cc\u0634\u0647 \u0648 \u0628\u0627 \u0627\u0641\u0631\u0627\u062f \u0633\u0631\u0648 \u06a9\u0627\u0631 \u062f\u0627\u0631\u0647 \u0645\u062b\u0644 \u060c \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 <a href=\"https:\/\/officebaz.ir\/product\/payroll\/\" target=\"_blank\" rel=\"noopener\" data-schema-attribute=\"\">\u0645\u062f\u06cc\u0631\u06cc\u062a \u0648\u0631\u0648\u062f \u0648 \u062e\u0631\u0648\u062c \u067e\u0631\u0633\u0646\u0644<\/a> \u0648 \u06cc\u0627 <a href=\"https:\/\/officebaz.ir\/product\/officebaz-contacts-manager\/\" target=\"_blank\" rel=\"noopener\" data-schema-attribute=\"\">\u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u062e\u0627\u0637\u0628\u06cc\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0633<\/a> \u0646\u06cc\u0627\u0632 \u067e\u06cc\u062f\u0627 \u0645\u06cc\u06a9\u0646\u0646 \u06a9\u0647 \u0635\u062d\u062a \u06a9\u062f \u0645\u0644\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0633 \u0628\u0631\u0631\u0633\u06cc \u0628\u0634\u0647 \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u06a9\u0627\u0641\u06cc\u0647 \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0648 \u0627\u0646\u062c\u0627\u0645 \u0628\u062f\u06cc\u0646.<\/p>\n\n\n<h2 class=\"wp-block-heading\">\u0628\u0631\u0631\u0633\u06cc \u0635\u062d\u062a \u06a9\u062f \u0645\u0644\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0633<\/h2>\n\n\n<ol>\n<li>\u06a9\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0648\u0627\u0631\u062f \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0633 \u062e\u0648\u062f \u0634\u0648\u06cc\u062f \u0648 \u0628\u0627 \u0632\u062f\u0646 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc Alt +F11 \u0648\u0627\u0631\u062f \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc \u0634\u0648\u06cc\u062f.<\/li>\n<li>\u06cc\u06a9 \u0645\u0627\u0698\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0648 \u06a9\u062f\u0647\u0627\u06cc \u06a9\u067e\u06cc \u0634\u062f\u0647 \u0631\u0627 \u062f\u0631 \u0622\u0646 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>Function ISMELLICODE(CodeMelli As String) As Boolean\n    Dim first_number As Integer, num As Integer, counter As Integer, s As Integer, r As Integer, i As Integer\n    If IsNumeric(CodeMelli) And Len(CodeMelli) = 10 Then\n        first_number = Left(CodeMelli, 1)\n        For i = 1 To 9\n            num = Mid(CodeMelli, i, 1)\n            If num = first_number Then counter = counter + 1\n            s = s + num * (11 - i)\n        Next i\n        r = s Mod 11\n        If r &gt; 1 Then r = 11 - r\n        If r = Val(Right(CodeMelli, 1)) And counter &lt; 9 Then ISMELLICODE = True\n    End If\nEnd Function<\/pre><\/div>\n\n\n<p>\u0628\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u0631\u0627\u062d\u0644 \u0628\u0627\u0644\u0627 \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u0628\u0647 \u0641\u0627\u06cc\u0644 <a title=\"\u0645\u0627\u06a9\u0631\u0648\u0633\u0627\u0641\u062a \u0627\u06a9\u0633\u0633\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/p\/access\/cfq7ttc0k7q8\" target=\"_blank\" rel=\"noopener\" data-schema-attribute=\"\">\u0627\u06a9\u0633\u0633<\/a> \u0634\u0645\u0627 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u062f \u0628\u0627 \u0646\u0627\u0645 ISMELLICODE \u0648 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u0635\u062d\u062a \u06a9\u062f\u0645\u0644\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u0627\u06a9\u0633\u0633 \u062f\u0631 \u0642\u0633\u0645\u062a\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0639\u0645\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0641\u0631\u0645\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0633 \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u06cc\u06a9 \u062a\u06a9\u0633\u062a \u0628\u0627\u06a9\u0633 \u0628\u0627 \u0646\u0627\u0645 Text0 \u062f\u0631 \u0622\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f .<\/p>\n<ol>\n<li>\u06a9\u0646\u062a\u0631\u0644 text0 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc\u06a9\u0646\u06cc\u0645 .<\/li>\n<li>\u062f\u0631 \u0631\u0648\u06cc\u062f\u0627\u062f BeforUpdate \u06a9\u0646\u062a\u0631\u0644 text0 \u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0642\u0631\u0627\u0631 \u0645\u06cc \u062f\u0647\u06cc\u0645.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>If IsNull(Me.Text0) Then\n    MsgBox &quot; \u06a9\u062f \u0645\u0644\u064a \u0648\u0627\u0631\u062f \u0646\u0634\u062f\u0647 \u0627\u0633\u062a&quot;\n    Exit Sub\nEnd If\nIf ISMELLICODE(Text0) = False Then\n    MsgBox &quot;\u06a9\u062f \u0645\u0644\u064a \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0635\u062d\u064a\u062d \u0646\u064a\u0633\u062a&quot;\n    Cancel = True\nEnd If<\/pre><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"621\" height=\"321\" src=\"https:\/\/officebaz.ir\/ac\/wp-content\/uploads\/2021\/07\/Melli1.png\" alt=\"\u06a9\u062f \u0645\u0644\u06cc \u062f\u0631 \u0641\u0631\u0645 \u0627\u06a9\u0633\u0633\" class=\"wp-image-304\" srcset=\"https:\/\/officebaz.ir\/ac\/wp-content\/uploads\/2021\/07\/Melli1.png 621w, https:\/\/officebaz.ir\/ac\/wp-content\/uploads\/2021\/07\/Melli1-300x155.png 300w, https:\/\/officebaz.ir\/ac\/wp-content\/uploads\/2021\/07\/Melli1-600x310.png 600w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><figcaption>\u0628\u0631\u0631\u0633\u06cc \u0635\u062d\u062a \u06a9\u062f \u0645\u0644\u06cc \u0641\u0631\u0645\u0647\u0627\u06cc \u0627\u06a9\u0633\u0633<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u0628\u0631\u0631\u0633\u06cc \u06a9\u062f \u0645\u0644\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0633 \u0642\u0633\u0645\u062a \u06a9\u0648\u0626\u0631\u06cc \u0647\u0627<\/h2>\n\n\n<p>\u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0633 \u062c\u062f\u0648\u0644\u06cc \u0628\u0627 \u0646\u0627\u0645 tblContacts \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0641\u06cc\u0644\u062f\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0628\u0627 \u0646\u0627\u0645 cCode \u0627\u0632 \u0646\u0648\u0639 \u0645\u062a\u0646\u06cc \u06a9\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06a9\u062f \u0645\u0644\u06cc \u062f\u0631 \u0622\u0646 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u062d\u0627\u0644\u0627 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0648\u0626\u0631\u06cc \u0628\u0633\u0627\u0632\u06cc\u0645 \u06a9\u0647 \u06a9\u062f \u0645\u0644\u06cc \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 \u062c\u062f\u0648\u0644 tblContacts \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u062f:<\/p>\n<ol>\n<li>\u0628\u0647 \u062a\u0628 Create \u0631\u0641\u062a\u0647 \u0648 \u0631\u0648\u06cc Query Design \u06a9\u0644\u06cc\u06a9 \u0645\u06cc\u06a9\u0646\u06cc\u0645 .<\/li>\n<li>\u0627\u0632 \u062c\u062f\u0648\u0644 tblContacts \u0641\u06cc\u0644\u062f cCode \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u062a\u0627 \u0628\u0647 \u0646\u0648\u0627\u0631 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u06a9\u0648\u0626\u0631\u06cc \u0627\u0636\u0627\u0641\u0647 \u0634\u0648\u062f.<\/li>\n<li>\u062f\u0631 \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u062e\u0627\u0644\u06cc \u06a9\u0648\u0626\u0631\u06cc \u0639\u0628\u0627\u0631\u062a \u0632\u06cc\u0631 \u0631\u0627 \u0645\u06cc \u0646\u0648\u06cc\u0633\u06cc\u0645.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>Check: IIf(IsNull([cCode]),&quot;\u062e\u0627\u0644\u06cc&quot;,IIf(ISMELLICODE([cCode]),&quot;\u0635\u062d\u06cc\u062d&quot;,&quot;\u063a\u0644\u0637&quot;))<\/pre><\/div>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"566\" height=\"589\" src=\"https:\/\/officebaz.ir\/ac\/wp-content\/uploads\/2021\/07\/Melli-1.png\" alt=\"\" class=\"wp-image-303\" srcset=\"https:\/\/officebaz.ir\/ac\/wp-content\/uploads\/2021\/07\/Melli-1.png 566w, https:\/\/officebaz.ir\/ac\/wp-content\/uploads\/2021\/07\/Melli-1-288x300.png 288w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><figcaption>\u0628\u0631\u0631\u0633\u06cc \u0635\u062d\u062a \u06a9\u062f \u0645\u0644\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0633<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"> \u0635\u062d\u062a \u06a9\u062f \u0645\u0644\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0633 \u060c \u06af\u0632\u0627\u0631\u0634\u0627\u062a<\/h2>\n\n\n<p>\u0628\u0631\u0627\u06cc \u0628\u0631\u0631\u0633\u06cc \u06a9\u062f\u0645\u0644\u06cc \u062f\u0631 \u06af\u0632\u0627\u0631\u0634\u0627\u062a \u06a9\u0627\u0641\u06cc\u0633\u062a \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0642\u0628\u0644 \u06a9\u0648\u0626\u0631\u06cc \u0628\u0633\u0627\u0632\u06cc\u062f \u0648 \u06af\u0632\u0627\u0631\u0634 \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u0631\u0648\u06cc \u06a9\u0648\u0626\u0631\u06cc \u062a\u0646\u0638\u06cc\u0645 \u0646\u0645\u0627\u0626\u06cc\u062f .<\/p>\n<p>\u0648 \u06cc\u0627 \u0627\u06cc\u0646\u06a9\u0647 \u0645\u0627\u0646\u0646\u062f \u0645\u0631\u062d\u0644\u0647 \u0642\u0628\u0644 \u062f\u0631 \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u062e\u0627\u0644\u06cc \u06af\u0632\u0627\u0631\u0634 \u060c \u06a9\u062f \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u0626\u06cc\u062f.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06a9\u0633\u0633 \u0646\u0648\u0634\u062a\u0647 \u0645\u06cc\u0634\u0647 \u0648 \u0628\u0627 \u0627\u0641\u0631\u0627\u062f \u0633\u0631\u0648 \u06a9\u0627\u0631 \u062f\u0627\u0631\u0647 \u0645\u062b\u0644 \u060c&hellip;<\/p>\n","protected":false},"author":1,"featured_media":767,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"footnotes":""},"categories":[25],"tags":[28],"class_list":["post-281","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-persian","tag-28","post_format-post-format-video"],"_links":{"self":[{"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/posts\/281","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/comments?post=281"}],"version-history":[{"count":12,"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/posts\/281\/revisions"}],"predecessor-version":[{"id":787,"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/posts\/281\/revisions\/787"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/media\/767"}],"wp:attachment":[{"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/media?parent=281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/categories?post=281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officebaz.ir\/ac\/wp-json\/wp\/v2\/tags?post=281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}