Results 1 to 2 of 2

Thread: Multiple Records ?

  1. Jun 25th, 2000, 08:38 PM #1
    kinjalgp
    kinjalgp is offline

    Thread Starter
    Fanatic Member kinjalgp's Avatar
    Join Date
    Apr 2000
    Location
    India
    Posts
    535
    How to find out that a field in Ms Access Database contains two or more same records? I tried using
    "If RS.Recordcount > 1" but it does not work out.
    I don't have a primary key defined in my database.

    Any help will be appreciated.

    kInjal
    Reply With Quote Reply With Quote
  2. Jun 25th, 2000, 09:24 PM #2
    BHostmeyer
    BHostmeyer is offline
    Lively Member
    Join Date
    Jan 1999
    Posts
    81

    For got a step



    dim Recordcounter as string

    on error resume next 'incase there is no records
    Database.Recordset.Movelast
    Database.Recordset.Movefirst
    recordcounter = database.recordset.recordcount


    this will give you the recordcount that you want...

    Hope this helps


    -------------------------
    There is never only one right answer. That is the magic of programming.
    -------------------------
    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