Search results for query: *

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

I am writing an ActiveX dll and would like to access it from a module(.bas) file. I have done this before without any problem or confusion. I deleted the premade class and then added a class from the VB Class Builder. I added a method that would accept a date and a text string that was to...

Thank you for your help. I think I am simply going to create another page that way the recordset can be accessed on the server. Thanks again.

I've tried that but using an array but seem to recieve the same error within the server side script. Also, you mentioned sending the recordset to the client. VBScript does have a recordset variable. Is their some way that I can send that recordset and use it within a client side VBScript recordset?

I am attempting to use this disconnected recordset in client side script so that when a department is chosen from a drop down menu another menu will then display all employees from a database whose area match the area chosen. All this information is information that is with in the recordset...

I thought that now that the recordset was disconnected the recordset would persist and would be able to be used in client side script. Was I wrong or am I just getting a type mismatch for some other odd reason?