Search results for query: *

Thanks for looking into it. With a slight change it worked ! - Thanks Private Sub ClearListBox(Ctrl As MSForms.ListBox) Dim i As Long For i = 0 To Ctrl.ListCount - 1 Ctrl.Selected(i) = False Next i End Sub

Hi, I am trying to find a way to pass an active x listbox control into a procedure to deselect its selection. I have several listboxes that a user makes multi value selections in but would like to use the same function to deselect the items of a listbox by passing in the relevant listbox control...

I have a form that populates serveral datagrids and then after further user select from one datagrid, repopulates itself based on a selection of a single row. This all seems to work fine (hence no code listed) however, right at the end, I get a micrsoft error that kicks me out of the VB...

I am working on code at the moment to read a csv file, remove a speific character in each row and then write the line into a new file. The code runs fine except that when I look at the data in the new file it shows like this: ?????????????????????????????????????????????????? Does anybody...

Thanks for your reply, I was thinking more along the lines of what method to use to open the file, update & save. Thanks

maybe if I knew what to write. Im not very VB literate. Based on it just being a straight forward replace, what is the best method to use ?

Yes, thats what I want to do but is there a limit on the size of the string ? 90000 rows times approx 200 characters.

Is there an effective method for reading a large (90000+ records) csv file and then modifying the values (replacing certain characters) and closing the file ?

Is it possible to override an error message in a stored procedure. I have code that performs an update statement. I want the code to continue through to the next record if if fails on the previous record due to a data type error (245). At the moment, as soon as it hits a record that has the...

Is it possible to determine via an error message which column is causing an error when running a SQL statement? I would like to trap errors that occur when inserting multiple field data into a table down to the field that is causing the error. I am specifically looking a data type errors (error...

Is it possible to trap an error when it occurs in T-SQL and then continue with the statement ? I have an insert statement that I would like to continue with the remaining records if fails on one (for example if one of the fields being inserted is the wrong data type). Is this possible without...

Hi, Thanks for your reply. Definately in the right direction there. Thanks

Does anybody know the correct code to identify a worksheet name from an Excel file ?. I am writing code to look at each worksheet in an excel file and will loop it through each one during an import. Code I have so far but this does not work with the worksheet section. Thanks Function Main...

Is there a way to populate a Global Variable Output Rowset using ActiveX Script ? I am trying to populate a global variable called SourceFiles with file names taken from a specific directory. I have code to find the file names but can not find a way to populate this to the global variable...

Excellent, exactly what I was after. Cheers

Is there are problem using the "Like" operator in VB Script Language in a DTS ActiveX Script ? I get an error description of sub or function not defined when I run the code below but if I use [If oFile.Name = "MainReferral99.csv" Then] instead then the code runs ok. Function Main() Dim...

I think my point was that shipvia was not a field in Order Detail but it still parsed and ran the query. I dont need to brush up on my joins , i just sometimes use the In operator when running queries where it suits.

I am wondering if this is a known bug in SQL 2000 or is it a bug at all ?? use northwind select * from Orders where orderid in (select shipvia from [Order details]) The subquery field shipvia doesnt exist in the [Order Details] table but the full query still runs but returns no records. I...

I would like to execute a specific step contained in the same DTS based on a value that is generated within an ActiveX script. All I need is the line of code that executes the step. Dont seem to find this is the help files? Code emample: ------------------------------------------------------...

Yes, that should not have been there.Please ignor it. Thanks