wrong RecordCount

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

    wrong RecordCount

    why does my recordcount returns the # of actual records + 1? btw, i
    am using ms access. i don't know what happened but at first, my table
    seems ok. the recordcount returns the correct # of records. but as i
    manipulate the table, (add, delete, etc) i get errors and when i
    checked my recordcount, it returns 1 more than the actual # of
    records. what did i do? how can i avoid this to happen again?
    please help!
    nick_faye
    Tags: None
    • Pieter Linden
      #2
      Re: wrong RecordCount

      ivpfmc28@yahoo. com (nick_faye) wrote in message news:<8a5e9892. 0312051728.1055 bc1@posting.goo gle.com>...[color=blue]
      > why does my recordcount returns the # of actual records + 1? btw, i
      > am using ms access. i don't know what happened but at first, my table
      > seems ok. the recordcount returns the correct # of records. but as i
      > manipulate the table, (add, delete, etc) i get errors and when i
      > checked my recordcount, it returns 1 more than the actual # of
      > records. what did i do? how can i avoid this to happen again?
      > please help!
      > nick_faye[/color]

      Guess how many fingers I'm holding up.

      What kind of recordset? could we see the code? (Sorry, my crystal
      ball is in the shop.) "btw, [you] are using Access."
      Congratulations . You're in the right group. What's the difference
      between "at first" and now? If you're opening a static recordset and
      now refreshing the count, then there's your problem.

        Comment

        • nick_faye
          #3
          Re: wrong RecordCount

          pietlinden@hotm ail.com (Pieter Linden) wrote in message news:<bf31e41b. 0312061613.1f7a 3365@posting.go ogle.com>...[color=blue]
          > ivpfmc28@yahoo. com (nick_faye) wrote in message news:<8a5e9892. 0312051728.1055 bc1@posting.goo gle.com>...[color=green]
          > > why does my recordcount returns the # of actual records + 1? btw, i
          > > am using ms access. i don't know what happened but at first, my table
          > > seems ok. the recordcount returns the correct # of records. but as i
          > > manipulate the table, (add, delete, etc) i get errors and when i
          > > checked my recordcount, it returns 1 more than the actual # of
          > > records. what did i do? how can i avoid this to happen again?
          > > please help!
          > > nick_faye[/color]
          >
          > Guess how many fingers I'm holding up.
          >
          > What kind of recordset? could we see the code? (Sorry, my crystal
          > ball is in the shop.) "btw, [you] are using Access."
          > Congratulations . You're in the right group. What's the difference
          > between "at first" and now? If you're opening a static recordset and
          > now refreshing the count, then there's your problem.[/color]

          what do you mean by a static recordset? and how do you refresh your
          recordcount? sorry but i am still a newbie. hope you have a lot of
          patience. what i meant by "at first" is the time i created the table
          until i experience the error. "now" means the time that i am having
          problems. :) i don't know what happened between "at first" and "now"
          that caused my problem.

            Comment

            Previous template Next
            Working...