https://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&action=history&feed=atomAdding a Search Control to a Form - Revision history2024-03-29T01:01:55ZRevision history for this page on the wikiMediaWiki 1.10.1https://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=14784&oldid=prevLJ-Bettona: minor typos2009-01-12T18:03:15Z<p>minor typos</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 18:03, 12 January 2009</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 25:</strong></td>
<td colspan="2" align="left"><strong>Line 25:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|Macro from}} section, click on the flippy triangle next to {{prefName|All Sightings}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|Macro from}} section, click on the flippy triangle next to {{prefName|All Sightings}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the flippy triangle next to the folder named {{prefName|Standard}} under the {{prefName|All Sightings}} entry</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the flippy triangle next to the folder named {{prefName|Standard}} under the {{prefName|All Sightings}} entry</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#If no module in the {{prefName|Standard}} folder, click on the {{Button|New}} button.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#If <ins style="color: red; font-weight: bold; text-decoration: none;">there is </ins>no module in the {{prefName|Standard}} folder, click on the {{Button|New}} button.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#:In the {{Window|New Modules}} Window, type <del style="color: red; font-weight: bold; text-decoration: none;">a </del><tt>SearchMacros</tt> in the {{prefName|Name}} field and click {{Button|OK}} button.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#:In the {{Window|New Modules}} Window, type <tt>SearchMacros</tt> in the {{prefName|Name}} field and click {{Button|OK}} button.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{prefName|Search Macros}} module</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{prefName|Search Macros}} module</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the {{prefName|Macro Name}}, type <tt>SearchByState</tt></td><td> </td><td style="background: #eee; font-size: smaller;">#In the {{prefName|Macro Name}}, type <tt>SearchByState</tt></td></tr>
</table>LJ-Bettonahttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=13984&oldid=prevLorinda: /* Add the Control to the Form */ correct query name2008-06-19T16:42:00Z<p><span class="autocomment">Add the Control to the Form -</span> correct query name</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 16:42, 19 June 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 67:</strong></td>
<td colspan="2" align="left"><strong>Line 67:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">##Set the {{prefName|Type of List Contents}} to Sql</td><td> </td><td style="background: #eee; font-size: smaller;">##Set the {{prefName|Type of List Contents}} to Sql</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">##In the {{prefName|List Content}} enter the following statement:</td><td> </td><td style="background: #eee; font-size: smaller;">##In the {{prefName|List Content}} enter the following statement:</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">##:{{preBox|SELECT DISTINCT "State" FROM "<del style="color: red; font-weight: bold; text-decoration: none;">AllSightingsList</del>"}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">##:{{preBox|SELECT DISTINCT "State" FROM "<ins style="color: red; font-weight: bold; text-decoration: none;">All Sightings</ins>"}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Section|Events}} tab, click the {{Button|...}} button to the right of the empty field in the {{prefName|Text modified}} line. The {{Window|Assign Action}} window opens.</td><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Section|Events}} tab, click the {{Button|...}} button to the right of the empty field in the {{prefName|Text modified}} line. The {{Window|Assign Action}} window opens.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Make sure that the {{prefName|Text Modified}} event is highlighted</td><td> </td><td style="background: #eee; font-size: smaller;">#Make sure that the {{prefName|Text Modified}} event is highlighted</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=13983&oldid=prevLorinda: /* Add the Control to the Form */ correct formatting issue2008-06-19T16:40:08Z<p><span class="autocomment">Add the Control to the Form -</span> correct formatting issue</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 16:40, 19 June 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 62:</strong></td>
<td colspan="2" align="left"><strong>Line 62:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Section|General}} tab, in the {{prefName|Label}} field, type <tt>Search by State:</tt>.</td><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Section|General}} tab, in the {{prefName|Label}} field, type <tt>Search by State:</tt>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Double click the combo box you created. The {{Window|Properties: Combo Box}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Double click the combo box you created. The {{Window|Properties: Combo Box}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#In the {{Section|General}} tab, in the {{prefName|Name}} field type <del style="color: red; font-weight: bold; text-decoration: none;"><</del><tt>StateSearchComboBox</tt></td><td>+</td><td style="background: #cfc; font-size: smaller;">#In the {{Section|General}} tab, in the {{prefName|Name}} field type <tt>StateSearchComboBox</tt></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Section|Data}} tab, make the following changes:</td><td> </td><td style="background: #eee; font-size: smaller;">#In the {{Section|Data}} tab, make the following changes:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">##Make sure the {{prefName|Data Field}} field is empty</td><td> </td><td style="background: #eee; font-size: smaller;">##Make sure the {{prefName|Data Field}} field is empty</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=13864&oldid=prevLorinda: /* Working With the Form */ correct formatting2008-06-02T12:36:50Z<p><span class="autocomment">Working With the Form -</span> correct formatting</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 12:36, 2 June 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 13:</strong></td>
<td colspan="2" align="left"><strong>Line 13:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><br></td><td> </td><td style="background: #eee; font-size: smaller;"><br></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Working With the Form==</td><td> </td><td style="background: #eee; font-size: smaller;">==Working With the Form==</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">#</del>Open the '''All Sightings''' Form for editing (In the main database document, click on {{prefName|Forms}} in the left hand column, then right-click or control-click on the '''All Sightings''' Query and choose {{Menu|Edit}} from the contextual menu)</td><td>+</td><td style="background: #cfc; font-size: smaller;">Open the '''All Sightings''' Form for editing (In the main database document, click on {{prefName|Forms}} in the left hand column, then right-click or control-click on the '''All Sightings''' Query and choose {{Menu|Edit}} from the contextual menu)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Correct the '''State''' Column in the Table===</td><td> </td><td style="background: #eee; font-size: smaller;">===Correct the '''State''' Column in the Table===</td></tr>
<tr><td colspan="2" align="left"><strong>Line 80:</strong></td>
<td colspan="2" align="left"><strong>Line 80:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Set the newly created combo box to one of the State options, and verify that the form filters correctly.</td><td> </td><td style="background: #eee; font-size: smaller;">#Set the newly created combo box to one of the State options, and verify that the form filters correctly.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#To clear filtering, delete the entry in the combo box.</td><td> </td><td style="background: #eee; font-size: smaller;">#To clear filtering, delete the entry in the combo box.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==External Links==</td><td> </td><td style="background: #eee; font-size: smaller;">==External Links==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617 oooforum.org thread on this subject] This thread is the source of the macro used above.</td><td> </td><td style="background: #eee; font-size: smaller;">[http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617 oooforum.org thread on this subject] This thread is the source of the macro used above.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Ajouter un Contrôle de Tri à un Formulaire|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Ajouter un Contrôle de Tri à un Formulaire|Français]]}}</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=13406&oldid=prevLorinda: /* Create the Macro */ another macro code correction2008-02-26T16:42:53Z<p><span class="autocomment">Create the Macro -</span> another macro code correction</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 16:42, 26 February 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 31:</strong></td>
<td colspan="2" align="left"><strong>Line 31:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New}} button. The {{Window|AllSightings.Standard NeoOffice Basic}} window opens</td><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New}} button. The {{Window|AllSightings.Standard NeoOffice Basic}} window opens</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#After the existing End Sub entry, paste the following code:</td><td> </td><td style="background: #eee; font-size: smaller;">#After the existing End Sub entry, paste the following code:</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#:{{preBox|<nowiki>Sub <del style="color: red; font-weight: bold; text-decoration: none;">SearchByStateOrProvince</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">#:{{preBox|<nowiki>Sub <ins style="color: red; font-weight: bold; text-decoration: none;">SearchByState</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">dim oFilter as object</td><td> </td><td style="background: #eee; font-size: smaller;">dim oFilter as object</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=13405&oldid=prevLorinda: /* Create the Macro */ correct Macro--primarily StateORProvince to State2008-02-26T16:41:44Z<p><span class="autocomment">Create the Macro -</span> correct Macro--primarily StateORProvince to State</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 16:41, 26 February 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 31:</strong></td>
<td colspan="2" align="left"><strong>Line 31:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New}} button. The {{Window|AllSightings.Standard NeoOffice Basic}} window opens</td><td> </td><td style="background: #eee; font-size: smaller;">#Click the {{Button|New}} button. The {{Window|AllSightings.Standard NeoOffice Basic}} window opens</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#After the existing End Sub entry, paste the following code:</td><td> </td><td style="background: #eee; font-size: smaller;">#After the existing End Sub entry, paste the following code:</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#:{{preBox|<nowiki>Sub <del style="color: red; font-weight: bold; text-decoration: none;">SearchByState</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">#:{{preBox|<nowiki>Sub <ins style="color: red; font-weight: bold; text-decoration: none;">SearchByStateOrProvince</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">dim oFilter as object</td><td> </td><td style="background: #eee; font-size: smaller;">dim oFilter as object</td></tr>
<tr><td colspan="2" align="left"><strong>Line 37:</strong></td>
<td colspan="2" align="left"><strong>Line 37:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">oFormCtl = ThisComponent.Drawpage.Forms.getByName("Standard")</td><td> </td><td style="background: #eee; font-size: smaller;">oFormCtl = ThisComponent.Drawpage.Forms.getByName("Standard")</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">oFilter = oFormCtl.getByName("<del style="color: red; font-weight: bold; text-decoration: none;">StateSearchComboBox</del>")</td><td>+</td><td style="background: #cfc; font-size: smaller;">oFilter = oFormCtl.getByName("<ins style="color: red; font-weight: bold; text-decoration: none;">StateSearchListBox</ins>")</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">if oFilter.CurrentValue <> "" then</td><td> </td><td style="background: #eee; font-size: smaller;">if oFilter.CurrentValue <> "" then</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">oFormCtl.Filter = "<del style="color: red; font-weight: bold; text-decoration: none;">StateOrProvince </del>LIKE " + "'"+oFilter.CurrentValue+"'"</td><td>+</td><td style="background: #cfc; font-size: smaller;">oFormCtl.Filter = "<ins style="color: red; font-weight: bold; text-decoration: none;">State </ins>LIKE " + "'"+oFilter.CurrentValue+"'"</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">oFormCtl.ApplyFilter = True</td><td> </td><td style="background: #eee; font-size: smaller;">oFormCtl.ApplyFilter = True</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">else</td><td> </td><td style="background: #eee; font-size: smaller;">else</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=12400&oldid=prevLorinda: /* Add the Control to the Form */ add link to oooforum thread where I found the macro2007-10-19T01:25:39Z<p><span class="autocomment">Add the Control to the Form -</span> add link to oooforum thread where I found the macro</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:25, 19 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 81:</strong></td>
<td colspan="2" align="left"><strong>Line 81:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#To clear filtering, delete the entry in the combo box.</td><td> </td><td style="background: #eee; font-size: smaller;">#To clear filtering, delete the entry in the combo box.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">==External Links==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">[http://www.oooforum.org/forum/viewtopic.phtml?t=63240&sid=3b40ebbf8ab6c6de3f3960e0d401a617 oooforum.org thread on this subject] This thread is the source of the macro used above.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Ajouter un Contrôle de Tri à un Formulaire|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Ajouter un Contrôle de Tri à un Formulaire|Français]]}}</td></tr>
</table>Lorindahttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=12388&oldid=prevJgd: /* Add the Control to the Form */ typo2007-10-17T14:35:16Z<p><span class="autocomment">Add the Control to the Form -</span> typo</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:35, 17 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 54:</strong></td>
<td colspan="2" align="left"><strong>Line 54:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Add the Control to the Form===</td><td> </td><td style="background: #eee; font-size: smaller;">===Add the Control to the Form===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#If the Form Controls toolbar is not visible, go to the {{Menu|View}} menu and choose {{Menu|Toolbars}} <del style="color: red; font-weight: bold; text-decoration: none;">an </del>then {{Menu|Form Controls}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#If the Form Controls toolbar is not visible, go to the {{Menu|View}} menu and choose {{Menu|Toolbars}} <ins style="color: red; font-weight: bold; text-decoration: none;">and </ins>then {{Menu|Form Controls}}.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Combo Box}} button on the toolbar</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Button|Combo Box}} button on the toolbar</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#On the form, drag to create a combo box in the space between the title and the table.</td><td> </td><td style="background: #eee; font-size: smaller;">#On the form, drag to create a combo box in the space between the title and the table.</td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=12387&oldid=prevJgd: /* Create the Macro */ oops!!!2007-10-17T14:33:25Z<p><span class="autocomment">Create the Macro -</span> oops!!!</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:33, 17 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 22:</strong></td>
<td colspan="2" align="left"><strong>Line 22:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Create the Macro===</td><td> </td><td style="background: #eee; font-size: smaller;">===Create the Macro===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#With the '''All Sightings''' form open, go to the {{Menu|Tools}} menu, choose {{Menu|Macros}} then {{Menu|Organize Macros}} and finally {{Menu|NeoOffice Basic...}}. The {{Window|NeoOffice Basic Macros}} opens.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#With the '''All Sightings''' form open, go to the {{Menu|Tools}} menu, choose {{Menu|Macros}} then {{Menu|Organize Macros}} and finally {{Menu|NeoOffice Basic...}}. The {{Window|NeoOffice Basic Macros}} <ins style="color: red; font-weight: bold; text-decoration: none;">window </ins>opens.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|Macro from}} section, click on the flippy triangle next to {{prefName|All Sightings}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|Macro from}} section, click on the flippy triangle next to {{prefName|All Sightings}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the flippy triangle next to the folder named {{prefName|Standard}} under the {{prefName|All Sightings}} entry</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the flippy triangle next to the folder named {{prefName|Standard}} under the {{prefName|All Sightings}} entry</td></tr>
</table>Jgdhttps://neowiki.neooffice.org/index.php?title=Adding_a_Search_Control_to_a_Form&diff=12386&oldid=prevJgd: /* Create the Macro */ "opens" was missing ;)2007-10-17T14:31:56Z<p><span class="autocomment">Create the Macro -</span> "opens" was missing ;)</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:31, 17 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 22:</strong></td>
<td colspan="2" align="left"><strong>Line 22:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Create the Macro===</td><td> </td><td style="background: #eee; font-size: smaller;">===Create the Macro===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#With the '''All Sightings''' form open, go to the {{Menu|Tools}} menu, choose {{Menu|Macros}} then {{Menu|Organize Macros}} and finally {{Menu|NeoOffice Basic...}}. The {{Window|NeoOffice Basic Macros}}.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#With the '''All Sightings''' form open, go to the {{Menu|Tools}} menu, choose {{Menu|Macros}} then {{Menu|Organize Macros}} and finally {{Menu|NeoOffice Basic...}}. The {{Window|NeoOffice Basic Macros}} <ins style="color: red; font-weight: bold; text-decoration: none;">opens</ins>.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|Macro from}} section, click on the flippy triangle next to {{prefName|All Sightings}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|Macro from}} section, click on the flippy triangle next to {{prefName|All Sightings}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the flippy triangle next to the folder named {{prefName|Standard}} under the {{prefName|All Sightings}} entry</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the flippy triangle next to the folder named {{prefName|Standard}} under the {{prefName|All Sightings}} entry</td></tr>
<tr><td colspan="2" align="left"><strong>Line 51:</strong></td>
<td colspan="2" align="left"><strong>Line 51:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|AllSightings.Standard NeoOffice Basic}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|AllSightings.Standard NeoOffice Basic}} window.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">'''Note''' Embedding the macro directly in the form has the advantage that if you move or copy the database file to another computer, the macro will still function. The disadvantage, however, is that you will be ask whether or not you want to enable macros in the form any time you open the form. <del style="color: red; font-weight: bold; text-decoration: none;"> </del></td><td>+</td><td style="background: #cfc; font-size: smaller;">'''Note''' Embedding the macro directly in the form has the advantage that if you move or copy the database file to another computer, the macro will still function. The disadvantage, however, is that you will be ask whether or not you want to enable macros in the form any time you open the form.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Add the Control to the Form===</td><td> </td><td style="background: #eee; font-size: smaller;">===Add the Control to the Form===</td></tr>
</table>Jgd