Recent content by otto

So, then I leave it as it is. Unfortunately I don't have the option. Anyways it's always good to learn new things about Access and make use of it in the future. :) Thank you for your advice.

Even if you omit the WHERE clause, it creates temp index -> Same showplan output. Only when you remove the sum does it use the existing index. So, I think the creation of the temp index is due to aggregation. As you have guessed, the new index doesn't bring any changes. Thank you very much for...

Which article? Do you have a link for that?

As I mentioned before, the fields already have indexes. So I'm wondering why a temporary index is created instead of using the existing one.

Thank you for your quick reply. Do you know a better way to formulate the query to improve performance?

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...

Hello everyone, Thank you all for your answers. Okay now I understand it, at least theoretically. So I I've created a form with formheader visible to see it in action. The AutoHeight property for the formheader is set to Yes. At the bottom of the form I put a textfield (init height 300)...

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...

Solved! How to use Docmd.SetParameter ? Hello, nice to hear that topic wasn't boring. I should have asked the question 8 hours ago. Then I wouldn't have lost so much time. Next time I know where I can get help. :) Bye

SOLVED! How to use Docmd.SetParameter ? Your assumption and thoughts are gold value and you fulfill your motto :D Thanks for that. Analog to the query it works also with forms. If you have a filter in say Form2 like ID=[EnterID]And you have a Form1 with a text field txtID and a button...

Thanks for your quick response. At the moment I'm refreshing my Access knowledge and I've read the documentation of DoCmd till this point and I couldn't figure out the purpose and way of using of SetParameter. So I searched for it a lot (the whole afternoon :confused:) however without...

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 : //...