Recent content by boggg1

I have a ObjectDataSource (ods) linked to a GridView (gv) on a web page pulling data from Oracle storred procedures. The defined (corporate) solution involves statically setting properties in the ods and gv and the method is quick and reliable. But I have desktop VB6 code and some 50 SQL...

I was afraid someone might suggest that. You are right I must steel myself and do it as I have no other ideas. Thanks for your time, I'll report back when its done.

I have a word template which (when invoked) produces a document with an active X tick box which used to fire an event which ran some code. The tick box no longer fires the event. If I add a new similar tick box to the template then it also does not fire. But if I create an entirely new...

If I have two tables which must be joined, but one of those tables is missing some data then I use an outside join to link the two tables. That way I get data from the first table even when data from the second is absent but I get data from both tables when it is available. My problem comes...

OK, I'll do it as two queries. Thanks [bigglasses]

When I try the second method I get data such as... 25 B1 C1 24 25 B2 C2 24 2 B3 C3 1 3 B4 C4 2 SUM(C) is always 1 less than C ! Where is it getting this last value (the SUM) from ? There are no negative values in the entire column. I should say that the real query is...

How do I do the following... SELECT A, B, C, SUM(A) FROM X I found the following on an Oracle error site... ORA-00937: not a single-group group function Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column...

It turns out to be an icon file with a 32 bit icon inside "attached" to the MSFLXGRD. I redrew the icon at 16 bit (which is quite adequate) and the problem went away. [bigglasses]

No "SP6" in my version. I'll request it is updated and report back in a few days. Thanks. [bigglasses]

If the status box is on a form then status.text will work if the code is in the same form. But if you switch the code to a module then you have to tell module code which form the status box is on eg Formname.status.text form_activate will run every time the form is activated (eg if you click...

I have SP6's version of MSFLXGRD.ocx. How do I tell whether I am fully SP6 ? [bigglasses]

Good thinking SBerthold, never thought it could be me that is out of date. How would I know which version I have ? About does not give any SP numbers. I have a corporate system, I do not do my own upgrades and I have limited access. [bigglasses]

I recently released the latest version of one of my programs after testing it on numerous PC's. But upon release to some 80 users, 3 get an "Unexpected Error" messagebox followed by the program stopping at startup. I copied the program to a new project and systematically cut it back and cut it...

Thanks. Just the mention of subclassing makes my knees go week. But your reply did make me think that maybe something got corrupted, perhaps during the time I was debugging the user control and it was not working. I took everything apart as much as I could, and reconstructed it all again - it...

Worth a try... http://www.xtremevbtalk.com/showthread.php?t=179880 Also, you are not behind a proxy or something similar are you ? Boggg1 [bigglasses]