Recent content by mnbuckland

Thanks for your reply. I have overcome the problem by making the recordset a table type instead of a dynaset. Thanks again for the reply

I have a sub routine that extracts data from 1 table, does some calcs and puts results in another table. If I limit the rows to below 5000 the routine works but when I increase the rows to over 10000 it generates a file lock error "3052". I have increased the MaxLocksPerFile" to 30000 in the...

Thank you for the prompt reply. Entered the code as suggested and the report works fine. Thanks again

Can anyone assist in how to set the Link Master Field and the Link Child Field property in Visual Basic. I need to set the property in the Open Report action Thanks in advance