Results 1 to 17 of 17

Thread: [ALMOST RESOLVED] Selecting number of records to display

Threaded View

  1. Jul 26th, 2007, 11:14 AM #1
    aikidokid
    aikidokid is offline

    Thread Starter
    Frenzied Member aikidokid's Avatar
    Join Date
    Aug 2002
    Location
    Bristol, UK
    Posts
    1,968

    Resolved [ALMOST RESOLVED] Selecting number of records to display

    If I want to display the last 30 records from an Access database into a flexgrid, how do I do this?

    Is this the correct order of things?

    1. Find total number of records
    2. Take 30 from that total
    3. Loop through from that value to the end


    Is it this straight forward?

    What if there are no records or less than 30?
    What if records have been deleted? Would this stop me using the primary key as this may not still be in numerical order!

    And any more problems I haven't thought of.
    Last edited by aikidokid; Jul 29th, 2007 at 09:57 AM.
    If somebody helps you, take time to RATE the post. I do.

    "FAILURE IS NOT AN OPTION. It comes bundled with the software."

    Below are some of the threads that have helped me along the way:

    CodeBank submission:
    Listview Backcolor (without subclassing)

    Loading Treeview Nodes From A Database, Creating Registry Keys, Count Number of Lines in TextBox , Excellent RichTextBox Tricks & Tips
    Ideas & Screen Shots For A Code Library App
    How to do Data validation in Excel, Conditional Formating in Excel
    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