Search results

Suppose I have 4 separate bytes that i need to arrange in a single variable of Long data type (IP address, to be specific) I don't care about sign, just need to put bit data into a variable of 4 bytes size. This seemed like a trivial thing to me, but the function below generates Overflow...

You're right, I'm better off doing all with VB. Not sure I even need Excel - will try MS Access VB code first. Thanks, anyway.

Jon, Thanks, that works. There's only one problem - on a larger data base (a few thousand records) it takes forever to get the second query finish. Any ideas how this could be optimized?

Thanks, folks

I'm trying to figure out if it's possible to calculate moving average in query. Searching through previous posts, all I could find is: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31806 There are good ideas there. Apparently, this works fine, but what I actually need...

Looks like I figured out how to insert data into that chart using VB. If anyone need details, go ahead and ask.

While creating charts in reports and forms I've found some interesting ActiveX control that I somehow have installed, called Extended Graphics Server. It seems to be very nice add on, although I have no idea when and how this was added on my system - perhaps was included with some other...