Search results

  1. I

    form bound to queries with joins

    Hi, yes I can also edit the records. Everything works ok. Problem is that leaving the form bound to the query I am afraid it implies an overload on the LAN communications since the product tables can easily have 50000 entries. This is why I wanted an unbound form that exchanges with the server...
  2. I

    form bound to queries with joins

    Hi Rabbie, thank you for the idea. I changed the joins in my connection query from RIGHT to INNER exactly like yours. I also replicated your tables and query. When you run the query by itself or you bind the form directly to the query you can add new records, but when you bind the form to the...
  3. I

    form bound to queries with joins

    Hi Rabbie, thank you for the idea. I changed the joins in my connection query from RIGHT to INNER exactly like yours. I also replicated your tables and query. When you run the query by itself or you bind the form directly to the query you can add new records, but when you bind the form to the...
  4. I

    form bound to queries with joins

    Dear users, I need help to troubleshoot an issue that I believe typical of databases, but I can’t find any answer either n books or on websites. Mine is a client/server access application. I use forms connected to ADO recordsets and the instruction set I use to bind the formi s the following...
  5. I

    Binding Forms With Ado

    Hi there, I am having a stupid problem I can't solve. I am developing a database with access 2003 and I want to late bind the form to an ADO recordset via a stored query (the reason for this is that I read that when i will move to SQL server just using stored queries and no queries in code will...
Back
Top Bottom