• Re: Content of document dependant on the selection of a single field

    From Sam M@21:1/5 to Jay Freedman on Sat Oct 2 13:15:52 2021
    On Sunday, October 14, 2001 at 10:09:50 PM UTC+3, Jay Freedman wrote:
    Hi, Dave,
    There are probably a half dozen different ways to go about this; here are
    two suggestions.
    (1) Create a template that contains all of the test cases. Add an AutoNew macro to the template, and have the macro display a userform. On the
    userform you place a list box containing all the model designations, plus an OK button. When the user creates a new document based on the template, they first pick a model from the list and click OK. The code behind the button then either (a) formats as Hidden all of the test cases that don't apply to that model, or (b) deletes the cases that don't apply.
    (2) As the inverse of the first method, the template's text doesn't contain any test cases. It does contain the AutoNew macro and the userform. In this version, the code behind the OK button inserts the test cases that do apply to this model, either from Access or, more simply, from AutoText entries stored in the template itself.
    Here are some references to get you started with AutoNew and userforms: http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm http://www.mvps.org/word/FAQs/MacrosVBA/PseudoAutoMacros.htm http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm http://www.addbalance.com/word/download/index.htm#Tutorials -- download the Userform template
    If you need any help to get this up and running, c'mon back!
    --
    Regards,
    Jay Freedman
    Microsoft Word MVP Word MVP FAQ site: http://www.mvps.org/word
    "Dave" <Dave_B...@hhoottmmaaiill.com> wrote in message news:uaoOiRNVBHA.2256@tkmsftngp03...
    Hi! I've been searching the FAQ's all weekend, including MVP and the KB, but I haven't found a solution to my problem yet. Perhaps I'm just being
    a
    little dense, but I'm so close in to this one, I can't see the answer:

    I am producing a Customer Acceptance Plan for a product manufactured by
    the
    company for which I work. The product comes in several flavours, all of which share common features and each of which has individual features
    common
    to at least one, but not all of the others. For example,
    product A is black, has a widget and a gizmo, has five interfaces, and
    is battery operated.
    product B is black, has two gizmos, has seven interfaces, and is mains operated
    product C is grey, has two widgets, four gizmos, has seven interfaces,
    and is mains operated with a battery backup.

    I am creating a form type document which our installers can complete
    on-site
    and, based on a drop down box on the first page, I'd like to pull in the relevant test cases for that particular model to that document.

    Each test case contains a check box for 'passed', which is simply an indication that the test has been executed successfully (failure is not an option in this case; a single failure indicates non-acceptance by the customer).

    The unprotected document should contain ALL the test cases so that these
    can
    be updated, but some way of identifying the application of the test case would obviously be very useful.

    I have considered using an access database to contain the text of the test cases and building the document on the fly from there, but I'm wondering
    if
    there is a better way. Interleaf, the Unix based word processor, allows
    for such 'versioning' within a document, but all of our installers use Windows NT laptops with Word 2000. To open an X-window connection to load interleaf, they would need a broadband connection to corporate to support the VPN so we need to provide a standalone solution, preferably contained
    in
    a single file.

    Does anyone have any thoughts on this?

    Dave Burgess
    reply to the newsgroup, or you can
    email me at dave_burgess AT hotmail DOT com



    The built in windows VPN settings/options uses L2TP/IPSec, PPTP and IKEv2 protocols. The best VPN provider https://en.vpnwelt.com/best-vpn/ you pick needs to support these protocols.

    Celo VPN

    ExpressVPN

    ProtonVPN

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sam M@21:1/5 to Jay Freedman on Sat Oct 2 13:16:25 2021
    On Sunday, October 14, 2001 at 10:09:50 PM UTC+3, Jay Freedman wrote:
    Hi, Dave,
    There are probably a half dozen different ways to go about this; here are
    two suggestions.
    (1) Create a template that contains all of the test cases. Add an AutoNew macro to the template, and have the macro display a userform. On the
    userform you place a list box containing all the model designations, plus an OK button. When the user creates a new document based on the template, they first pick a model from the list and click OK. The code behind the button then either (a) formats as Hidden all of the test cases that don't apply to that model, or (b) deletes the cases that don't apply.
    (2) As the inverse of the first method, the template's text doesn't contain any test cases. It does contain the AutoNew macro and the userform. In this version, the code behind the OK button inserts the test cases that do apply to this model, either from Access or, more simply, from AutoText entries stored in the template itself.
    Here are some references to get you started with AutoNew and userforms: http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm http://www.mvps.org/word/FAQs/MacrosVBA/PseudoAutoMacros.htm http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm http://www.addbalance.com/word/download/index.htm#Tutorials -- download the Userform template
    If you need any help to get this up and running, c'mon back!
    --
    Regards,
    Jay Freedman
    Microsoft Word MVP Word MVP FAQ site: http://www.mvps.org/word
    "Dave" <Dave_B...@hhoottmmaaiill.com> wrote in message news:uaoOiRNVBHA.2256@tkmsftngp03...
    Hi! I've been searching the FAQ's all weekend, including MVP and the KB, but I haven't found a solution to my problem yet. Perhaps I'm just being
    a
    little dense, but I'm so close in to this one, I can't see the answer:

    I am producing a Customer Acceptance Plan for a product manufactured by
    the
    company for which I work. The product comes in several flavours, all of which share common features and each of which has individual features
    common
    to at least one, but not all of the others. For example,
    product A is black, has a widget and a gizmo, has five interfaces, and
    is battery operated.
    product B is black, has two gizmos, has seven interfaces, and is mains operated
    product C is grey, has two widgets, four gizmos, has seven interfaces,
    and is mains operated with a battery backup.

    I am creating a form type document which our installers can complete
    on-site
    and, based on a drop down box on the first page, I'd like to pull in the relevant test cases for that particular model to that document.

    Each test case contains a check box for 'passed', which is simply an indication that the test has been executed successfully (failure is not an option in this case; a single failure indicates non-acceptance by the customer).

    The unprotected document should contain ALL the test cases so that these
    can
    be updated, but some way of identifying the application of the test case would obviously be very useful.

    I have considered using an access database to contain the text of the test cases and building the document on the fly from there, but I'm wondering
    if
    there is a better way. Interleaf, the Unix based word processor, allows
    for such 'versioning' within a document, but all of our installers use Windows NT laptops with Word 2000. To open an X-window connection to load interleaf, they would need a broadband connection to corporate to support the VPN so we need to provide a standalone solution, preferably contained
    in
    a single file.

    Does anyone have any thoughts on this?

    Dave Burgess
    reply to the newsgroup, or you can
    email me at dave_burgess AT hotmail DOT com



    https://en.vpnwelt.com/best-vpn/

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rhythm Of Heavy Rain@21:1/5 to Sam M on Wed Oct 20 23:51:38 2021
    On Sunday, October 3, 2021 at 3:16:26 AM UTC+7, Sam M wrote:
    On Sunday, October 14, 2001 at 10:09:50 PM UTC+3, Jay Freedman wrote:
    Hi, Dave,
    There are probably a half dozen different ways to go about this; here are two suggestions.
    (1) Create a template that contains all of the test cases. Add an AutoNew macro to the template, and have the macro display a userform. On the userform you place a list box containing all the model designations, plus an
    OK button. When the user creates a new document based on the template, they first pick a model from the list and click OK. The code behind the button then either (a) formats as Hidden all of the test cases that don't apply to that model, or (b) deletes the cases that don't apply.
    (2) As the inverse of the first method, the template's text doesn't contain any test cases. It does contain the AutoNew macro and the userform. In this version, the code behind the OK button inserts the test cases that do apply to this model, either from Access or, more simply, from AutoText entries stored in the template itself.
    Here are some references to get you started with AutoNew and userforms: http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm http://www.mvps.org/word/FAQs/MacrosVBA/PseudoAutoMacros.htm http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm http://www.addbalance.com/word/download/index.htm#Tutorials -- download the Userform template
    If you need any help to get this up and running, c'mon back!
    --
    Regards,
    Jay Freedman
    Microsoft Word MVP Word MVP FAQ site: http://www.mvps.org/word
    "Dave" <Dave_B...@hhoottmmaaiill.com> wrote in message news:uaoOiRNVBHA.2256@tkmsftngp03...
    Hi! I've been searching the FAQ's all weekend, including MVP and the KB, but I haven't found a solution to my problem yet. Perhaps I'm just being
    a
    little dense, but I'm so close in to this one, I can't see the answer:

    I am producing a Customer Acceptance Plan for a product manufactured by
    the
    company for which I work. The product comes in several flavours, all of which share common features and each of which has individual features
    common
    to at least one, but not all of the others. For example,
    product A is black, has a widget and a gizmo, has five interfaces, and
    is battery operated.
    product B is black, has two gizmos, has seven interfaces, and is mains operated
    product C is grey, has two widgets, four gizmos, has seven interfaces, and is mains operated with a battery backup.

    I am creating a form type document which our installers can complete
    on-site
    and, based on a drop down box on the first page, I'd like to pull in the relevant test cases for that particular model to that document.

    Each test case contains a check box for 'passed', which is simply an indication that the test has been executed successfully (failure is not an
    option in this case; a single failure indicates non-acceptance by the customer).

    The unprotected document should contain ALL the test cases so that these
    can
    be updated, but some way of identifying the application of the test case would obviously be very useful.

    I have considered using an access database to contain the text of the test
    cases and building the document on the fly from there, but I'm wondering
    if
    there is a better way. Interleaf, the Unix based word processor, allows for such 'versioning' within a document, but all of our installers use Windows NT laptops with Word 2000. To open an X-window connection to load interleaf, they would need a broadband connection to corporate to support the VPN so we need to provide a standalone solution, preferably contained
    in
    a single file.

    Does anyone have any thoughts on this?
    https://nytimes-spellingbee.com
    Dave Burgess
    reply to the newsgroup, or you can
    email me at dave_burgess AT hotmail DOT com


    https://en.vpnwelt.com/best-vpn/

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Stvan Seo@21:1/5 to All on Thu May 26 07:18:33 2022
    I've been designing products that solve problems through a screen for almost a decade. I design user interface and user experience, interaction, functionality and information architecture. I also train other professionals and students in design. https://
    www.citycraigslist.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)