Hello, OK I have worked out the below code to return the 'EN' string if I supply the string code, say "1000". What I need to know is understand how to search for the string and return the string code. If I would use a wildcard in this it would be great. Any Thoughts??? Private Sub XPathSearch(ByVal XMLPath As String) Dim xmlNI As XPathNodeIterator Dim xpathDoc As XPathDocument Dim xmlNav As XPathNavigator Try xpathDoc = New XPathDocument(XMLPath) xmlNav = xpathDoc.CreateNavigator() xmlNI = xmlNav.Select("/MOMLANG/STRING[@code='" & stringValue & "']/LANG[@code='EN']") While (xmlNI.MoveNext()) 'Me.RichTextBox1.AppendText(xmlNI.Current.Name + " : " + xmlNI.Current.Value & vbCrLf) Me.RichTextBox1.AppendText("String value: " + xmlNI.Current.Value & vbCrLf) End While Catch ex As XPathException System.Console.WriteLine("XMLException: " + ex.Message) Catch ex As Exception System.Console.WriteLine("Exception: " + ex.Message) End Try End Sub When people make you see red, be thankful your not colour blind.

japel wrote: The Version 1 release used a local Access DB to store Data but now management want to sync it centrally to an SQL server so group wide reports can be pulled. At that point why even use the Access database at all? japel wrote: SQL Sample Table CustomerID (int) Identity = Y (i.e. Auto incrementing) CustomerName (Text 50) DeleteFlag (int) RecordTimeStamp (timestamp) Don’t forget to add a developerID to that list, wont be long and management will want to know who’s working on which projects.

Will your requirements allow you to start recovery process from within the service? Or does it have to be in a differnt app domain? ~Jason You can only be young once. But you can always be immature. - Dave Barry

In the past I have done this with a getargs sub but why is there a system.environment.getarguments if it is so limited. It must be how I am implementing it. This was the way I was doing it. Function GetCMDArgs() As String() ' Declare variables. Dim separators As String = " " Dim commands As String = Microsoft.VisualBasic.Interaction.Command() Dim CMDargs() As String = commands.Split(separators.ToCharArray) Return CMDargs End Function When people make you see red, be thankful your not colour blind.

Take a look at the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy key. Two subkeys, Domain and Standard Profile. Under my StandardProfile there's a DWORD called EnableFirewall, 1 if enabled, 0 if disabled. You might also want to take a look at this[^] article. C++ I know but everyone should get their feet dirty once in a while :rolleyes: I have no idea what I just said. But my intentions were sincere.

It would have been a lot helpful if you had mentioned anything about what kind of error you get. The call to Console.Write uses formatting, so you have to use String.Format when you want to do the same: Textbox1.Text = String.Format("IP Address {0}: {1} ", i, IpA(i).ToString) & VbCrlf --- b { font-weight: normal; }

Hi Japel, You don't need to modify your code. Just add an imagelist from the toolbox to your form and add some images to it. Click on your listview and set the property 'SmallImageList' to the imagelist you've just added. However, if you want to use different images for different items in your listview, I suggest that you modify your code so that it uses ListviewItems. Regards, Nico

The string concatenation character might help select * from MainTB where upper(myCustomer) like '%'|upper(@myVar)|'%' This will also make it case insensitive. Chris Meech I am Canadian. [heard in a local bar] Nobody likes jerks. [espeir] The zen of the soapbox is hard to attain...[Jörgen Sigvardsson] I wish I could remember what it was like to only have a short term memory.[David Kentley]

Was to quick asking the question. Dim TimeStart As Date Dim TimeStop As Date TimeStart = CDate(labStartTime.Text) TimeStop = CDate(labStopTime.Text) labTimeDiff.Text = "Days from today: " & DateDiff(DateInterval.Second, TimeStart, TimeStop) When people make you see red, be thankful your not colour blind.

http://www.devcity.net/Articles/34/msaccess_sp2.aspx how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06

If that was the case it would not error on insert... Unless I enter the next numbrt it fails... I will look into it further... Thanks When people make you see red, be thankful your not colour blind.

Try altering your SQL commands from ("SELECT Important FROM dbo.ConfigTb WHERE ConfigID = 1") to: ("SELECT Important FROM ConfigTb WHERE ConfigID = 1") I think the "dbo" - may be confusing the Driver. Kind regards - Jakob :cool: ********************************************* Three kinds of people in the world: - Those who can count.. - Those who can't! 10 kinds of people in the world: - Those who understand binary - Those who don't

Thanks Heaps This worked out great... When people make you see red, be thankful your not colour blind.

japel wrote: Do I need to switch to the new Db after it is created??? Yes. After the create, add : "Use database ShowroomRegDB"

Wow i was getting ready to post the exact same question Hope some one answers