Results 1 to 6 of 6

Thread: Distinct Query AbsolutePosition [Solved]

  1. Jun 27th, 2004, 11:43 PM #1
    shragel
    shragel is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2000
    Location
    Brooklyn NY USA
    Posts
    1,258

    Distinct Query AbsolutePosition [Solved]

    When creating a Distinct recordset the AbsolutePosition property is all messed up.

    I Am using DAO on A Access Database.

    Does anyone know how to correct it.
    Last edited by shragel; Jun 28th, 2004 at 05:31 PM.
    Reply With Quote Reply With Quote
  2. Jun 28th, 2004, 01:19 AM #2
    graySteel
    graySteel is offline
    Lively Member
    Join Date
    Jun 2004
    Location
    Dubai, UAE
    Posts
    64
    Hi,

    Can you put down your logic/Code of creating the distinct recordset ? So that I can help you.


    Gs
    Reply With Quote Reply With Quote
  3. Jun 28th, 2004, 12:41 PM #3
    shragel
    shragel is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2000
    Location
    Brooklyn NY USA
    Posts
    1,258
    set rst = dbs.openrecordset("Select Dintinct Field1 From table1")
    msgbox rst.absoluteposition
    Reply With Quote Reply With Quote
  4. Jun 28th, 2004, 05:30 PM #4
    shragel
    shragel is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2000
    Location
    Brooklyn NY USA
    Posts
    1,258
    Figured out the problem.

    In A distinct recordset you can set a bookmark to a old bookmark without getting a error. So it never reloaded the new recordset
    Reply With Quote Reply With Quote
  6. Jun 28th, 2004, 06:02 PM #5
    Vishalgiri
    Vishalgiri is offline
    Hyperactive Member Vishalgiri's Avatar
    Join Date
    Oct 2003
    Location
    India
    Posts
    345
    By the way ADO is better than DAO
    Regards,
    Vishalgiri Goswami
    Gujarat, ( INDIA ).
    ---------------------
    Reply With Quote Reply With Quote
  7. Jun 28th, 2004, 07:50 PM #6
    shragel
    shragel is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2000
    Location
    Brooklyn NY USA
    Posts
    1,258
    True.

    But for access databases dao is much quicker.
    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