Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Unanswered: Check Box Problems

    In my table each record has 25 check boxes and between one and all of these can be selectied for each record.

    My question is "How do transfer these check box values into another table

    Eg if checkboxes 7,15,4,2 are checked i want to create 4 records in a new table for each check value

    then this will be a one to many situation

    Any ideas would be greatly appreciated.

    The Fox

  2. #2
    Join Date
    Jul 2002
    Location
    yugoslavia, vrbas, blok 18 2/7
    Posts
    8
    DIM Rs as recordset, i As INTEGER

    SET Rs=Currentdb.openrecordset("SELECT * FROM <tablename>")
    RS.MoveFirst
    WHILE Rs.EOF=false
    for i=1 to 17
    if rs.fields(i+<offset>).Value=-1 then ' i+<offset> is column
    ' number of the
    ' first check-box (starts from 0)
    insert into ..... ' here put insert command
    end if
    next i
    end while

  3. #3
    Join Date
    Jul 2002
    Location
    yugoslavia, vrbas, blok 18 2/7
    Posts
    8
    DIM Rs as recordset, i As INTEGER

    SET Rs=Currentdb.openrecordset("SELECT * FROM <tablename>")
    RS.MoveFirst
    WHILE Rs.EOF=false
    for i=0 to 17
    if rs.fields(i+<offset>).Value=-1 then ' i+<offset> is column
    ' number of the
    ' first check-box (starts from 0)
    insert into ..... ' here put insert command
    end if
    next i
    end while

Posting Permissions

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