Recent content by Kalor

Thanks guys. I imagine it'll feel normal after a while :-)

Hi all, I'm now getting back into vb .net after a few months doing vb6. What I want to do is the usual combo box thing- description with a hidden ID, then select the ID later. I've read zillions of FAQs and they all say the same thing: "Itemdata is now replaced by an object! Isn't it...

Thanks, I should have known that. (I'd already found a work around- I scripted all triggers in Ent Mgr and searched the file :-) ).

I can't find any help on this anywhere! I'm upgrading a big 3rd party app to SQL Server 2000, and I need to loop through every trigger on a database and look for a certain keyword in the trigger's script. Any ideas?

Thanks. That would do it, but what I want is to populate the text box with data looked up in a table, based on the combo box selection (eg the user selects "WA" and the 'State Description' box is populated with 'Western Australia' (or Washington :) ). As onpnt picked up, I think I'm...

Hi all, I want to populate a text box based on the selected value in a SELECT list (combo box). I'm at my wits end trying to get OnChange to do ANYTHING. I've found some examples on the net but if I use the code it still does zippo. Here's my code...

Hi, I maintain the back end of a dodgy 3rd party app that I can't get the source to. It frequently has problems with delimiter characters in string fields- quotes, commas, etc. Since I can't add verification at the front end, I need to clean it at the back. The problem isn't limited to one or...

Cancel that- got it.

What about replacing the buttons with image controls?

Hi all, I've been making update queries with ADODB connection recordsets and I can't use the recordsaffected property. I've tried tinkering with the command object but have only gained a headache. Is that the path I should be going down, or is there an easier way?

The only way I know to do it by a stored proc, ie use a cursor to loop through every record. If Col1 is the same as previous record's Col1 then append a Col2 string variable, else write the record to a temp table and start building a new Col2. How many records are you dealing with? If there are...

Thanks, but I already tried that. The situation is: I have a SQL Server database, and over 100 users of a third party shelf app (MRI) that use it. SOME users access it remotely via Citrix. I need to know the ones that don't. In Citrix I can call up a list of users that are running the mri.exe...

Hi all, I just need to know which system table shows all users who are currently logged in. Sounds like such a basic requirement but I haven't found it yet. I've tried sysprocesses, but it only has records for the users that are currently running something. IS there a table for idle users?