Search results

  1. Manuel Rivera

    Pass through queries and Where condition in openForm

    Hi all, many useful and interesting answers here! @Gasman, @Minty, @Pat Hartman: points taken. Many thanks for explaining this so well. I like the concept of trying to use normal queries more frequently. They are more helpful to the whole developing effort and they are easier and more...
  2. Manuel Rivera

    Pass through queries and Where condition in openForm

    Hi all, Both statements are correct! Thanks ... However, I definitely am going to change the pt query by a normal query because of this: I have been very aware of concepts similar like the one above. But I would have never thought that applying a Where Condition, in an OpenForm command...
  3. Manuel Rivera

    Pass through queries and Where condition in openForm

    Hi guys, many thanks for your answers ... This is the pt query's sql: Select r.Referencia as referencia, r.Descripcion as referenciaDescripcion, r.Producto as producto, r.Talla as talla, r.Color as color, c.Nombre as colorNombre, r.PrecioRefSinIva as precioRefSinIva, r.TasaIva as tasaIva...
  4. Manuel Rivera

    Hi all. New to this forum. My name is Manuel Rivera

    Hi members of this forum. I'm new to this forum. I worked for many years using ms access to develop applications for clients. Then stopped using it for several years. I'm just returning because, from what I remember, Access was just great. So, I'm just remembering or relearning many access...
  5. Manuel Rivera

    Pass through queries and Where condition in openForm

    Hi all, this is my first post in this forum. I have been using Access for a while now, but this is the first time I have created and experimenting with a pass through query. Now I am trying to open a form based on that pt query and using the parameter WhereCondition from the OpenForm command...
Top Bottom