Welcome to SPN

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

Sign Up Now!

Tab Order sequence Question

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

  1. Bolo

    Bolo
    Expand Collapse
    Guest

    When designing or modifying a form, how do you modify the tab order cycle to
    go from the last field in a record to the first field in the next or new
    record? I appreciate your help!

    Thanks Bolo
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News 'Depleting' water table: Punjab fails to provide any data (Business Recorder) Breaking News Mar 18, 2008
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Windows 10-don't Click That Tab! Information Technology Aug 10, 2015
    World ISIS inside Syria's Tabqa military air base: activist Breaking News Aug 25, 2014
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Open the form in design mode. Open the properties. Find the "Cycle"
    property. Change it.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP


    "Bolo" <s@bellsouth.net.nospam> wrote in message
    news:lyzvg.18434$cu1.10131@bignews3.bellsouth.net...
    > When designing or modifying a form, how do you modify the tab order cycle
    > to
    > go from the last field in a record to the first field in the next or new
    > record? I appreciate your help!
    >
    > Thanks Bolo
    >
    >
    >
     
  4. Bolo

    Bolo
    Expand Collapse
    Guest

    That's too simple!!!!!!

    Thanks a lot.

    How about this one.

    When using the advanced filter and entering the criteria. Let's say I
    wanted to look for records that in a field the amount is less than or equal
    to six. Okay? So in the criteria box I enter <=6. However, when I apply
    the filter. I still get all of them. BUT, if I put 6 in one criteria and 7
    as another and 8 as another it works. The six does not have to be in
    quotations does it?

    Again I appreciate your help!
    "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    news:%23B1L%2374qGHA.5008@TK2MSFTNGP05.phx.gbl...
    > Open the form in design mode. Open the properties. Find the "Cycle"
    > property. Change it.
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    >
    > "Bolo" <s@bellsouth.net.nospam> wrote in message
    > news:lyzvg.18434$cu1.10131@bignews3.bellsouth.net...
    >> When designing or modifying a form, how do you modify the tab order cycle
    >> to
    >> go from the last field in a record to the first field in the next or new
    >> record? I appreciate your help!
    >>
    >> Thanks Bolo
    >>
    >>
    >>

    >
    >
     
  5. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    <too simple... only if you already know it!>

    If you are working directly in the table, consider using a query instead.

    What datatype is the field?

    What do you get if you put in 6 and 5 and 4...? (<=6)

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP

    "Bolo" <s@bellsouth.net.nospam> wrote in message
    news:zoAvg.13685$Nt.8505@bignews8.bellsouth.net...
    > That's too simple!!!!!!
    >
    > Thanks a lot.
    >
    > How about this one.
    >
    > When using the advanced filter and entering the criteria. Let's say I
    > wanted to look for records that in a field the amount is less than or
    > equal to six. Okay? So in the criteria box I enter <=6. However, when I
    > apply the filter. I still get all of them. BUT, if I put 6 in one
    > criteria and 7 as another and 8 as another it works. The six does not
    > have to be in quotations does it?
    >
    > Again I appreciate your help!
    > "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    > news:%23B1L%2374qGHA.5008@TK2MSFTNGP05.phx.gbl...
    >> Open the form in design mode. Open the properties. Find the "Cycle"
    >> property. Change it.
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >>
    >> "Bolo" <s@bellsouth.net.nospam> wrote in message
    >> news:lyzvg.18434$cu1.10131@bignews3.bellsouth.net...
    >>> When designing or modifying a form, how do you modify the tab order
    >>> cycle to
    >>> go from the last field in a record to the first field in the next or new
    >>> record? I appreciate your help!
    >>>
    >>> Thanks Bolo
    >>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  6. Bolo

    Bolo
    Expand Collapse
    Guest

    oops I meant >= not < It is supposed to only show 5 & 6 level. The
    datatype is a number. I understand query or table, the results are the
    same. Should not the >= work?
    "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    news:uIBLV4ArGHA.4032@TK2MSFTNGP03.phx.gbl...
    > <too simple... only if you already know it!>
    >
    > If you are working directly in the table, consider using a query instead.
    >
    > What datatype is the field?
    >
    > What do you get if you put in 6 and 5 and 4...? (<=6)
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    > "Bolo" <s@bellsouth.net.nospam> wrote in message
    > news:zoAvg.13685$Nt.8505@bignews8.bellsouth.net...
    >> That's too simple!!!!!!
    >>
    >> Thanks a lot.
    >>
    >> How about this one.
    >>
    >> When using the advanced filter and entering the criteria. Let's say I
    >> wanted to look for records that in a field the amount is less than or
    >> equal to six. Okay? So in the criteria box I enter <=6. However, when
    >> I apply the filter. I still get all of them. BUT, if I put 6 in one
    >> criteria and 7 as another and 8 as another it works. The six does not
    >> have to be in quotations does it?
    >>
    >> Again I appreciate your help!
    >> "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    >> news:%23B1L%2374qGHA.5008@TK2MSFTNGP05.phx.gbl...
    >>> Open the form in design mode. Open the properties. Find the "Cycle"
    >>> property. Change it.
    >>>
    >>> Regards
    >>>
    >>> Jeff Boyce
    >>> Microsoft Office/Access MVP
    >>>
    >>>
    >>> "Bolo" <s@bellsouth.net.nospam> wrote in message
    >>> news:lyzvg.18434$cu1.10131@bignews3.bellsouth.net...
    >>>> When designing or modifying a form, how do you modify the tab order
    >>>> cycle to
    >>>> go from the last field in a record to the first field in the next or
    >>>> new
    >>>> record? I appreciate your help!
    >>>>
    >>>> Thanks Bolo
    >>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  7. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    I don't use filters much, so I'm not sure if there's a difference (there
    shouldn't be, but ... ?!)

    Any chance the field is defined as a lookup data type? That could
    potentially mess with your filtering/querying.

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP

    "Bolo" <s@bellsouth.net.nospam> wrote in message
    news:i4Ovg.16109$Nt.15664@bignews8.bellsouth.net...
    > oops I meant >= not < It is supposed to only show 5 & 6 level. The
    > datatype is a number. I understand query or table, the results are the
    > same. Should not the >= work?
    > "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    > news:uIBLV4ArGHA.4032@TK2MSFTNGP03.phx.gbl...
    >> <too simple... only if you already know it!>
    >>
    >> If you are working directly in the table, consider using a query instead.
    >>
    >> What datatype is the field?
    >>
    >> What do you get if you put in 6 and 5 and 4...? (<=6)
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >> "Bolo" <s@bellsouth.net.nospam> wrote in message
    >> news:zoAvg.13685$Nt.8505@bignews8.bellsouth.net...
    >>> That's too simple!!!!!!
    >>>
    >>> Thanks a lot.
    >>>
    >>> How about this one.
    >>>
    >>> When using the advanced filter and entering the criteria. Let's say I
    >>> wanted to look for records that in a field the amount is less than or
    >>> equal to six. Okay? So in the criteria box I enter <=6. However, when
    >>> I apply the filter. I still get all of them. BUT, if I put 6 in one
    >>> criteria and 7 as another and 8 as another it works. The six does not
    >>> have to be in quotations does it?
    >>>
    >>> Again I appreciate your help!
    >>> "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    >>> news:%23B1L%2374qGHA.5008@TK2MSFTNGP05.phx.gbl...
    >>>> Open the form in design mode. Open the properties. Find the "Cycle"
    >>>> property. Change it.
    >>>>
    >>>> Regards
    >>>>
    >>>> Jeff Boyce
    >>>> Microsoft Office/Access MVP
    >>>>
    >>>>
    >>>> "Bolo" <s@bellsouth.net.nospam> wrote in message
    >>>> news:lyzvg.18434$cu1.10131@bignews3.bellsouth.net...
    >>>>> When designing or modifying a form, how do you modify the tab order
    >>>>> cycle to
    >>>>> go from the last field in a record to the first field in the next or
    >>>>> new
    >>>>> record? I appreciate your help!
    >>>>>
    >>>>> Thanks Bolo
    >>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  8. Bolo

    Bolo
    Expand Collapse
    Guest

    I don't use Access that much either. I have to teach a class this fall, and
    this is one of the Objectives of the MOS exam. My students have to take it
    at the completion of the class. The book I am using and others I am
    referencing show different options for the criteria, but none show use of
    these options ( >,<.=) so.......

    Well I will keep trying thanks for all your help!
    "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    news:ei6ZczCrGHA.4424@TK2MSFTNGP05.phx.gbl...
    >I don't use filters much, so I'm not sure if there's a difference (there
    >shouldn't be, but ... ?!)
    >
    > Any chance the field is defined as a lookup data type? That could
    > potentially mess with your filtering/querying.
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    > "Bolo" <s@bellsouth.net.nospam> wrote in message
    > news:i4Ovg.16109$Nt.15664@bignews8.bellsouth.net...
    >> oops I meant >= not < It is supposed to only show 5 & 6 level. The
    >> datatype is a number. I understand query or table, the results are the
    >> same. Should not the >= work?
    >> "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    >> news:uIBLV4ArGHA.4032@TK2MSFTNGP03.phx.gbl...
    >>> <too simple... only if you already know it!>
    >>>
    >>> If you are working directly in the table, consider using a query
    >>> instead.
    >>>
    >>> What datatype is the field?
    >>>
    >>> What do you get if you put in 6 and 5 and 4...? (<=6)
    >>>
    >>> Regards
    >>>
    >>> Jeff Boyce
    >>> Microsoft Office/Access MVP
    >>>
    >>> "Bolo" <s@bellsouth.net.nospam> wrote in message
    >>> news:zoAvg.13685$Nt.8505@bignews8.bellsouth.net...
    >>>> That's too simple!!!!!!
    >>>>
    >>>> Thanks a lot.
    >>>>
    >>>> How about this one.
    >>>>
    >>>> When using the advanced filter and entering the criteria. Let's say I
    >>>> wanted to look for records that in a field the amount is less than or
    >>>> equal to six. Okay? So in the criteria box I enter <=6. However,
    >>>> when I apply the filter. I still get all of them. BUT, if I put 6 in
    >>>> one criteria and 7 as another and 8 as another it works. The six does
    >>>> not have to be in quotations does it?
    >>>>
    >>>> Again I appreciate your help!
    >>>> "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    >>>> news:%23B1L%2374qGHA.5008@TK2MSFTNGP05.phx.gbl...
    >>>>> Open the form in design mode. Open the properties. Find the "Cycle"
    >>>>> property. Change it.
    >>>>>
    >>>>> Regards
    >>>>>
    >>>>> Jeff Boyce
    >>>>> Microsoft Office/Access MVP
    >>>>>
    >>>>>
    >>>>> "Bolo" <s@bellsouth.net.nospam> wrote in message
    >>>>> news:lyzvg.18434$cu1.10131@bignews3.bellsouth.net...
    >>>>>> When designing or modifying a form, how do you modify the tab order
    >>>>>> cycle to
    >>>>>> go from the last field in a record to the first field in the next or
    >>>>>> new
    >>>>>> record? I appreciate your help!
    >>>>>>
    >>>>>> Thanks Bolo
    >>>>>>
    >>>>>>
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     

Share This Page