Count last 32 entries help please.

[Rod]

Hi Orange,



Yes of course, I'm aware of your byline. Marks to be awarded out of 10?

I had problems with recordset clones. I've always understood that a clone used the same recordset as the original but that the pointers/cursors/bookmarks - call them what you will - are different. Well, the procedure is triggered by an After Update event on a field and I expected both the original recordset and the clone to have the new field value. Not so, the original (bound recordset) has the new (after update) value and the clone has the old (pre update) value. What started to be a fairly elegant solution became more messy by having to cater for this anomaly. I tried updating the clone, successfully, but this generated a message that another user/process had updated the record and I couldn't suppress that message.

I'm using clones to avoid jumping all over the place with the original bookmarks, which would probably cause a run time error anyway. In fact I even go so far as to clone a clone - now there's posh!

I think there's scope for making the code a little more elegant and a little slicker but once the basic problem's solved, I tend to lose interest. One thing I should have done is to grab the table for exclusive update.

Hope this survives the transposition to v2003.

MSAF32Records.mdb

[BigMac4]

Ok i have sorted out the little bit in your module to get it to work as i need it but i cannot get it into my database it just wont work must be doing something wrong.

[orange]

Thanks Rod.

[BigMac4]

May need an idiots guide to get this to work for me, anyway when i update my form i get a Compile Error (sub or function not defined) pointing to the CalculateOCL in the Debugger cant find out what is wrong..

Cheers

Mac

[Rod]

May need to see your code but:

Make sure you have installed the standard module that I named, Module1. You may install it as a separate module or you may add the procedures to any convenient standard module that you already have.

Make sure the 'CalculateOCL' procedure is Public.

[BigMac4]

I have it working now, thanks for you help. I have lots more problems that i cant figure out i will post them on this forum in due course.

Again Thanks so much for your help

Mac