https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&action=history&feed=atom
Adjusting Form Properties - Revision history
2024-03-28T11:06:34Z
Revision history for this page on the wiki
MediaWiki 1.10.1
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=13845&oldid=prev
LJ-Bettona: typo changed
2008-05-18T10:51:09Z
<p>typo changed</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 10:51, 18 May 2008</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 34:</strong></td>
<td colspan="2" align="left"><strong>Line 34:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</td><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</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;">#Right-click or control-click on the small, untitled <del style="color: red; font-weight: bold; text-decoration: none;">retangle </del>in the upper right hand corner of the data sheet (just to the left of the first field name). Select {{Menu|Form...}} from the contextual menu. </td><td>+</td><td style="background: #cfc; font-size: smaller;">#Right-click or control-click on the small, untitled <ins style="color: red; font-weight: bold; text-decoration: none;">rectangle </ins>in the upper right hand corner of the data sheet (just to the left of the first field name). Select {{Menu|Form...}} from the contextual menu. </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:'''OR''' if you are using the {{Window|Form Navigator}} as described above, right-click or control-click on the sub-form name in the Navigator and choose {{Menu|Properties}} from the contextual menu.</td><td> </td><td style="background: #eee; font-size: smaller;">#:'''OR''' if you are using the {{Window|Form Navigator}} as described above, right-click or control-click on the sub-form name in the Navigator and choose {{Menu|Properties}} from the contextual menu.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like.</td><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like.</td></tr>
</table>
LJ-Bettona
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12866&oldid=prev
Valterb: initial banner added
2007-12-02T18:16:06Z
<p>initial banner added</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:16, 2 December 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">{{TBBA Header}}</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Sometimes after you have designed a form, you discover that some of the form properties that you set in the wizard need to be adjusted. Other times, you may create a form in design view, without using the wizard at all, and need to set the form properties.</td><td> </td><td style="background: #eee; font-size: smaller;">Sometimes after you have designed a form, you discover that some of the form properties that you set in the wizard need to be adjusted. Other times, you may create a form in design view, without using the wizard at all, and need to set the form properties.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>
Valterb
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12483&oldid=prev
Lorinda: /* Check Your Work */ fix typos; use button templates
2007-10-28T02:33:54Z
<p><span class="autocomment">Check Your Work -</span> fix typos; use button templates</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 02:33, 28 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 44:</strong></td>
<td colspan="2" align="left"><strong>Line 44:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Check Your Work==</td><td> </td><td style="background: #eee; font-size: smaller;">==Check Your Work==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Turn Design Mode off by clicking on the blue drafting triangle. Verify that:</td><td> </td><td style="background: #eee; font-size: smaller;">Turn Design Mode off by clicking on the blue drafting triangle. Verify that:</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:<del style="color: red; font-weight: bold; text-decoration: none;">the "</del>Next Record<del style="color: red; font-weight: bold; text-decoration: none;">" </del>and <del style="color: red; font-weight: bold; text-decoration: none;">"</del>Previous Record<del style="color: red; font-weight: bold; text-decoration: none;">" </del>buttons are dimmed.</td><td>+</td><td style="background: #cfc; font-size: smaller;">:<ins style="color: red; font-weight: bold; text-decoration: none;">The {{Button|</ins>Next Record<ins style="color: red; font-weight: bold; text-decoration: none;">}} </ins>and <ins style="color: red; font-weight: bold; text-decoration: none;">{{Button|</ins>Previous Record<ins style="color: red; font-weight: bold; text-decoration: none;">}} </ins>buttons are dimmed.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">:<del style="color: red; font-weight: bold; text-decoration: none;">you </del>can add <del style="color: red; font-weight: bold; text-decoration: none;">Data</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">:<ins style="color: red; font-weight: bold; text-decoration: none;">You </ins>can add <ins style="color: red; font-weight: bold; text-decoration: none;">data.</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;">{{botlangbarEN|[[Fr:Régler les Propriétés du Formulaire|Français]]}}</td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Régler les Propriétés du Formulaire|Français]]}}</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12482&oldid=prev
Lorinda: /* Changing the Subform Properties */ add instructions for using the Form Navigator
2007-10-28T02:32:55Z
<p><span class="autocomment">Changing the Subform Properties -</span> add instructions for using the Form Navigator</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 02:32, 28 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 32:</strong></td>
<td colspan="2" align="left"><strong>Line 32:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</td><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</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;">#Right-click or control-click on the small, untitled retangle in the upper right hand corner of the data sheet (just to the left of the first field name). Select {{Menu|Form...}} from the contextual menu.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Right-click or control-click on the small, untitled retangle in the upper right hand corner of the data sheet (just to the left of the first field name). Select {{Menu|Form...<ins style="color: red; font-weight: bold; text-decoration: none;">}} from the contextual menu. </ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:'''OR''' if you are using the {{Window|Form Navigator}} as described above, right-click or control-click on the sub-form name in the Navigator and choose {{Menu|Properties</ins>}} from the contextual menu.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like.</td><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Section|Data}} Tab</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Section|Data}} Tab</td></tr>
<tr><td colspan="2" align="left"><strong>Line 40:</strong></td>
<td colspan="2" align="left"><strong>Line 41:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Add Data only}} should be set to {{prefName|Yes}}</td><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Add Data only}} should be set to {{prefName|Yes}}</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 colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Check Your Work==</td><td> </td><td style="background: #eee; font-size: smaller;">==Check Your Work==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Turn Design Mode off by clicking on the blue drafting triangle. Verify that:</td><td> </td><td style="background: #eee; font-size: smaller;">Turn Design Mode off by clicking on the blue drafting triangle. Verify that:</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12481&oldid=prev
Lorinda: /* Changing the Properties of the Main Form */ add instructions for using the Form Navigator
2007-10-28T02:30:33Z
<p><span class="autocomment">Changing the Properties of the Main Form -</span> add instructions for using the Form Navigator</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 02:30, 28 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 8:</strong></td>
<td colspan="2" align="left"><strong>Line 8:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Changing the Properties of the Main Form==</td><td> </td><td style="background: #eee; font-size: smaller;">==Changing the Properties of the Main Form==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Right click on any element of the form (a field or a label)</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#There are two ways to open the {{Window|Form Properties}} window:</ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Now click on the {{Button|Form}} icon on the toolbar (circled in red in the image below)</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##From the Form:</ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#::[[Image:FormButton.png]]</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##</ins>#Right click on any element of the form (a field or a label)</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#::''Note that this button will be greyed out unless an element of the form has been selected. You can also access Form Properties by right-clicking or control-clicking on a form element and choosing {{Menu|Form}}.''</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##</ins>#Now click on the {{Button|Form}} icon on the toolbar (circled in red in the image below)</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##</ins>#::[[Image:FormButton.png]]</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##</ins>#::''Note that this button will be greyed out unless an element of the form has been selected. You can also access Form Properties by right-clicking or control-clicking on a form element and choosing {{Menu|Form}}.''</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">##From the Form Navigator:</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">###Click on the {{Button|Form Navigator}} button on the Form Design Toolbar. (If the Form Design Toolbar is not visible, go to the {{Menu|View}} menu, choose {{Menu|Toolbars}} and then {{Menu|Form Design}}).</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">###Right-click or control-click on the MainForm in the {{Window|Form Navigator}} window and choose {{Menu|Properties}}</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like.</td><td> </td><td style="background: #eee; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#:'''Note''' that changing the name may affect the macro in [[Adding a Button To Open Another Form]]</td><td> </td><td style="background: #eee; font-size: smaller;">#:'''Note''' that changing the name may affect the macro in [[Adding a Button To Open Another Form]]</td></tr>
<tr><td colspan="2" align="left"><strong>Line 23:</strong></td>
<td colspan="2" align="left"><strong>Line 28:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|Form Properties}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|Form Properties}} window.</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 colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Changing the Subform Properties==</td><td> </td><td style="background: #eee; font-size: smaller;">==Changing the Subform Properties==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</td><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12280&oldid=prev
Jgd: botlangbar -> Fr page
2007-10-10T12:27:34Z
<p>botlangbar -> Fr page</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:27, 10 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 38:</strong></td>
<td colspan="2" align="left"><strong>Line 38:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:the "Next Record" and "Previous Record" buttons are dimmed.</td><td> </td><td style="background: #eee; font-size: smaller;">:the "Next Record" and "Previous Record" buttons are dimmed.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:you can add Data</td><td> </td><td style="background: #eee; font-size: smaller;">:you can add Data</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;">{{botlangbarEN|[[Fr:Régler les Propriétés du Formulaire|Français]]}}</td></tr>
</table>
Jgd
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12274&oldid=prev
Lorinda: correct headings
2007-10-10T03:36:03Z
<p>correct headings</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 03:36, 10 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">{{Redbox|Note that this process is not currently working correctly. I am investigating to find the source of the problem, so that this page can be corrected}}</td><td colspan="2"> </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;">Sometimes after you have designed a form, you discover that some of the form properties that you set in the wizard need to be adjusted. Other times, you may create a form in design view, without using the wizard at all, and need to set the form properties.</td><td> </td><td style="background: #eee; font-size: smaller;">Sometimes after you have designed a form, you discover that some of the form properties that you set in the wizard need to be adjusted. Other times, you may create a form in design view, without using the wizard at all, and need to set the form properties.</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" align="left"><strong>Line 7:</strong></td>
<td colspan="2" align="left"><strong>Line 5:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Because I would like to also view existing data in the same format, we will first copy the form. To do so, right-click or control-click on the {{Button|Field Trips Data Entry}} form and choose {{Menu|Copy}}. Then right-click or control-click on any blank area in the {{Section|Forms}} section of the main database window and select {{Menu|Paste}} from the contextual menu. You will be asked to give the new form a name. I chose "Field Trips Data Viewing."</td><td> </td><td style="background: #eee; font-size: smaller;">Because I would like to also view existing data in the same format, we will first copy the form. To do so, right-click or control-click on the {{Button|Field Trips Data Entry}} form and choose {{Menu|Copy}}. Then right-click or control-click on any blank area in the {{Section|Forms}} section of the main database window and select {{Menu|Paste}} from the contextual menu. You will be asked to give the new form a name. I chose "Field Trips Data Viewing."</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;"><del style="color: red; font-weight: bold; text-decoration: none;">==Changing Form Properties==</del></td><td>+</td><td style="background: #cfc; font-size: smaller;"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>==Changing the Properties of the Main Form<del style="color: red; font-weight: bold; text-decoration: none;">=</del>==</td><td>+</td><td style="background: #cfc; font-size: smaller;">==Changing the Properties of the Main Form==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Right click on any element of the form (a field or a label)</td><td> </td><td style="background: #eee; font-size: smaller;">#Right click on any element of the form (a field or a label)</td></tr>
<tr><td colspan="2" align="left"><strong>Line 24:</strong></td>
<td colspan="2" align="left"><strong>Line 22:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#: '''Note:''' The {{Section|Events}} tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.</td><td> </td><td style="background: #eee; font-size: smaller;">#: '''Note:''' The {{Section|Events}} tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|Form Properties}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|Form Properties}} window.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"><br></ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>==Changing the Subform Properties<del style="color: red; font-weight: bold; text-decoration: none;">=</del>==</td><td>+</td><td style="background: #cfc; font-size: smaller;">==Changing the Subform Properties==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</td><td> </td><td style="background: #eee; font-size: smaller;">Now we need to change the properties for our subform. This same process could be used for a main form set up as a data sheet.</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" align="left"><strong>Line 35:</strong></td>
<td colspan="2" align="left"><strong>Line 33:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.)</td><td> </td><td style="background: #eee; font-size: smaller;">#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Add Data only}} should be set to {{prefName|Yes}}</td><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Add Data only}} should be set to {{prefName|Yes}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;"><br></ins></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">=</del>==Check Your Work<del style="color: red; font-weight: bold; text-decoration: none;">=</del>==</td><td>+</td><td style="background: #cfc; font-size: smaller;">==Check Your Work==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Turn Design Mode off by clicking on the blue drafting triangle. Verify that:</td><td> </td><td style="background: #eee; font-size: smaller;">Turn Design Mode off by clicking on the blue drafting triangle. Verify that:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:the "Next Record" and "Previous Record" buttons are dimmed.</td><td> </td><td style="background: #eee; font-size: smaller;">:the "Next Record" and "Previous Record" buttons are dimmed.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">:you can add Data</td><td> </td><td style="background: #eee; font-size: smaller;">:you can add Data</td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12273&oldid=prev
Lorinda: /* Changing Form Properties */ correct process; some formatting changes
2007-10-10T03:28:34Z
<p><span class="autocomment">Changing Form Properties -</span> correct process; some formatting changes</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 03:28, 10 October 2007</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 8:</strong></td>
<td colspan="2" align="left"><strong>Line 8:</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;">==Changing Form Properties==</td><td> </td><td style="background: #eee; font-size: smaller;">==Changing Form Properties==</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">===Changing the Properties of the Main Form===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}</td><td> </td><td style="background: #eee; font-size: smaller;">#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#<del style="color: red; font-weight: bold; text-decoration: none;">Click </del>on any element of the form (a field or a label)</td><td>+</td><td style="background: #cfc; font-size: smaller;">#<ins style="color: red; font-weight: bold; text-decoration: none;">Right click </ins>on any element of the form (a field or a label)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Now click on the {{Button|Form}} icon on the toolbar (circled in red in the image below)</td><td> </td><td style="background: #eee; font-size: smaller;">#Now click on the {{Button|Form}} icon on the toolbar (circled in red in the image below)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#::[[Image:FormButton.png]]</td><td> </td><td style="background: #eee; font-size: smaller;">#::[[Image:FormButton.png]]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#::''Note that this button will be greyed out unless an element of the form has been selected. You can also access Form Properties by right-clicking or control-clicking on a form element and choosing {{Menu|Form}}.''</td><td> </td><td style="background: #eee; font-size: smaller;">#::''Note that this button will be greyed out unless an element of the form has been selected. You can also access Form Properties by right-clicking or control-clicking on a form element and choosing {{Menu|Form}}.''</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like. <del style="color: red; font-weight: bold; text-decoration: none;"> Nothin else here needs to be changed.</del></td><td>+</td><td style="background: #cfc; font-size: smaller;">#Under the {{Section|General}} Tab you may change the name if you like.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#:'''Note''' that changing the name may affect the macro in [[Adding a Button To Open Another Form]]</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Section|Data}} Tab</td><td> </td><td style="background: #eee; font-size: smaller;">#Click on the {{Section|Data}} Tab</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Note that you can set many properties of the form here, including what type of content (Table, Query, or SQL Command), which Table or Query it relates to, etc. Search the online help for more details on many of these settings</td><td>+</td><td style="background: #cfc; font-size: smaller;">#<ins style="color: red; font-weight: bold; text-decoration: none;">:'''</ins>Note<ins style="color: red; font-weight: bold; text-decoration: none;">''' </ins>that you can set many properties of the form here, including what type of content (Table, Query, or SQL Command), which Table or Query it relates to, etc. Search the online help for more details on many of these settings</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#{{prefName|Allow Additions}} specifies whether or not you can add records. We want to leave this set for {{prefName|Yes}}. (If you wanted a read-only form, you would set it to {{prefName|No}}</td><td>+</td><td style="background: #cfc; font-size: smaller;">#{{prefName|Allow Additions}} specifies whether or not you can add records. We want to leave this set for {{prefName|Yes}}. (If you wanted a read-only form, you would set it to {{prefName|No}}<ins style="color: red; font-weight: bold; text-decoration: none;">)</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Allow Modifications}} specifies whether or not the form can be modified. Leave this set for {{prefName|Yes}}</td><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Allow Modifications}} specifies whether or not the form can be modified. Leave this set for {{prefName|Yes}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.<ins style="color: red; font-weight: bold; text-decoration: none;">)</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Add Data only}} should be set to {{prefName|Yes}}</td><td> </td><td style="background: #eee; font-size: smaller;">#{{prefName|Add Data only}} should be set to {{prefName|Yes}}</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#The {{Section|Events}} tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.</td><td>+</td><td style="background: #cfc; font-size: smaller;">#<ins style="color: red; font-weight: bold; text-decoration: none;">: '''Note:''' </ins>The {{Section|Events}} tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|Form Properties}} window.</td><td> </td><td style="background: #eee; font-size: smaller;">#Close the {{Window|Form Properties}} window.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">#Turn Design Mode off by clickin on the blue drafting triangle. Verify that:</td><td colspan="2"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">**the "Next Record" and "Previous Record" buttons are dimmed.</td><td colspan="2"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">**you can add Data</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: #ffa; font-size: smaller;"><del style="color: red; font-weight: bold; text-decoration: none;">{{Redbox|Note that this process is not currently working correctly</del>. <del style="color: red; font-weight: bold; text-decoration: none;">I am investigating </del>to <del style="color: red; font-weight: bold; text-decoration: none;">find </del>the <del style="color: red; font-weight: bold; text-decoration: none;">source </del>of the <del style="color: red; font-weight: bold; text-decoration: none;">problem</del>, <del style="color: red; font-weight: bold; text-decoration: none;">so that </del>this <del style="color: red; font-weight: bold; text-decoration: none;">page can </del>be <del style="color: red; font-weight: bold; text-decoration: none;">corrected</del>}}</td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">===Changing the Subform Properties===</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">Now we need to change the properties for our subform</ins>. <ins style="color: red; font-weight: bold; text-decoration: none;">This same process could be used for a main form set up as a data sheet.</ins></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;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Right-click or control-click on the small, untitled retangle in the upper right hand corner of the data sheet (just </ins>to the <ins style="color: red; font-weight: bold; text-decoration: none;">left </ins>of the <ins style="color: red; font-weight: bold; text-decoration: none;">first field name). Select {{Menu|Form...}} from the contextual menu.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Under the {{Section|General}} Tab you may change the name if you like.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Click on the {{Section|Data}} Tab</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Leave {{prefName|Allow Additions}} set for {{prefName|Yes}}. (If you wanted a read-only form</ins>, <ins style="color: red; font-weight: bold; text-decoration: none;">you would set it to {{prefName|No}})</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Leave {{prefName|Allow Modifications}} set for {{prefName|Yes}}</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting </ins>this <ins style="color: red; font-weight: bold; text-decoration: none;">to {{prefName|No}} helps to protect your data.)</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">#{{prefName|Add Data only}} should </ins>be <ins style="color: red; font-weight: bold; text-decoration: none;">set to {{prefName|Yes</ins>}}</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;"><ins style="color: red; font-weight: bold; text-decoration: none;">===Check Your Work===</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">Turn Design Mode off by clicking on the blue drafting triangle. Verify that:</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">:the "Next Record" and "Previous Record" buttons are dimmed.</ins></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"><ins style="color: red; font-weight: bold; text-decoration: none;">:you can add Data</ins></td></tr>
</table>
Lorinda
https://neowiki.neooffice.org/index.php?title=Adjusting_Form_Properties&diff=12050&oldid=prev
Lorinda: begin article--note that I ran into a brick wall will need to consult OOo forums for help
2007-09-20T00:28:34Z
<p>begin article--note that I ran into a brick wall will need to consult OOo forums for help</p>
<p><b>New page</b></p><div>{{Redbox|Note that this process is not currently working correctly. I am investigating to find the source of the problem, so that this page can be corrected}}<br />
<br />
Sometimes after you have designed a form, you discover that some of the form properties that you set in the wizard need to be adjusted. Other times, you may create a form in design view, without using the wizard at all, and need to set the form properties.<br />
<br />
In the case of our birding database, I realized that when entering data on a field trip, it would be most helpful if the "Field Trips Data Entry" form pulled up with an empty form, rather than with data from a previous trip. To do this means changing the field properties. <br />
<br />
Because I would like to also view existing data in the same format, we will first copy the form. To do so, right-click or control-click on the {{Button|Field Trips Data Entry}} form and choose {{Menu|Copy}}. Then right-click or control-click on any blank area in the {{Section|Forms}} section of the main database window and select {{Menu|Paste}} from the contextual menu. You will be asked to give the new form a name. I chose "Field Trips Data Viewing."<br />
<br />
==Changing Form Properties==<br />
#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}<br />
#Click on any element of the form (a field or a label)<br />
#Now click on the {{Button|Form}} icon on the toolbar (circled in red in the image below)<br />
#::[[Image:FormButton.png]]<br />
#::''Note that this button will be greyed out unless an element of the form has been selected. You can also access Form Properties by right-clicking or control-clicking on a form element and choosing {{Menu|Form}}.''<br />
#Under the {{Section|General}} Tab you may change the name if you like. Nothin else here needs to be changed.<br />
#Click on the {{Section|Data}} Tab<br />
#Note that you can set many properties of the form here, including what type of content (Table, Query, or SQL Command), which Table or Query it relates to, etc. Search the online help for more details on many of these settings<br />
#{{prefName|Allow Additions}} specifies whether or not you can add records. We want to leave this set for {{prefName|Yes}}. (If you wanted a read-only form, you would set it to {{prefName|No}}<br />
#{{prefName|Allow Modifications}} specifies whether or not the form can be modified. Leave this set for {{prefName|Yes}}<br />
#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.<br />
#{{prefName|Add Data only}} should be set to {{prefName|Yes}}<br />
#The {{Section|Events}} tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.<br />
#Close the {{Window|Form Properties}} window.<br />
#Turn Design Mode off by clickin on the blue drafting triangle. Verify that:<br />
**the "Next Record" and "Previous Record" buttons are dimmed.<br />
**you can add Data<br />
<br />
{{Redbox|Note that this process is not currently working correctly. I am investigating to find the source of the problem, so that this page can be corrected}}</div>
Lorinda