Troubleshooting

graphics/troubleshooting.gif

Form Problems

I can't add a new record to a form or subform that's bound to a Jet query.

graphics/new_calls_record.gif The most likely cause of this problem is that the query you're using as the record source for the form or subform isn't updatable. Run the query and verify that the tentative append record appears after the last record with data. If the tentative append record is present in the datasheet and not in the form or subform, then you might have accidentally set the Allow Additions property value to No.

The text boxes on my form are empty, the Next and Previous record navigation buttons are disabled, and the First and Last record buttons don't work.

You accidentally set the Data Entry property of the form to Yes. Setting the Data Entry property permits adding new records, but prevents the user from seeing existing records. Why the First and Last buttons are enabled is a mystery. This problem also occurs with subforms and often results from selecting the form instead of the subform when setting the Data Entry property value.

No controls appear on my form in Form view.

You've set the Allow Additions property to No, and accidentally set the Data Entry property of the form to Yes. In this case, subforms don't appear on the form. There have been many requests by Access users and developers to display an error message when you specify these mutually-exclusive property values. (New Access users have been known to panic after having spent several hours designing a form and then seeing their work disappear in Form view.) The problem also applies to subforms but isn't as dramatic.

Subform Problems

The subform I added to the main form doesn't change its data when I move the main form's record pointer with the navigation buttons.

You didn't create the required link between the main form and the subform in the Data page of the main form's Properties window, or the link is broken as the result of changing a table or query name.

Select the subform container of the main form (not the subform itself) by clicking the edge of the subform in Form Design view, open the Properties window, and click the Data tab. Click the Builder button to open the Subform Field Linker dialog, and add or correct the field names of the linked tables or queries.



Special Edition Using Microsoft Office Access 2003
Special Edition Using Microsoft Office Access 2003
ISBN: 0789729520
EAN: 2147483647
Year: 2005
Pages: 417

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net