Search results

  1. O

    Query optimization: Why does Access use temporary index instead of index or rushmore for a JOIN query with SUM?

    Hello all, I have two tables: tblSales with the fields ID, GroupID, SalesTypeID, CompanyID, Amount And tblCompany with the fields ID, TypeID The underlined fields are PKs, the bold ones have indexes. Based on these two tables, I created the query qrySalesOfCompanyType2...
  2. O

    "Auto Height" vs. "Can Grow" / "Can Shrink"

    Hello everybody! I can't grasp the difference between "Auto Height" and "Can Grow" / "Can Shrink" properties which are available for some sections in reports and forms like detail section. The MS help wasn't clear. As I understand it, "Auto Height" is the same as the other two together. Is...
  3. O

    How to use Docmd.SetParameter ?

    Hello everybody! I'm new to this nice forum and first want to say hello to all and thank you for your efforts :) My question is simple but I couldn't find the answer anywhere, so I hope some one knows it: How is the use of Docmd.SetParameter? See https : //...
Back
Top Bottom