Welcome to SPN

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

Sign Up Now!

1 record table

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

Tags:
  1. George

    George
    Expand Collapse
    Guest

    I would like to suppress adding a new record once the user has completed
    filling in a form. The cursor should go back to the first field in the same
    record. I am using Access 97.
    Thanks in advance for any help you can offer.
    Gerry
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Fri, 2 Jun 2006 11:44:33 -0400, George wrote:

    > I would like to suppress adding a new record once the user has completed
    > filling in a form. The cursor should go back to the first field in the same
    > record. I am using Access 97.
    > Thanks in advance for any help you can offer.
    > Gerry


    If I understand your question, change the Form's Cycle property to
    Current Record.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. George

    George
    Expand Collapse
    Guest

    Hi, Where will I find the forms cycle property?
    Gerry
    "fredg" <fgutkind@example.invalid> wrote in message
    news:cqmmui6bjbgy$.98qumgunppat.dlg@40tude.net...
    > On Fri, 2 Jun 2006 11:44:33 -0400, George wrote:
    >
    >> I would like to suppress adding a new record once the user has completed
    >> filling in a form. The cursor should go back to the first field in the
    >> same
    >> record. I am using Access 97.
    >> Thanks in advance for any help you can offer.
    >> Gerry

    >
    > If I understand your question, change the Form's Cycle property to
    > Current Record.
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
     
  5. SusanV

    SusanV
    Expand Collapse
    Guest

    I'm curious - what's the purpose of this table / form?

    SusanV

    "George" <george@hotmail.com> wrote in message
    news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >I would like to suppress adding a new record once the user has completed
    >filling in a form. The cursor should go back to the first field in the same
    >record. I am using Access 97.
    > Thanks in advance for any help you can offer.
    > Gerry
    >
     
  6. fredg

    fredg
    Expand Collapse
    Guest

    On Fri, 2 Jun 2006 12:12:48 -0400, George wrote:

    > Hi, Where will I find the forms cycle property?
    > Gerry
    > "fredg" <fgutkind@example.invalid> wrote in message
    > news:cqmmui6bjbgy$.98qumgunppat.dlg@40tude.net...
    >> On Fri, 2 Jun 2006 11:44:33 -0400, George wrote:
    >>
    >>> I would like to suppress adding a new record once the user has completed
    >>> filling in a form. The cursor should go back to the first field in the
    >>> same
    >>> record. I am using Access 97.
    >>> Thanks in advance for any help you can offer.
    >>> Gerry

    >>
    >> If I understand your question, change the Form's Cycle property to
    >> Current Record.
    >> --
    >> Fred
    >> Please respond only to this newsgroup.
    >> I do not reply to personal e-mail


    Display the Form's property sheet.
    Click on the Other tab.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  7. George

    George
    Expand Collapse
    Guest

    I am storing a single set of configuration data into 1 record. This is all I
    need and I must eliminate the possibility of having more than 1 record in
    the table.



    Thanks



    "SusanV" <svanallen@nospam-mvps.org> wrote in message
    news:eZJEyFmhGHA.1324@TK2MSFTNGP04.phx.gbl...

    > I'm curious - what's the purpose of this table / form?
    >
    > SusanV
    >
    > "George" <george@hotmail.com> wrote in message
    > news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >>I would like to suppress adding a new record once the user has completed
    >>filling in a form. The cursor should go back to the first field in the
    >>same record. I am using Access 97.
    >> Thanks in advance for any help you can offer.
    >> Gerry
    >>

    >
    >
     
  8. SusanV

    SusanV
    Expand Collapse
    Guest

    Thanks for the answer!

    "George" <george@hotmail.com> wrote in message
    news:O8majQmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >I am storing a single set of configuration data into 1 record. This is all
    >I need and I must eliminate the possibility of having more than 1 record in
    >the table.
    >
    >
    >
    > Thanks
    >
    >
    >
    > "SusanV" <svanallen@nospam-mvps.org> wrote in message
    > news:eZJEyFmhGHA.1324@TK2MSFTNGP04.phx.gbl...
    >
    >> I'm curious - what's the purpose of this table / form?
    >>
    >> SusanV
    >>
    >> "George" <george@hotmail.com> wrote in message
    >> news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >>>I would like to suppress adding a new record once the user has completed
    >>>filling in a form. The cursor should go back to the first field in the
    >>>same record. I am using Access 97.
    >>> Thanks in advance for any help you can offer.
    >>> Gerry
    >>>

    >>
    >>

    >
    >
     
  9. SusanV

    SusanV
    Expand Collapse
    Guest

    Hit send by accident - sorry!

    Thanks for replying. I was wondering though if you might not want some
    history of configuration perhaps? If so you could use an AutoNumber field
    and then base whatever you do with the data on Max of that field.

    Just a thought!
    --
    hth,
    SusanV

    "George" <george@hotmail.com> wrote in message
    news:O8majQmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >I am storing a single set of configuration data into 1 record. This is all
    >I need and I must eliminate the possibility of having more than 1 record in
    >the table.
    >
    >
    >
    > Thanks
    >
    >
    >
    > "SusanV" <svanallen@nospam-mvps.org> wrote in message
    > news:eZJEyFmhGHA.1324@TK2MSFTNGP04.phx.gbl...
    >
    >> I'm curious - what's the purpose of this table / form?
    >>
    >> SusanV
    >>
    >> "George" <george@hotmail.com> wrote in message
    >> news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >>>I would like to suppress adding a new record once the user has completed
    >>>filling in a form. The cursor should go back to the first field in the
    >>>same record. I am using Access 97.
    >>> Thanks in advance for any help you can offer.
    >>> Gerry
    >>>

    >>
    >>

    >
    >
     
  10. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    George wrote:
    > I would like to suppress adding a new record once the user has
    > completed filling in a form. The cursor should go back to the first
    > field in the same record. I am using Access 97.
    > Thanks in advance for any help you can offer.
    > Gerry


    Why not just set the from to not allow data entry in the form property -
    data area?

    --
    Joseph Meehan

    Dia duit
     
  11. George

    George
    Expand Collapse
    Guest

    This is a good idea if one required an audit trail of any changes made to
    the system. I need this for another system I am working on. Thanks
    But the system i am working on presently requires no history. Just a 1
    record table.

    Thanks Susan,
    Gerry

    "SusanV" <svanallen@nospam-mvps.org> wrote in message
    news:u6PzXUmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    > Hit send by accident - sorry!
    >
    > Thanks for replying. I was wondering though if you might not want some
    > history of configuration perhaps? If so you could use an AutoNumber field
    > and then base whatever you do with the data on Max of that field.
    >
    > Just a thought!
    > --
    > hth,
    > SusanV
    >
    > "George" <george@hotmail.com> wrote in message
    > news:O8majQmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >>I am storing a single set of configuration data into 1 record. This is all
    >>I need and I must eliminate the possibility of having more than 1 record
    >>in the table.
    >>
    >>
    >>
    >> Thanks
    >>
    >>
    >>
    >> "SusanV" <svanallen@nospam-mvps.org> wrote in message
    >> news:eZJEyFmhGHA.1324@TK2MSFTNGP04.phx.gbl...
    >>
    >>> I'm curious - what's the purpose of this table / form?
    >>>
    >>> SusanV
    >>>
    >>> "George" <george@hotmail.com> wrote in message
    >>> news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >>>>I would like to suppress adding a new record once the user has completed
    >>>>filling in a form. The cursor should go back to the first field in the
    >>>>same record. I am using Access 97.
    >>>> Thanks in advance for any help you can offer.
    >>>> Gerry
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  12. George

    George
    Expand Collapse
    Guest

    Sorry Joseph, no comprendae.
    Gerry
    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    news:ze_fg.45928$mh.36891@tornado.ohiordc.rr.com...
    > George wrote:
    >> I would like to suppress adding a new record once the user has
    >> completed filling in a form. The cursor should go back to the first
    >> field in the same record. I am using Access 97.
    >> Thanks in advance for any help you can offer.
    >> Gerry

    >
    > Why not just set the from to not allow data entry in the form
    > property - data area?
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
     
  13. SusanV

    SusanV
    Expand Collapse
    Guest

    I'm just convinced that as long as I keep old data I'll probably never need
    it - but the minute I delete or overwrite it I will!

    ;-)

    To limit to one record, set the Allow Additions Property to No. open the
    form in design view, and there's a little square in the upper left of the
    form. Right-click, select Properties, Allow Additions is on the Data tab.

    Good luck!

    SusanV


    "George" <george@hotmail.com> wrote in message
    news:u9U%23DfmhGHA.3584@TK2MSFTNGP04.phx.gbl...
    > This is a good idea if one required an audit trail of any changes made to
    > the system. I need this for another system I am working on. Thanks
    > But the system i am working on presently requires no history. Just a 1
    > record table.
    >
    > Thanks Susan,
    > Gerry
    >
    > "SusanV" <svanallen@nospam-mvps.org> wrote in message
    > news:u6PzXUmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >> Hit send by accident - sorry!
    >>
    >> Thanks for replying. I was wondering though if you might not want some
    >> history of configuration perhaps? If so you could use an AutoNumber field
    >> and then base whatever you do with the data on Max of that field.
    >>
    >> Just a thought!
    >> --
    >> hth,
    >> SusanV
    >>
    >> "George" <george@hotmail.com> wrote in message
    >> news:O8majQmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >>>I am storing a single set of configuration data into 1 record. This is
    >>>all I need and I must eliminate the possibility of having more than 1
    >>>record in the table.
    >>>
    >>>
    >>>
    >>> Thanks
    >>>
    >>>
    >>>
    >>> "SusanV" <svanallen@nospam-mvps.org> wrote in message
    >>> news:eZJEyFmhGHA.1324@TK2MSFTNGP04.phx.gbl...
    >>>
    >>>> I'm curious - what's the purpose of this table / form?
    >>>>
    >>>> SusanV
    >>>>
    >>>> "George" <george@hotmail.com> wrote in message
    >>>> news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >>>>>I would like to suppress adding a new record once the user has
    >>>>>completed filling in a form. The cursor should go back to the first
    >>>>>field in the same record. I am using Access 97.
    >>>>> Thanks in advance for any help you can offer.
    >>>>> Gerry
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  14. George

    George
    Expand Collapse
    Guest

    Susan, This has solved my problem. Thank you very much.
    Gerry

    "SusanV" <svanallen@nospam-mvps.org> wrote in message
    news:O7iHXomhGHA.5096@TK2MSFTNGP02.phx.gbl...
    > I'm just convinced that as long as I keep old data I'll probably never
    > need it - but the minute I delete or overwrite it I will!
    >
    > ;-)
    >
    > To limit to one record, set the Allow Additions Property to No. open the
    > form in design view, and there's a little square in the upper left of the
    > form. Right-click, select Properties, Allow Additions is on the Data tab.
    >
    > Good luck!
    >
    > SusanV
    >
    >
    > "George" <george@hotmail.com> wrote in message
    > news:u9U%23DfmhGHA.3584@TK2MSFTNGP04.phx.gbl...
    >> This is a good idea if one required an audit trail of any changes made to
    >> the system. I need this for another system I am working on. Thanks
    >> But the system i am working on presently requires no history. Just a 1
    >> record table.
    >>
    >> Thanks Susan,
    >> Gerry
    >>
    >> "SusanV" <svanallen@nospam-mvps.org> wrote in message
    >> news:u6PzXUmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >>> Hit send by accident - sorry!
    >>>
    >>> Thanks for replying. I was wondering though if you might not want some
    >>> history of configuration perhaps? If so you could use an AutoNumber
    >>> field and then base whatever you do with the data on Max of that field.
    >>>
    >>> Just a thought!
    >>> --
    >>> hth,
    >>> SusanV
    >>>
    >>> "George" <george@hotmail.com> wrote in message
    >>> news:O8majQmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >>>>I am storing a single set of configuration data into 1 record. This is
    >>>>all I need and I must eliminate the possibility of having more than 1
    >>>>record in the table.
    >>>>
    >>>>
    >>>>
    >>>> Thanks
    >>>>
    >>>>
    >>>>
    >>>> "SusanV" <svanallen@nospam-mvps.org> wrote in message
    >>>> news:eZJEyFmhGHA.1324@TK2MSFTNGP04.phx.gbl...
    >>>>
    >>>>> I'm curious - what's the purpose of this table / form?
    >>>>>
    >>>>> SusanV
    >>>>>
    >>>>> "George" <george@hotmail.com> wrote in message
    >>>>> news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >>>>>>I would like to suppress adding a new record once the user has
    >>>>>>completed filling in a form. The cursor should go back to the first
    >>>>>>field in the same record. I am using Access 97.
    >>>>>> Thanks in advance for any help you can offer.
    >>>>>> Gerry
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  15. SusanV

    SusanV
    Expand Collapse
    Guest

    Glad to help any time

    ;-)

    "George" <george@hotmail.com> wrote in message
    news:eUBuxxmhGHA.216@TK2MSFTNGP05.phx.gbl...
    > Susan, This has solved my problem. Thank you very much.
    > Gerry
    >
    > "SusanV" <svanallen@nospam-mvps.org> wrote in message
    > news:O7iHXomhGHA.5096@TK2MSFTNGP02.phx.gbl...
    >> I'm just convinced that as long as I keep old data I'll probably never
    >> need it - but the minute I delete or overwrite it I will!
    >>
    >> ;-)
    >>
    >> To limit to one record, set the Allow Additions Property to No. open the
    >> form in design view, and there's a little square in the upper left of the
    >> form. Right-click, select Properties, Allow Additions is on the Data tab.
    >>
    >> Good luck!
    >>
    >> SusanV
    >>
    >>
    >> "George" <george@hotmail.com> wrote in message
    >> news:u9U%23DfmhGHA.3584@TK2MSFTNGP04.phx.gbl...
    >>> This is a good idea if one required an audit trail of any changes made
    >>> to the system. I need this for another system I am working on. Thanks
    >>> But the system i am working on presently requires no history. Just a 1
    >>> record table.
    >>>
    >>> Thanks Susan,
    >>> Gerry
    >>>
    >>> "SusanV" <svanallen@nospam-mvps.org> wrote in message
    >>> news:u6PzXUmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >>>> Hit send by accident - sorry!
    >>>>
    >>>> Thanks for replying. I was wondering though if you might not want some
    >>>> history of configuration perhaps? If so you could use an AutoNumber
    >>>> field and then base whatever you do with the data on Max of that field.
    >>>>
    >>>> Just a thought!
    >>>> --
    >>>> hth,
    >>>> SusanV
    >>>>
    >>>> "George" <george@hotmail.com> wrote in message
    >>>> news:O8majQmhGHA.4896@TK2MSFTNGP05.phx.gbl...
    >>>>>I am storing a single set of configuration data into 1 record. This is
    >>>>>all I need and I must eliminate the possibility of having more than 1
    >>>>>record in the table.
    >>>>>
    >>>>>
    >>>>>
    >>>>> Thanks
    >>>>>
    >>>>>
    >>>>>
    >>>>> "SusanV" <svanallen@nospam-mvps.org> wrote in message
    >>>>> news:eZJEyFmhGHA.1324@TK2MSFTNGP04.phx.gbl...
    >>>>>
    >>>>>> I'm curious - what's the purpose of this table / form?
    >>>>>>
    >>>>>> SusanV
    >>>>>>
    >>>>>> "George" <george@hotmail.com> wrote in message
    >>>>>> news:e3$yOulhGHA.836@TK2MSFTNGP02.phx.gbl...
    >>>>>>>I would like to suppress adding a new record once the user has
    >>>>>>>completed filling in a form. The cursor should go back to the first
    >>>>>>>field in the same record. I am using Access 97.
    >>>>>>> Thanks in advance for any help you can offer.
    >>>>>>> Gerry
    >>>>>>>
    >>>>>>
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  16. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    George wrote:
    > Sorry Joseph, no comprendae.
    > Gerry
    > "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    > news:ze_fg.45928$mh.36891@tornado.ohiordc.rr.com...
    >> George wrote:
    >>> I would like to suppress adding a new record once the user has
    >>> completed filling in a form. The cursor should go back to the first
    >>> field in the same record. I am using Access 97.
    >>> Thanks in advance for any help you can offer.
    >>> Gerry

    >>
    >> Why not just set the from to not allow data entry in the form
    >> property - data area?
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit


    Forms have a data property called data entry. You get to that by doing
    a right click on the top left of the from window while in design mode. Data
    is a tab; select it. You will see data entry as one of the choices. make it
    set to no or not allow or whatever negative choice you have. That will then
    keep anyone from entering a new record using that form.

    --
    Joseph Meehan

    Dia duit
     
  17. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 2 Jun 2006 12:45:58 -0400, "George" <george@hotmail.com>
    wrote:

    >I am storing a single set of configuration data into 1 record. This is all I
    >need and I must eliminate the possibility of having more than 1 record in
    >the table.


    For a table-based solution that will prevent a user from "going
    behind" the Form to mess it up, add a Validation Rule to the table's
    Primary Key to insist that it be equal to its current value. I.e. if
    the PK is an Autonumber and the only record in the table currently has
    that field equal to 1, set that field's Validation Rule property to

    =1

    John W. Vinson[MVP]
     
  18. Peter Danes

    Peter Danes
    Expand Collapse
    Guest

    Hey, thanks, John. That's a cool trick, that can be applied to many other
    situations as well. I'm always looking for ways to "make Access do the work"
    as well as keep things somewhat tamper-resistant. Many of the things I
    deliver must be left open to modification for a variety of reasons, so I'm
    constantly looking to find a balance between accessibility for the end user
    and robustness of the overall application. This one is going in the top
    shelf of my toolbox.

    Pete



    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> píse v diskusním
    príspevku news:jrl182d5389av7bckdph7lc3evd1dk4sm2@4ax.com...
    > On Fri, 2 Jun 2006 12:45:58 -0400, "George" <george@hotmail.com>
    > wrote:
    >
    > >I am storing a single set of configuration data into 1 record. This is

    all I
    > >need and I must eliminate the possibility of having more than 1 record in
    > >the table.

    >
    > For a table-based solution that will prevent a user from "going
    > behind" the Form to mess it up, add a Validation Rule to the table's
    > Primary Key to insist that it be equal to its current value. I.e. if
    > the PK is an Autonumber and the only record in the table currently has
    > that field equal to 1, set that field's Validation Rule property to
    >
    > =1
    >
    > John W. Vinson[MVP]
     
  19. George

    George
    Expand Collapse
    Guest

    Hi John,
    Thanks for the information. I am having a litle problem though. Validation
    rule is not an option when I have selected the PK. Yet all other fields in
    my table has the validation option. What am I doing wrong?
    Gerry

    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:jrl182d5389av7bckdph7lc3evd1dk4sm2@4ax.com...
    > On Fri, 2 Jun 2006 12:45:58 -0400, "George" <george@hotmail.com>
    > wrote:
    >
    >>I am storing a single set of configuration data into 1 record. This is all
    >>I
    >>need and I must eliminate the possibility of having more than 1 record in
    >>the table.

    >
    > For a table-based solution that will prevent a user from "going
    > behind" the Form to mess it up, add a Validation Rule to the table's
    > Primary Key to insist that it be equal to its current value. I.e. if
    > the PK is an Autonumber and the only record in the table currently has
    > that field equal to 1, set that field's Validation Rule property to
    >
    > =1
    >
    > John W. Vinson[MVP]
     
  20. George

    George
    Expand Collapse
    Guest

    Thanks Joseph, Susan sugested this as well and it solved my problem.
    Thanks a lot for your input,
    Gerry

    "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    news:M61gg.45945$mh.29259@tornado.ohiordc.rr.com...
    > George wrote:
    >> Sorry Joseph, no comprendae.
    >> Gerry
    >> "Joseph Meehan" <sligojoe_Spamno@hotmail.com> wrote in message
    >> news:ze_fg.45928$mh.36891@tornado.ohiordc.rr.com...
    >>> George wrote:
    >>>> I would like to suppress adding a new record once the user has
    >>>> completed filling in a form. The cursor should go back to the first
    >>>> field in the same record. I am using Access 97.
    >>>> Thanks in advance for any help you can offer.
    >>>> Gerry
    >>>
    >>> Why not just set the from to not allow data entry in the form
    >>> property - data area?
    >>>
    >>> --
    >>> Joseph Meehan
    >>>
    >>> Dia duit

    >
    > Forms have a data property called data entry. You get to that by doing
    > a right click on the top left of the from window while in design mode.
    > Data is a tab; select it. You will see data entry as one of the choices.
    > make it set to no or not allow or whatever negative choice you have. That
    > will then keep anyone from entering a new record using that form.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
     

Share This Page