Search results

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