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.

...with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. ************************** I have created the table Test3 just for the test purposes but for sme reason the maintenece package is not finding it. If...

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

...machine. #1 and #2 still ran fine whenever their turn came even after the move, but today i noticed that #3 failed with this error message: *************************************** " Executed as user: [COMPANYNAME\SQLServer. 10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent...

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)

...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 folder path here]" Dim objFile As FileInfo Dim objDir As...

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

...orderid passed from the datagrid. On the double click event, i have this code and in the message box i do see the correct orderid, for each row: ****************************** varOrderid = grdRecordsListing.Item(grdRecordsListing.CurrentRowIndex, 0) MsgBox(varOrderid)...

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.

...on the line that i have pointed. I have checked all the referneces and everything seems to be there. Any help will be appreciated. Thanks. ******************************************** Dim xmlas As MSXML2.DOMDocument Set xmlas = New MSXML2.DOMDocument Dim varstatus Dim nodeAttribute Dim...

...to pass in parameters to the source query. Right now its pulling the entire Table1 in the output. http://www.tek-tips.com/faqs.cfm?fid=3940 ************************ Dim rpt As New CrystalReport2 Dim varStartDate As Date Dim varEndDate As Date varStartDate =...

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