Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95   Become a Supporter    ::   Make a Contribution    Let's do it!

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page