Hi,
Can anyone point me in the right direction to learn how to
get real time updates in an Access form from an Excel spreadsheet?
I'm trying to link the following formula which exists in an Excel
spreadsheet and works perfectly to an Access form. It's just like
a checkbook register.
C2=(C1-A2+B2)
I would drag this formula down for a coupel of hundred records
( or "rows"), which leaves me initially with column C full of zeros and
that's OK.
C is the running sum column. The A column is any number
and the B column is any number.
So I look "up" at my last running sum, (C2 looks "up" at C1),
deduct any numbers from A2 and add any number from B2.
So on and so forth as I add numbers into columns A and B.
When I use File / Get External Data / Link Tables it "almost" works,
but there's a lot of fussing around with it (bringing the spreadsheet to the
forefront and then bringing the form to the forefront, etc.), and in the
end, I get a
"spreadsheet is full" error and the whole thing comes a halt. I've tried
various
codes, etc. even from the MS site and they don't work very well. This just
isn't something Access does well I suppose.
Thanks for any help, hints or tips.
Thank you,
Mark