Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

No multiple record creation

Discussion in 'Information Technology' started by Bruce, Jul 28, 2006.

  1. Bruce

    Bruce
    Expand Collapse
    Guest

    I created a form for my business to track customers but, the form will not
    let me move to the next page for a new entry record. Although the entry
    record box is dispayed at the bottom of the page, it's not active, it stays
    on page one. How do I fix the problem?

    Thanks Bruce
     
  2. Loading...


  3. Michael H

    Michael H
    Expand Collapse
    Guest

    Bruce,

    Is the "Allow Additions" property of the form is set to "No"?

    Or, was it opened via code somewhat like this:
    docmd.OpenForm "FormName",acNormal,,,acFormReadOnly

    -Michael



    "Bruce" wrote:

    > I created a form for my business to track customers but, the form will not
    > let me move to the next page for a new entry record. Although the entry
    > record box is dispayed at the bottom of the page, it's not active, it stays
    > on page one. How do I fix the problem?
    >
    > Thanks Bruce
     
  4. Bruce

    Bruce
    Expand Collapse
    Guest

    Michael,

    Yes. The "Allow Additions" in the property section is set to "yes"
    No I'm not opening with a code.

    Bruce

    "Michael H" wrote:

    > Bruce,
    >
    > Is the "Allow Additions" property of the form is set to "No"?
    >
    > Or, was it opened via code somewhat like this:
    > docmd.OpenForm "FormName",acNormal,,,acFormReadOnly
    >
    > -Michael
    >
    >
    >
    > "Bruce" wrote:
    >
    > > I created a form for my business to track customers but, the form will not
    > > let me move to the next page for a new entry record. Although the entry
    > > record box is dispayed at the bottom of the page, it's not active, it stays
    > > on page one. How do I fix the problem?
    > >
    > > Thanks Bruce
     
  5. Michael H

    Michael H
    Expand Collapse
    Guest

    Bruce,

    Is the form based on query? If it is, and that query happens to be
    non-updateable, you won't be able to add new records. This would be the case
    even if you were to open the query directly.

    If instead the form is based on a single table, it is possible you may have
    some database corruption. You may want to try creating a new database and
    importing all your objects into it. If that doesn't work, have a look at
    Jerry Whittle's paper titled "Fix Corrupt Access Database" at Roger's web
    site:
    http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry

    -Michael


    "Bruce" wrote:

    > Michael,
    >
    > Yes. The "Allow Additions" in the property section is set to "yes"
    > No I'm not opening with a code.
    >
    > Bruce
    >
    > "Michael H" wrote:
    >
    > > Bruce,
    > >
    > > Is the "Allow Additions" property of the form is set to "No"?
    > >
    > > Or, was it opened via code somewhat like this:
    > > docmd.OpenForm "FormName",acNormal,,,acFormReadOnly
    > >
    > > -Michael
    > >
    > >
    > >
    > > "Bruce" wrote:
    > >
    > > > I created a form for my business to track customers but, the form will not
    > > > let me move to the next page for a new entry record. Although the entry
    > > > record box is dispayed at the bottom of the page, it's not active, it stays
    > > > on page one. How do I fix the problem?
    > > >
    > > > Thanks Bruce
     

Share This Page