Search results

  1. R

    Using a "frozen" recordsert?

    For a serie of some limitations among some fields in records (=samples) in a table called TbSamples, I need to insert the samples inside in groups of five, not one at each time, but all the empty samples inside that group. I can select the empty samples in TbSamples in a group of five with some...
  2. R

    Right design to avoid duplicate table almost identical

    Hi, Before creating a database that I think it will be complicated I have a question about design and normalization. Please let me explain it with a simple example. I hope it is not too naive for you. Here we go: I keep coins in suitcases inside several rooms. For this distribution the tables...
  3. R

    SELECT...WHERE from SQL to VBA

    Dear all, a simply simply question...that is taking me hours! This is the SQL sentence from a Query in a combo (which is filtered for another combo, nothing special, letting only the values with the first letter in that combo). How can I write it for VBA???? (Please, indicate all the ", I...
  4. R

    Filtering Form from a many-to-many relationship

    Hi, I am trying to write a "[Forms]![Nameform].Filter =" a little bit more complex... I need to filter a Form (Orders) in order to let a User only to access to his/her own orders. Tables "Orders" and "Users" are linked by a many-to-many intermediate table, "OrderUser" (with only three fields...
Top Bottom