Adjusting Form Properties

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 00:28, 20 September 2007 (edit)
Lorinda (Talk | contribs)
(begin article--note that I ran into a brick wall will need to consult OOo forums for help)
← Previous diff
Current revision (10:51, 18 May 2008) (edit) (undo)
( | contribs)
m (typo changed)
 
(7 intermediate revisions not shown.)
Line 1: Line 1:
-{{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}}+{{TBBA Header}}
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. 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.
Line 7: Line 7:
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." 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."
-==Changing Form Properties==+ 
 +==Changing the Properties of the Main Form==
#Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}} #Right-click or control-click on the {{Button|Field Trips Data Entry}} icon and choose {{Menu|Edit}}
-#Click on any element of the form (a field or a label)+#There are two ways to open the {{Window|Form Properties}} window:
-#Now click on the {{Button|Form}} icon on the toolbar (circled in red in the image below)+##From the Form:
-#::[[Image:FormButton.png]]+###Right click on any element of the form (a field or a label)
-#::''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}}.''+###Now click on the {{Button|Form}} icon on the toolbar (circled in red in the image below)
-#Under the {{Section|General}} Tab you may change the name if you like. Nothin else here needs to be changed.+###::[[Image:FormButton.png]]
 +###::''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}}.''
 +##From the Form Navigator:
 +###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}}).
 +###Right-click or control-click on the MainForm in the {{Window|Form Navigator}} window and choose {{Menu|Properties}}
 +#Under the {{Section|General}} Tab you may change the name if you like.
 +#:'''Note''' that changing the name may affect the macro in [[Adding a Button To Open Another Form]]
#Click on the {{Section|Data}} Tab #Click on the {{Section|Data}} Tab
-#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+#:'''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
-#{{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}}+#{{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}})
#{{prefName|Allow Modifications}} specifies whether or not the form can be modified. Leave this set for {{prefName|Yes}} #{{prefName|Allow Modifications}} specifies whether or not the form can be modified. Leave this set for {{prefName|Yes}}
-#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.+#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.)
#{{prefName|Add Data only}} should be set to {{prefName|Yes}} #{{prefName|Add Data only}} should be set to {{prefName|Yes}}
-#The {{Section|Events}} tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.+#: '''Note:''' The {{Section|Events}} tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.
#Close the {{Window|Form Properties}} window. #Close the {{Window|Form Properties}} window.
-#Turn Design Mode off by clickin on the blue drafting triangle. Verify that:+<br>
-**the "Next Record" and "Previous Record" buttons are dimmed.+ 
-**you can add Data+==Changing the Subform Properties==
 +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.
 + 
 +#Right-click or control-click on the small, untitled rectangle 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.
 +#:'''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.
 +#Under the {{Section|General}} Tab you may change the name if you like.
 +#Click on the {{Section|Data}} Tab
 +#Leave {{prefName|Allow Additions}} set for {{prefName|Yes}}. (If you wanted a read-only form, you would set it to {{prefName|No}})
 +#Leave {{prefName|Allow Modifications}} set for {{prefName|Yes}}
 +#Similarly, {{prefName|Allow Deletions}} should be left at {{prefName|Yes}}. (For other purposes, however, setting this to {{prefName|No}} helps to protect your data.)
 +#{{prefName|Add Data only}} should be set to {{prefName|Yes}}
 +<br>
 + 
 +==Check Your Work==
 +Turn Design Mode off by clicking on the blue drafting triangle. Verify that:
 +:The {{Button|Next Record}} and {{Button|Previous Record}} buttons are dimmed.
 +:You can add data.
-{{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}}+{{botlangbarEN|[[Fr:Régler les Propriétés du Formulaire|Français]]}}

Current revision

This article is part of the To Base and Back Again tutorial series.

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.

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.

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 Field Trips Data Entry form and choose Copy. Then right-click or control-click on any blank area in the Forms section of the main database window and select Paste from the contextual menu. You will be asked to give the new form a name. I chose "Field Trips Data Viewing."


Changing the Properties of the Main Form

  1. Right-click or control-click on the Field Trips Data Entry icon and choose Edit
  2. There are two ways to open the Form Properties window:
    1. From the Form:
      1. Right click on any element of the form (a field or a label)
      2. Now click on the Form icon on the toolbar (circled in red in the image below)
        Image:FormButton.png
        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 Form.
    2. From the Form Navigator:
      1. Click on the Form Navigator button on the Form Design Toolbar. (If the Form Design Toolbar is not visible, go to the View menu, choose Toolbars and then Form Design).
      2. Right-click or control-click on the MainForm in the Form Navigator window and choose Properties
  3. Under the General Tab you may change the name if you like.
    Note that changing the name may affect the macro in Adding a Button To Open Another Form
  4. Click on the Data Tab
    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
  5. Allow Additions specifies whether or not you can add records. We want to leave this set for Yes. (If you wanted a read-only form, you would set it to No)
  6. Allow Modifications specifies whether or not the form can be modified. Leave this set for Yes
  7. Similarly, Allow Deletions should be left at Yes. (For other purposes, however, setting this to No helps to protect your data.)
  8. Add Data only should be set to Yes
    Note: The Events tab allows you to assign Macros to various form-related events. These settings go beyond the scope of this tutorial.
  9. Close the Form Properties window.


Changing the Subform Properties

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.

  1. Right-click or control-click on the small, untitled rectangle in the upper right hand corner of the data sheet (just to the left of the first field name). Select Form... from the contextual menu.
    OR if you are using the Form Navigator as described above, right-click or control-click on the sub-form name in the Navigator and choose Properties from the contextual menu.
  2. Under the General Tab you may change the name if you like.
  3. Click on the Data Tab
  4. Leave Allow Additions set for Yes. (If you wanted a read-only form, you would set it to No)
  5. Leave Allow Modifications set for Yes
  6. Similarly, Allow Deletions should be left at Yes. (For other purposes, however, setting this to No helps to protect your data.)
  7. Add Data only should be set to Yes


Check Your Work

Turn Design Mode off by clicking on the blue drafting triangle. Verify that:

The Next Record and Previous Record buttons are dimmed.
You can add data.


This article in other languages: Français
Personal tools