Search results

Interestingly the query opened on its own has the Total row with the correct values. Only on the subform - opened separately - it does not. Strange

In other posts I have read using the AggregateType of 0 should produce a Sum total

I have built a procedure to dynamically rebuild a subform and underlying table based on a crosstab query. This is so that it can show various combinations of categories (rows) and monthly totals (columns). I would like to have a total row appearing on the form and to use VBA to achieve this. The...

That was a quick response and a successful one. Changing Field2 to Field did the trick. Many thanks for that Bodders

I have created an accdb (Access 365 64-bit) for Holiday planning and budgeting, and it has a couple of ribbons with some custom images. To make the application more self-contained I have created a table USysRibbonImages to store them within the database itself. This has 3 fields – ControlID...

A follow-up to the above & thanks again for the responses. I looked at the cross-tab query which was the recordsource for the subform, and optimised by using a subquery. The result was that it solved the probem instantly, and reduced the time to run by a factor of 100 :)

Thanks for the responses. I have tried changing the field names to remove "Description" and those starting with a number - this made very little difference. I will try the suggestion from Isladogs to make the crosstab query as the source - it does not matter that it is read only.

I think this might be worth trying. I will let you know if it works. Thanks.

It's a database I have created to plan my holidays. There is a form that shows the details for each holiday and two subforms, one for dates and one for payments. They are dynamically recreated each time the holiday details are updated.

It's all on the same computer. Intel i5 with 8Gb Ram.

This is an Access front-end and Access back-end. This table is being created on the front end. Size of the dB is about 30 Meg.

Actually both. There are only two records to add but that takes 4 seconds as well

I hope someone can help me with a performance issue in creating dynamic tables using VBA. I have a generic procedure which rebuilds a table to store the contents of a crosstab query. This table is then used to populate a subform. On one particular table the code takes around 4 seconds to run –...