Search results

  1. C

    Recordset with SQL "OR" Statment

    Hello All, I'm trying to build a recordset joining two tables together. I can get the join to work, but I need to use an "or" statement to fill my rs.values Here my statement so far: mocommand.CommandText = "Select JUNK.[MS], JUNK.[CNT]," & _ " LINK.[FROM]...
  2. C

    Min/Max Compare Then Update

    Hello All, I have an interesting situation. I'm working with a large table that contains a shape_id, sequence_num, x_coordinate and y_coordinate. The shape_id holds a unique identifier for the polygon and the sequence_num is a number that either starts with zero or one. This sequence_num may...
  3. C

    Passing Values to a Form (calendar)

    Hi All, Thanks to "Beginning Access97 VBA Programming" by R. Smith & D. Sussman, I was able to implement the use of a calendar form to allow a client to select a date, rather than keying one in. And here I thought I was done with the problem....Wrong !!! The calendar form only works if existing...
  4. C

    Fix End Point

    :)Hello, I have one Access table called plan_location where it contains the following columns: shape_id (number), seqnum (number), xcoord (number) and ycoord(number). The shape_id is a individual number for each planname, the seqnum is the number of points in the plan and the xcoord ycoord...
Back
Top Bottom