Recent content by DarkConsultant

Boom: Cheers buddy .... DarkConsultant www.contactconsultants.co.uk Live long and prosper \\//

Hi, I have two tables, one contains contact information (count = 4500 records) and has a Primary Key of UIN. The other is a members table containing contacts' UIN's (count = 2000 records). I needed to get all the UINs from the contacts table where the same UIN is NOT in the members table so...

S'Okay I found the answer ... window.open(URL); DarkConsultant www.contactconsultants.co.uk Live long and prosper \\//

Additional ... Sorry my redirect function is <script language="javascript" type="text/javascript"> function redirect(URL) { document.location=URL; return false; } </script> DarkConsultant www.contactconsultants.co.uk Live long and prosper \\//

Hi everyone, I am using an onClick event to redirect to a new page but cannot achieve this ... My code is <a href='page1.php' onClick="return redirect ('http://www.bbc.co.uk');" >Click Here</a> It works fine. The problem is I wanted to open the bbc link in a new tab but when when I change...

Hi r937 and feherke, Many many thanks for your replies. I am an app coder and only touch sql about once a year and so cannot keep these things in my head. I would like to do more sql but I cannot choose which contracts I am awarded. I am currently working on an online database with mysql as...

Hi feherke, Thanks for the speedy response, may I ask a question? You have suggested an INNER JOIN on usergroup u, can I ask why not a LEFT JOIN as in the second join? I am not nitpicking I have gaps in my SQL knowledge that I need to fill. The query seems to work the same if I use either...

Hi All, I have a table called usergroup which contains group and subgroup names such .. UIN Name SubGroupOf 1 Contacts NULL 2 Prospects 1 3 Dead 1 A group is a subgroup if it has a SubGroupOf value (Groups are NULL). Another table is called members ... UIN...

Hi All, FormA is my main form and is always open. FormB is a non-modal info form and is open or closed If FormA opens modal FormC then FormC gets focus. I have added some code into the Load event of FormC that checks to see if FormB is open (tracking boolean variable) and if it is then FormB...

Hi All, I was unsure as to wether to carry this on using the previous thread (thanks again, jebenson). My problem with binding has now been cured but ... i am filling the items collection of a combobox with between 0 and 10,000 (yep 10,000) KeyValuePairs(of Integer,String) and at the same...

Hi jebenson, Worked first time as usual, thanks. David DarkConsultant www.contactconsultants.co.uk Live long and prosper \\//

Hi, I am binding a combobox to a List(Of KeyValuePair(Of Integer,String)) using the code ... Contacts is my list of kvp. With cmbContacts .Items.Clear .DisplayMember = "Value" .ValueMember = "Key" .DataSource = New BindingSource(Contacts, Nothing) End With This works OK, populating the...

Hi, Do you know if referenced dll's are 'run' before the first line of code? Regs TIA David DarkConsultant www.contactconsultants.co.uk Live long and prosper \\//

Hi, Yep that got it, thanks mate. I am left with just an annoyance ... before the first line of code runs I get a System.InvalidOperationException. I can halt the app on a global module which seems to be the first run line but the error occurs before this. I have searched for this but I am...

Hi shaminda, I used to be plagued with this exact error which would only happen spasmodically. I seriously considered re-installing VB2005 until I found an article about it which offered this solution. Reduce the strain on the host PC and the problem will go away. I looked at what was running...