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)

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)

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)

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)