Results 1 to 3 of 3

Thread: Simple Access Question...

  1. Sep 29th, 2000, 06:05 AM #1
    Dragev
    Dragev is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2000
    Location
    Trondheim, Norway
    Posts
    65

    Question

    What's the deal with Access?

    I have a table with 1024 records, and in Form_Load and Data1_Validate, I have:

    Label1.Caption = Data1.Recordset.RecordCount

    Guess what? Label1.caption is 0 or 1 when it starts...
    However, when I click any of the buttons (next, last ...), the correct 1024 is displayed?

    How do I get the RecordCount before I manually click first,prev,next,last?

    D
    Reply With Quote Reply With Quote
  2. Sep 29th, 2000, 07:27 AM #2
    Stevie
    Stevie is offline
    Fanatic Member Stevie's Avatar
    Join Date
    Mar 2000
    Location
    London, UK
    Posts
    565
    You have to move to the last record to start with, so that the record count can be determined.
    VB6 sp5, SQL Server 2000, C#

    There are no stupid questions. Only stupid people.
    Reply With Quote Reply With Quote
  3. Sep 29th, 2000, 07:57 AM #3
    Dragev
    Dragev is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2000
    Location
    Trondheim, Norway
    Posts
    65

    Talking

    Ahhh...

    Thank you so much!

    Have a great weekend!

    ----
    D
    ----
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width