Navigation buttons dulling

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Liam
    #1

    Navigation buttons dulling

    ok I have built a simple form which has next and previous button on
    it. Now what i want to happen is when I get to the last button in the
    set of records the button which it is at, i.e. if and the end the next
    button and if at the start the previous button should dull out. How do
    I do this?

    Lmxx
    Tags: None
    • PC Datasheet
      #2
      Re: Navigation buttons dulling

      Put the following code in the click event of the next button:
      Me!NextButtonNa me.Enabled = Not Me.RecordsetClo ne.EOF

      Put the following code in the click event of the previous button:
      Me!PreviousButt onName.Enabled = Not Me.RecordsetClo ne.BOF


      --
      PC Datasheet
      Your Resource For Help With Access, Excel And Word Applications
      resource@pcdata sheet.com
      https://www.pcdatasheet.com



      "Liam" <liambresnahan@ hotmail.com> wrote in message
      news:265a10d2.0 311261334.46259 fd@posting.goog le.com...[color=blue]
      > ok I have built a simple form which has next and previous button on
      > it. Now what i want to happen is when I get to the last button in the
      > set of records the button which it is at, i.e. if and the end the next
      > button and if at the start the previous button should dull out. How do
      > I do this?
      >
      > Lmxx[/color]


        Comment

        • Squirrel
          #3
          Re: Navigation buttons dulling

          This solution is so elegant I tried it but RecordsetClone. EOF (on a NEXT
          button) never becomes true.
          What am I missing?



          "PC Datasheet" <spam@nospam.sp am> wrote in message
          news:nVaxb.2091 3$Rk5.14964@new sread1.news.atl .earthlink.net. ..[color=blue]
          > Put the following code in the click event of the next button:
          > Me!NextButtonNa me.Enabled = Not Me.RecordsetClo ne.EOF
          >
          > Put the following code in the click event of the previous button:
          > Me!PreviousButt onName.Enabled = Not Me.RecordsetClo ne.BOF
          >
          >
          > --
          > PC Datasheet
          > Your Resource For Help With Access, Excel And Word Applications
          > resource@pcdata sheet.com
          > www.pcdatasheet.com
          >
          >
          > "Liam" <liambresnahan@ hotmail.com> wrote in message
          > news:265a10d2.0 311261334.46259 fd@posting.goog le.com...[color=green]
          > > ok I have built a simple form which has next and previous button on
          > > it. Now what i want to happen is when I get to the last button in the
          > > set of records the button which it is at, i.e. if and the end the next
          > > button and if at the start the previous button should dull out. How do
          > > I do this?
          > >
          > > Lmxx[/color]
          >
          >[/color]


            Comment

            Previous template Next
            Working...