Recent content by JackBurton07

im sorry i didnt realize that this Stars service was used. I will use this in the future. FYI I am very grateful from the help that I have received - it is invaluable. Please accept my apologies. JB

Hi sorry about the delay - have been out of town for ages. Yeah i just wanted to overwrite the existing file automatically

Hi I want to write a function in vba to save excel automatically, overwriting the existing excel 2007 workbook. Something like this? Sub SaveIt() Thisworkbook.Save Application.OnTime Now + TimeSerial(0, 1, 0), "SaveIt" End Sub

Thanks for this - Do I put my connection string here replacing "Default"? string connectionString = ConfigurationManager .ConnectionStrings["Default"] .ConnectionString;

Hi All, I just cant seem to get this to work?? private void button1_Click(object sender, EventArgs e) { //The connection string is used to describe the type of database, the security information and the location to the database. string ConnStr =...

At present I have a field "DOB" in DD/MM/YYYY format - I want to use SQL to reformat this to MM/DD/YYYY Format. Any ideas as Im stuck! Thanks JB

LOL @ Adrianus Van Der Bruge.

its a data migration - the migrated fields in the staging db all contain nulls from the import and I want to place a value in the NULL's so that the next stage of the migration isnt affected by them.

Hi I want to write a query that will fix names with apostrophes like O' and Mc For example I want to : Convert all surnames in my table beginning with “O Name” to “O’ Name“. I also want to fix all surnames beginning with “McName” to “Mc Name” (where Name represents a surname). Help!

Hi all, what is the sql to replace all cells in a table taht contain NULL's? I want to do this in one query: at present I have to write a query for each column Thanks JB :o

It uses the webservice "getquote" using a stock symbol that the user enters into textbox1.text e.g the user enters "GS" into the textbox, clicks submit and all the stock data is pulled from the web service

Hi Thanks Again - I changed it but its still throwing out "illegal characters in path" Imports System.Xml Imports System.Text.RegularExpressions Imports System.IO Imports System.Net Public Class Form1 Dim ws As New stock.StockQuote Dim wsdoc As New XmlDocument Dim wsurl As...

Thanks - Its now throwing "illegal characters in path"

VS 2005 .NET CF Hi everyone, I am writing a mobile app in vb that returns stock data in xml format from a web service. This works fine but it returns it all in xml format. I want to parse the xml so that each item is on a separate line. I cant get it to work. I would be grateful if you could...

Hi everyone, I am writing a mobile app in vb that returns stock data in xml format from a web service. This works fine but it returns it all in xml format. I want to parse the xml so that each item is on a separate line. I cant get it to work. I would be grateful if you could have a look for...