Search results for query: *

I have a problem. One of my users has managed to do something to her copy of Excel and now everything equals zero. So: =SUM(A1:Z99) == 0 =4+6 == 0 =SUMIF(A1:A300, "",B1:B300) == 0 It doesn't matter what these ranges contain, it doesn't care. Everything equals 0...

Does anyone know of any way - by hook or by crook - to //ensure// that a cell change event is fired? Even if people turn off events, disable macros, hold down sift of print it off and use tip-ex on the cell. I don't care what technologies you use - my resources in this organisation are neigh...

Hi there. I need help retrieving the type of a COM object at run-time. All the examples I've found assume you know the object type in advance - I need some way to get a list of Interfaces a COM object implements. It's driving me mad - help! Yet another...

Good evening, all. I'm trying to re-invent the wheel again purly in the interest of something to do that looks like work and makes me more employable else where. I'm making a hit-counter that can track exit-points. It's going to do this by spotting the page on which the user was last seen...

Please consider the following: public abstract class BaseClass { public abstract void SomeMethod(); } public abstract class MidlevelClass : BaseClass { // Wants me to implement SomeMethod(); // I don't WANT to implement some method! } public abstract class ToplevelClass : MidlevelClass {...

Hi there, Does anyone have a simple way of finding out the domain name of my application without the obvious hack of looking at a request to find out where the user sent it to? SURELY there is a way :) Yet another unchecked rambling brought to you by: Oddball

I'm trying to build a regular expression to work with the .NET Regex object. The expression is designed to parse a forum tag such as [foo bar="foo"] - it should also recognise attributeless tags [foo] and self closing tags [foo /] or [foo bar="foo" /] Here is what I have so far...

Good evening folks - I'm burning the midnight oil here so I may or may not be understandable - please try ;) I'm building a web handler to handle a callback from a AJAX application. I can't seem to get any information about wether the person who has fired the callback is authenticated or not...

This question regards Javascrip's interation with ASP.net. I am trying to extract the session cookie from the browsers cookie cache but I do not appear to be able to do so in Internet Explorer. The session cookie is written and available to me in Firefox, but in IE the document.cookie...

Hi hi hi, I'm trying to do something that should look like the following: SELECT SIZE() FROM `companies` WHERE `companyId` = ?guid It's an odd request but there *is* a point. I'm trying to find which tuple has the most data in it as an arbitrary method of choosing a destination for merging...

Ok - bit of a weird one but we're working on the principle that I don't pay for database processing time so I should use as much as I can get. I want to run a query which returns one column (ignore errors here - I've written it quickly - I'm ok with the basic stuff) SELECT `name` FROM...

Hi hi hi I'm looking for the best way to create a sequence of numbers based on a binary count. I basicaly want to create the sequence of bit activations so I want to return an array of arrays (2d I guess but hardly important) with the numbers like so: {}, {0}, {1}, {0,1}, {2}, {0,2}...

Is there a way to make MySQL connect to a completly seperate server instance on a completly different computer on a completly diferent subnet from said MySQL server and have it move data to that server based on a set of conditions. Basicaly, my company has a hit counter that is eating more and...

Now I know that these two camps are notorious for not getting on properly but I'm using the ODBC drivers and everything SHOULD be working. The wizards in VS.net 2005 are executing queries against the database which look like this: devenv 7dc-8b4 ENTER SQLExecDirectW HSTMT...

If anyone can use this, then here you go. Some don't have dial codes and I havn't included the table creation script - that's for you to do :) This is a perfect target for find and replace to customise it for your schema. I use this table as a lookup for a few different Dropdown Lists and I...

I'm having a bit of a problem deciding which object should handle database serialization for a set of classes I've modeled. Here's the scenario I'm dealing with: _____ ??? / \ [ User Factory ]...

Hi folks. I'm trying to structure an XML document in the most efficient way possible and I have come accross a question I think I need answering. Here is my document structure - sorry no schema yet, this is an XLM doodle if you will. <toolAdmin> <users> <user name="oddball"> <tool...

I'm looking for some advice on what seems to be a very crowded topic. It's not that information is hard to come by on it, it's just that most if it is rubbish or horrificly bias by a provider. I am opening a cyber café - I want to give smartcards to my members so they can log in to my...

Hi hi hi, I need to link the vertical scroll operations for two rich text boxes (already extended to a custom control so I have access to the protected members). I found this method in a post from March '03 but I can't seem to port the code from a DataGrid to my Rich Text Boxes. I need the...

I'm getting a weird error that I'm note entirely sure I'm supposed to be getting. I know that's not much help but the highlights are below. The error I'm getting is "Connection must be valid and open" (yet it just filled the data set from the same connection). The error is occuring when I...