Article View: comp.databases.ms-access
Article #365Best way to prevent report from printing until conditions met?
From: howg
Date: Mon, 01 Feb 1999 00:00
Date: Mon, 01 Feb 1999 00:00
29 lines
1710 bytes
1710 bytes
Would like to prevent a report from printing until all conditions are met with respect to specific textboxes. Once the following fields have value allow then allow the report to print. If value IS missing then pop-up form appears with message telling user to add the information before the report can print. The pop-up form should have a close/cancel button. [control] "message to pop-up" --------------------- [DateofBirth] "Enter the applicants Date of birth to continue." [WorkTele] "Enter the applicants Work Telephone number to continue." I would like to do with vba code. Can anyone get me started, refer me to book sample, refer me to db sample, or whatever? TIA, howard new york city howg@_no_spam_earthlink.net To reply: remove "_no_spam_" from address
Technical Details
Message-ID:
<794gik$k68$1@ash.prod.itd.earthlink.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 111a5a,2593932dec0d90d,start X-Google-Attributes: gid111a5a,public X-Google-Thread: ff0ac,2593932dec0d90d,start X-Google-Attributes: gidff0ac,public X-Google-Thread: f8db2,2593932dec0d90d,start X-Google-Attributes: gidf8db2,public X-Google-Thread: f87f8,2593932dec0d90d,start X-Google-Attributes: gidf87f8,public From: "howg" <howg@earthlink.net> Subject: Best way to prevent report from printing until conditions met? Date: 1999/02/01 Message-ID: <794gik$k68$1@ash.prod.itd.earthlink.net> X-Deja-AN: 439387371 X-Posted-Path-Was: not-for-mail X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 X-ELN-Date: 1 Feb 1999 15:17:40 GMT X-ELN-Insert-Date: Mon Feb 1 07:25:07 1999 Organization: EarthLink Network, Inc. Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,it.comp.database.access,microsoft.public.excel.programming