Recent content by jlkidd

I've been working on a VB.Net and VBA applications that I would like for both of them to utilize an informix database on a unix server. I've installed the Informix CLI 2.5 ODBC drivers that include a program called SetNet32. In our environment we have 3 servers with a total of 5 different...

sunaj Is their a way to do that with a fixed lenth text file instead of a comma delimited one?

Nollauno, I feel like I may be asking a ignorant question but what is SQL-Loader?

For some reason, I am receiving the error, "Index is outside the bounds of the array." I would assume this would mean that my text file is empty and since I am referencing a record in that text file. But I know it is not. In fact it contains over 100,000 lines. My code is this...

Is their someway that I could run the VBA Access 2000 DoCMD.TransferText from outside of Access. My goal is to eventually access this from within a service. I would like to be able to use the filesystemwatcher from within VB.Net to watch an FTP site so that when a new text file is sent, no...

I am using a Access 2000 so I am unable to use "Bulk Insert," as far as I know. The speed begins slowing after just 1,000 records but at 50,000 it becomes so slow that it would only do around 1 record per second. I would like to know more about what fellthor mentioned, "writing...

Code looks like this: myReader = File.OpenText(&quot;\\Barracuda\MIS Documents\Autocar\imperialvdmstr.txt&quot;) 'read data in from imperialvdmstr and place in database While myReader.Peek <> -1 'newRow = dtImperialVDMstr.NewRow() newRow =...

I have a database that I recieve replacement updates on via text file. I need to be able to delete every row/record within a table. I've tried to execute a command object like so: '''''''''''''''''''''''''''''''''''''''''''''''' 'delete the records Dim cn As New OleDb.OleDbConnection()...

I would like to bind a Ole object from an access database to a picture box on a windows form. I've setup databinding for several textbox controls on the form and they work successfully. My problem is that within the advanced databinding window for the picturebox control I am unable to set the...

I have written a small application to simply open and print an Invoice that is an Excel spreadsheet. I want to never see it happen. I just want to wake up and the invoice be ready. I have successful written a program to accomplish this except that since I have used the Now() function in the...

Try using this API guide. Maybe it will help. http://www.vbapi.com/ref/s/shellexecute.html

Use the DateDiff function like this: DateDiff(&quot;h&quot;, &quot;9:00 AM&quot;, &quot;3:00 PM&quot;) This will return a value of 6. &quot;h&quot; specifies hours. &quot;9:00 AM&quot; and &quot;3:00 PM&quot; are dates but you do not need to specify the date because if no date is specified...

That would work if you are going to delete every file. How would I go about moving to the next file within a folder if I do not delete the strCurrentFile?

I was just curious. I have a folder in which files are saved automatically. I would like to implement a program to delete files that were saved older than 3 months ago. My problem is that when I try to say: for each file in folder 'determine file date 'if file date older than 3 months...

It is not registered. This is because I am testing it. I have 2 projects within a project group. One is a module and the other an activeX dll. With the module highlighted I can then reference the dll. This I have done. Then normally I have been able to simply dimension a variable of class type...