Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JackBurton07

    Auto Save Excel

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

    Auto Save Excel

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

    Auto Save Excel

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

    Access 2007 Connection

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

    Access 2007 Connection

    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 =...
  6. JackBurton07

    Reformat date to MM/DD/YYYY Format

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

    Fix tricky Surnames

    LOL @ Adrianus Van Der Bruge.
  8. JackBurton07

    Replace NULL cells in a table for all cells with NULL value

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

    Fix tricky Surnames

    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!
  10. JackBurton07

    Replace NULL cells in a table for all cells with NULL value

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

    XML parsing

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

    XML parsing

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

    XML parsing

    Thanks - Its now throwing "illegal characters in path"
  14. JackBurton07

    XML Parsing from a String in VB

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

    XML parsing

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

    Legacy CSV data > MySQL 5 Migration

    Hi, I have a csv file with around 220000 records that I want to import into MySQL 5 but the data in the csv file is quite messy, as its from our old mainframe system and there wasnt much validation done to it etc. I want to clean the data up. Should I use Microsoft Access to clean up the...
  17. JackBurton07

    Web Service XML

    just in a label
  18. JackBurton07

    C# Web Service Client xml browser display

    Hi If I use option 2 how do I specify the path for the xml as all of the examples I have found request an xml filepath e.g see this example it asks for a filepath: http://support.microsoft.com/kb/317069
  19. JackBurton07

    Web Service XML

    Hi I want to properly display a webservice xml data in an application but i keep getting: illegal characters in path error what am i doing wrong? public Form1() { InitializeComponent(); } WSREF.StockQuote ws; private void Form1_Load(object...
  20. JackBurton07

    Insert txt file into a sql server compact edition database

    Hi I want to enter a text file with around 1300 rows/6 columns of comma separated values into a sql server compact edition database however normal sql commands dont seem to work. Does anyone know the correct sql syntax for this in vb 2005? Thanks!

Part and Inventory Search

Back
Top