Search results for query: *

Hi, I have VB .net application. It runs fine when I run it in debug mode. But when I call the .Exe from command prompt, it completes all the tasks it throws the message saying 'memory could not be read. Click ok to terminate'. I am a little new to the .net world. How can I avoid this message...

Hi All, I am converting one of VB 6 apps to .Net. This application gets called by DOS. Application sends return code to dos. How can I do the same in VB .Net? The code in VB 6 looks as shown below. Dim VarData as integer Private Declare Sub ExitProcess Lib "kernel32" (ByVal uExitCode As Long)...

Matching value may not be in the begining. It can be anywhere in the column. For example, if the value of the Table1.Col1 is "TEST", the value of Table2.Col1 can be "BEST TEST BEST".

I am trying to inner join on 2 tables. But when I was getting ready to write "ON caluse, I realised that only part of the 2nd colum (from 2nd table) matches the first column of the first table. How can I get the matching rows? Help is appreciated.

Hi, I have 400 pdfs. All are single page pdfs. I can open each one of them in Adobe Acrobat and save them as JPEG. Is there anyway that I can do this as a batch using vb.net?. Help is appreciated. Thanks, Adimulam

Hi, I am loading a flat file into SQL table through DTS package. The data looks like as follows.. 123 1/1/05 123 1/2/05 234 1/3/05 234 0/2/05 234 1/6/05 It is two field data. The second field is defined as Date data type. If there is a date value coming as 0/2/05 in the data file, file...

Hi All, I worked on VB 6.0. My experience with VBA is very limited. I have a bunch of word documents which have mail merged fileds (Ex: «TOPIC_THIRD»). I want to replace all merged fileds with the data that I have. If I use Word_Doc.MailMerge.Fields after referencing to Word Application and Word...

I have the following command works in VB 6. Does anyone know the equivalent in VB.net?. Appreciate any help. Word_Doc.SaveAs App.Path & "\..\datarecon\" & Replace(Doc_File, ".doc", ".rtf"), FileFormat:=wdFormatXML

Hi, I have a bunch of MS word documents of size 5.5 x 8.5. They have some tags inside them that look like <Name>, <PhNo>. I am trying to take each of these word documents, replace these tags with the actual values that I have and covert them into pdfs with the same name and same size. If I have...

But does Readall work fine, it the file size is 2 MB?

It is a text file. The file is of 1 MB size. There is a word inside the text file that has to be replace by some other word. I do not want to open the file and read every single line, look for that WORD and replace it. If there is a way to replace that WORD without opening and closing the file...

Hi All, Is there any in VB where you can replace a piece of text in the file and savethe file without opening the file, reading it and writing it to a separate file?. I appreciate your help.

Hi, I have a table with 10 columns. One of them is a Signature column. The table has 100 rows and but there are only 5 different signature values. I want to extract the data in such a way that the resultset has 5 rows (with all colums) and each row has a different signature. Please help!!!

Hi, My problem looks simple. But I am strugling to build a query to get the result I wanted. I have a two column table. I need the rows that have more than one combination of values. For example... Col1: Col2: 1 A 1 A 2 B 2 C 3 B 3 B 3...

Hi ALl, I have a flat file (Pipe delimited) with 200,000 records in it. I am using DTS to load the data into a table. I am getting the following error. Error at Source for Row number 32154. Errors encountered so far in this task: 1. Error Source: Microsoft Data Transformation Services Flat File...

I wanted to get a file count of a specific type in a given folder. Is there any function in VB so that I can get the file count if I pass type of the file and path as arguments?. I would appreciate your help. Thanks, Srini

I have the indexes on the columns involved. But it is still not affective. Adimulam

Hi All, I wrote this following UPDATE JOIN query. It works well when I have a small amount of data in both tables. But it takes a while when I have more data. Is there any way that I can improve this? Thank you in advance! Update ALLPOL set POLH_AGENTTOTAL_PRIOR_Q = (select...

Hi All, I was using INSERT statement to insert the rows from a flat file to a table. Since it was taking too long to load the data, now I created the DTS package to load the data directly from the data file. The flat data file is a pipe delimited data file. When I have two pipes are next to each...

I found the answer myself. Wsheet.Cells(18, 18).Numberformat = &quot;##0.00&quot; Thanks, Adimulam