Search results for query: *

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

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

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

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

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

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

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!

Hi there Im new to web services and am trying to set up a web client form in asp.net/VS 2005 that reads stock symbol and displays the relevant stock information from the web service. I can get the stock data pulled from the web service but when is displayed in the broswer its just all along one...

Hi there Im new to web services and am trying to set up a web client form in asp.net/VS 2005 that reads stock symbol and displays the relevant stock information from the web service. I can get the stock data pulled from the web service but when is displayed in the broswer its just all along one...

Hi there Im new to web services and am trying to set up a web client form in asp.net/VS 2005 that reads stock symbol and displays the relevant stock information from the web service. I can get the stock data pulled from the web service but when is displayed in the broswer its just all along one...

Hi I cant get my search button to work - can you see anything wrong below? many thanks jb Private Sub btnfmssearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnfmssearch.Click myRecordSet.Open("Select* from market where fmsidno=" & fmsidno.Text...

I am trying to search via ID_NO which is an autonumber in my access db but am running into a data mismatch error when I click the search button. Please help! Thanks JB ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Private Sub cnd_search1_Click(ByVal sender As System.Object...

Hi, How can I link my help button to my help.htm file? Thanks Jb

Hi When I create a new record, my app is overwriting existing records. Its supposed to create a new id_no ( they are autonumbers in the access database) and update. However its selecting an existing record and overwriting existing records in the database and at the same time creating a new...

Hi, How can I link a crystal report source to a database in my applications current directory? Every time I move the app to a new machine it looks for the database on the other machine. I just want it t o locate the database thats always in its current directory. I dont know how to reference...

Hi I want to begin my application at the first record is this correct? thanks ! sub frm_main myrecordset.open( select* from "client" where bof)

Hi I have a product start date which I am trying to validate. The user needs to input a date ( any date) in the correct format and then they will move down to the product selection combo box. I dont know how I can get it to validdate the date is in the correct format and then focus on the...