Search results for query: *

Hello, I am trying to add the string "XYZ" to each file name and then move my files from folderA to folderB. This is the code that i have so far. ********************************** Private Const varSourceAddress As String = "\\serverA\drivename\FolderA\" Dim diaddr As New...

Thank you, It worked!

Hello, I am trying to increase the field size of column of a table, that has 500,000+ records in it, but the system keeps timing out. I have tried to stop and restart the SQL Server service also, and then tried to make my change but same thing happens. In the database the connection time...

Thanks to both of you for your help.

Ok finally it worked. DatabaseName.dbo.Tablename(EmployeeID, Name) VALUES ('100', 'TestName')

I didn't see any option of spefiying a database name. I tried: Insert INTO DatabaseName.Test3 (EmployeeID, Name) VALUE ('100', 'TestName') But i got the same error.

Hello, I have been to trying add a new maintenace package. I chose the "Execute T-SQL Statementtask", and all i am trying to do here is run an insert statment. But whenever i try to run it, it gives me this error: Executing the query "Insert INTO Test3 (EmployeeID, Name) VALUES...

Thank you very much. I will try that.

Hello, I am trying to send out an email where the receiver should see a person's name in the from part instead of the email address. This is the code i currently have. Something like: Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.configuration") Set Flds =...

Currently we have 3 back ups that run on our SQLServer 2000 like this. 1. Daily diff back up (runs once a day) 2. trans back up (runs every half an hour) 3. Weekly full back up (runs once a week). Last week i moved the physical location of the .bak file to a different machine. #1 and #2 still...

Thank you for your time. Instead of using the multiline text box, i changed it to a listbox (named lstbox) and adding this line of code did the trick: lstBox.Items.Add(t)

Hello, I have been trying to display the contents of a folder in a list box but so far i am having some problems. The closest i have come to is display the file name in a multiline textbox using this code. *********************************** Dim varFolderPath As String varFolderPath = "\\[My...

Hello, First let me tell you that this is the first time for me to work on a vb.NET project, or even on an OO based project for that matter. In my vb.NET project currently i have 2 forms and one class file. Form1 (that has the datagrid on it), form2 and my class (MainOrder.vb). What i am...

tsuji, Thank you for your help. Well for some reason my code was hanging on this line, with the same error: ************************** varstatus = objRefAttr.Text ************************** I changed the code to: ************************** varClientId =...

Hello, I have a datagrid populated with records, with OrderID being the left most column. On the Double click event, I am trying to pass the value of the selected orderID to a class. In that class i have my SQL query which i am building based on the orderid passed from the datagrid. On the...

Ok, to check the validatiaon, i pasted the entire xml file at:http://www.w3schools.com/dom/dom_validate.asp and it told me No Error Found. But in my code, as suggested by you, i have added the "Is Nothing" check and it keeps going to the else part, meaning it is not finding the nodeAttribute.

Thanks for the correction. I have corrected the spelling but still its erroring out the same way and on the same line.

Hello, Below is the code that i am trying to use to read some data from of an xml file, using vb6. I have been getting this error: "Run-time error '91' Object variable or With block variable not set" on the line that i have pointed. I have checked all the referneces and everything seems to be...

Hello, I have 2 forms. Form1 and Form2. Form2 has a CrystalReportViewer on it. From Form1 i am passing 2 variables (start date and end date) to Form2. I am trying to modify the source query of the report at run time, so that it pulls the results within the specified date range only. This is...

A correction, in my query, whereever i've written AR33, thats actually AR3. So the actual syntax is: UPDATE AR3 SET TITLE_ID = TITLECOMPANY.TITLEID2 FROM AR3 INNER JOIN TITLECOMPANY ON AR3.TITLE_CO_NAME = TITLECOMPANY.NAME AND AR3.TITLE_CO_CITY_ST = TITLECOMPANY.CITYSTATEZIP