Search results

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