Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Houston, Texas

    Unanswered: Missing and/or overlapping Info...

    I am trying to identify missing data on a continuous form (bounded to a table). Both From and TO fields are integer

    From TO
    0 12
    14 25
    24 28

    The second record should start with number 13. Also, the 3rd record should start with 26 not 24. They must be set up in correct sequence. (0 to 99 is the array or sequence)

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    If you have an ID (autonumber) field, you can use the me.currentrecord to compare the current record number against the autonumber field. Ex:

    if me.currentrecord = me!MyAutonumberField then
    msgbox "In sequence."
    msgbox "Out of sequence"
    end if

    You can try this on the OnCurrent event. The me.CurrentRecord will give you the current record number and you may be able to utilize it in some way with what you want to do.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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