Recent content by beesman

Hi, I'm trying to insert a database field (bigprac.longdesc) into an Excel chart as a cell's comment, but am failing miserably! I'm getting a syntax error with the following code: With cells(i+spacesafter+1,4).AddComment .Visible = False .Text "ALLT(bigprac.longdesc)" & Date End With...

Thanks to everyone for all your help - baltman's SCAN...ENDSCAN command seems to do the trick perfectly :-)

That's great Brian - I appreciate your help with this - but I need the SUM of each record, not the total SUM of each numeric field. At the moment total_val produces the sum of the sum of all fields..if you get my drift 8-) TIA

Thanks Baltman & Ramani - both your solutions seem pretty good. However, using both solutions I still get the following error message before being dumped out of VFP: Microsoft Visual C++ Runtime Library Buffer overrun detected! Program: ...\vfp8.exe A buffer overrun has been detected which has...

Thanks for the reply Brian. Unfortunately, it's not solved the problem. I think that part of the code is ok, as no '+' is added when i = FCOUNT(). Any other ideas? I think it's a buffer overrun error which is crashing VFP. TIA.

Hi, Been trying to figure this one out, but am pretty stumped - so any help really appreciated. I have a dynamically created table with a large number of character & numeric fields. I need to sum the total of all numeric fields & have written the following code: [CODE]strx = 'SUM ' FOR i = 1...