{"id":569,"date":"2004-05-16T04:46:43","date_gmt":"2004-05-16T09:46:43","guid":{"rendered":"http:\/\/blogs.terrorware.com\/geoff\/2004\/05\/16\/1084700863812019\/"},"modified":"2004-05-16T04:46:43","modified_gmt":"2004-05-16T09:46:43","slug":"1084700863812019","status":"publish","type":"post","link":"http:\/\/blogs.terrorware.com\/geoff\/2004\/05\/16\/1084700863812019\/","title":{"rendered":"1084700863812019"},"content":{"rendered":"<p><strong>updating online inventory from access<\/strong><\/p>\n<pre>\nPrivate Sub compute_status()\n  Dim Order_date As String\n  Dim Receipt_date As String\n  Dim resale_date As String\n  Dim returned_date As String\n  Dim cancelled_date As String\n  \n  Order_date = Nz(Me.Order_date, \"NULL\")\n  Receipt_date = Nz(Me.Receipt_date, \"NULL\")\n  resale_date = Nz(Me.resale_date, \"NULL\")\n  returned_date = Nz(Me.returned_date, \"NULL\")\n  cancelled_date = Nz(Me.order_cancelled_date, \"NULL\")\n\n  If Order_date = \"NULL\" Then\n    If resale_date = \"NULL\" Then\n      Me.status = \"In Stock\"\n    Else\n      Me.status = \"Sold\"\n      DoCmd.RunSQL (\"UPDATE inventory1 SET sold = 1 WHERE inventory_id =\" &amp; Me.inventory_ID)\n    End If\n  Else\n    If returned_date = \"NULL\" And cancelled_date = \"NULL\" Then\n      If resale_date = \"NULL\" Then\n        If Receipt_date = \"NULL\" Then\n          Me.status = \"On Order\"\n        Else\n          Me.status = \"In Stock\"\n        End If\n      Else\n        Me.status = \"Sold\"\n        DoCmd.RunSQL (\"UPDATE inventory1 SET sold = 1 WHERE inventory_id =\" &amp; Me.inventory_ID)\n      End If\n    Else\n      Me.status = \"Rescinded\"\n      DoCmd.RunSQL (\"UPDATE inventory1 SET sold = 1 WHERE inventory_id =\" &amp; Me.inventory_ID)\n    End If\n  End If\nEnd Sub\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>updating online inventory from access Private Sub compute_status() Dim Order_date As String Dim Receipt_date As String Dim resale_date As String Dim returned_date As String Dim cancelled_date As String Order_date = Nz(Me.Order_date, &#8220;NULL&#8221;) Receipt_date = Nz(Me.Receipt_date, &#8220;NULL&#8221;) resale_date = Nz(Me.resale_date, &#8220;NULL&#8221;) returned_date = Nz(Me.returned_date, &#8220;NULL&#8221;) cancelled_date = Nz(Me.order_cancelled_date, &#8220;NULL&#8221;) If Order_date = &#8220;NULL&#8221; Then If resale_date&hellip; <a class=\"more-link\" href=\"http:\/\/blogs.terrorware.com\/geoff\/2004\/05\/16\/1084700863812019\/\">Continue reading <span class=\"screen-reader-text\">1084700863812019<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-569","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wnIz-9b","_links":{"self":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/comments?post=569"}],"version-history":[{"count":0,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/posts\/569\/revisions"}],"wp:attachment":[{"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/media?parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/categories?post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blogs.terrorware.com\/geoff\/wp-json\/wp\/v2\/tags?post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}