Search results for query: *

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...

Hi Buddy, I made a class ... Imports System.Runtime.InteropServices Public Class User32 <DllImport("user32", CharSet:=CharSet.Auto)> _ Public Shared Function GetActiveWindow() As Integer End Function <DllImport("user32", CharSet:=CharSet.Auto)> _ Public Shared Function...

Hi Again, I have been searching the Net for a solution to an old chestnut but having tried 4 solutions, all of which did not work, I have arrived at my favourite forum. In my database app I need to have a form pop up with various bits of info on at varied times, no problem so far BUT I cannot...

Hi BlueJay, If only life was that simple ... I have instigated a workaround which is working so I will put this to bed as unsolved ... unless anyone knows different! Heartfelt thanks to all contributers. DarkConsultant www.contactconsultants.co.uk Live long and prosper \\//

Hi Again, I had already found the article and changed the language to english but this made no difference. Yah I am cleaning it as I go along. I have just installed a new table with a datetime column and manually inserted getdate() into it. The formatting and returns were perfect. So I...

Hi, It is set to British English. DarkConsultant www.contactconsultants.co.uk Live long and prosper \\//