Re: Access 2003 Form (new to databases design)

From: tina (nospam_at_address.com)
Date: 12/28/04

  • Next message: Robert Nusz _at_ DPS: "RE: Prevent Blank Records being written. Need Help." 
    Date: Tue, 28 Dec 2004 21:09:18 GMT

    the problem is probably in the RecordSource query, not in the form itself.
    not all multi-table queries are updateable. try opening the query by
    itself - will it allow you to add a record? if not, suggest you post the
    query's SQL statement so we can look at it.

    hth

    "tvh" <tvh@discussions.microsoft.com> wrote in message
    news:7EE54301-F84D-413F-BEEB-29A259D09CCD@microsoft.com...
    > AAHH! Can't add or edit records to a form after adding 3rd table in the
    > Query builder. Edits, deletions, additions all set to "yes" and no locks.
    > The form works fine until I add this third (needed) table. The table also
    > works well, independently. Any suggestions? Thanks!

  • Next message: Robert Nusz _at_ DPS: "RE: Prevent Blank Records being written. Need Help."

    Relevant Pages

    • Re: Forms for data entry
      ... i assume the RecordSource of your form is a query. ... especially multi-table queries, are updateable. ... try opening the query by ...
      (microsoft.public.access.forms)
    • Re: delete record
      ... never tried that approach with a nonupdatable recordsource query. ... Put code in the form's BeforeDelConfirm event procedure -- ... <MS ACCESS MVP> ...
      (microsoft.public.access.queries)
    • Re: Prob with Adding something to Combo with another form
      ... > recordsource query not being updatable. ... > I tried removing the AcForm Add argument and it didn't work. ... >> form's recordsource query is not updatable. ... >> It's possibly your problem would be added by removing the acFormAdd ...
      (microsoft.public.access.formscoding)
    • Re: Print 2 copies
      ... Add this table to the recordsource of the report ... When the recordsource query is run, ... because a relationship between tblPrintCopies and the other tablecannot ...
      (microsoft.public.access.reports)
    • Re: referring to first record =no
      ... What is the recordsource query for the form? ... Post the code that you have for the paymentamt_afterupdate event procedure. ... > paymentamt_afterupdate event on my payment form. ...
      (microsoft.public.access.formscoding)
    Loading