Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. july07

    Remove a row from a dataset and move other rows up

    Thanks i was able to loop in reverse order and accomplish what i am trying to do. Thanks for the help
  2. july07

    Remove a row from a dataset and move other rows up

    Thanks Jebeson, I have to loop starting from the first row to the last row, because i need the rows to be in order, based on time. if i start from the bottom like you suggested, it wouldn't help what i am trying to accomplish. Is there another way i can start from the first row to the last row...
  3. july07

    Remove a row from a dataset and move other rows up

    Hello, I tried to remove a row from a dataset while looping through the dataset, but it seems other rows are not moving up. I am getting an error message "IndexOutofRange Exception was unhandeled, There is no row at position 21." and i have 30 rows in the dataset. Here is the code and what i...
  4. july07

    Using variable in a vlookup formula in vb.net

    sorry for the wrong information. The variable is TEXT, i assumed it was numerical since the ID were all number. Thanks again Skip.
  5. july07

    Using variable in a vlookup formula in vb.net

    The actual value for the varaible is numerical. I tried your code and it works. Thank you so much. What if the variable is a text, what will change? Thanks.
  6. july07

    Using variable in a vlookup formula in vb.net

    Yes i do. if i put an actual employeeID ( for example 12568) i know exist, in the vlookup formula instead of "EmployeeID" it works. it just doesnt work for the varaiable. Thanks.
  7. july07

    Using variable in a vlookup formula in vb.net

    I am getting the same error with my code and yours, the error is: " COMException was unhandled VLookup method of WorksheetFunction class failed" Thanks.
  8. july07

    Using variable in a vlookup formula in vb.net

    Thanks Andy, the "name" was just an example, not what is in my actual code. Another question what if the EmployeeID is from a dataset. for example: Dim EmployeeID Dim LstName xlApp = New Excel.Application xlWorkBook = xlApp.Workbooks.Open("C:\LookupTable") xlWorkSheet =...
  9. july07

    Using variable in a vlookup formula in vb.net

    Hello, I am trying to vlookup employees name in a excel file from vb.net, using a variable in the vlookup formula and store the name is another variable. I have tried the below code but it does not seem to work because of the variable in the vlookup formula. xlApp = New Excel.Application...
  10. july07

    Converting Text in a Database to Date/Time fromat

    It works fine with "Sql Query" in Ms Access database. I wonder if the syntax is different in VB.
  11. july07

    Converting Text in a Database to Date/Time fromat

    The data types in the source database is "text" and i am trying to convert it to a date format, from sql query. For example the Column names are StartDate and StartTime has: StartDate StartTime 20111025 0025 My query in VB is: Dim sql as Date sql = "SELECT (Mid([StartDate],5,2) & " / "...
  12. july07

    Converting Text in a Database to Date/Time fromat

    Thanks Davejam, The query still, does'nt work. Thanks Andrzejek, That is not the exact names of the fields in the database, i just used that as an example. I have tried different select query but still no success!
  13. july07

    Converting Text in a Database to Date/Time fromat

    Im sorry, but the query did not work. I tried to create a new column by adding the the original date and time and seperating them to the Date format, but it did not work. My Query was: Select Date, Time, (mid([Date],5,2) & "/" & Mid([Date],7,2) & "/" & Left([Date],4)) & " " & (Left([Time],2)...
  14. july07

    Converting Text in a Database to Date/Time fromat

    I just figured it out, i inserted it in my query! I should have thought about it before asking the question! Thanks, July
  15. july07

    Converting Text in a Database to Date/Time fromat

    Hello, i am new to programming and VB.net any help will be appreciated. I have a SQL database that i do not have a "write-access" to, the database has 2 columns that looks like this: Date Time 20111025 0025 How do i create a new Column with VB, that will look like this...
  16. july07

    Quick list question

    Yes! that is exactly what i want.... Thanks Feherke!
  17. july07

    Quick list question

    Thanks for the post Feherke, not quite what i want... What i want is to be able to output each line by itself. For example if i want line 3, i want this "text2a text2b text2c" to be outputted and if i want line 9, i want this "text8a text8b text8c text8d text8e" to be outputted. Thanks
  18. july07

    Quick list question

    Yes, that is only an example and the content of the list can be any text... It is just a list and im trying to output each line by it self.... Is it possible? Thanks for your help
  19. july07

    Quick list question

    I have a list that looks like this: {texta textb textc textd text1a text1b text1c text1d text2a text2b text2c text3a text3b text3c text3d text4a text4b text4c text4d text4e text5a text5b text5c text6a text6b text6c text6d text6e text7a text7b text7c text7d text7e text8a text8b text8c text8d...
  20. july07

    help using '\n' command in Tcl

    Thanks i was able to use foreach [code] set outfile [open "july07.txt" w] set query "select name, Access, description, number, units, syntax from testingresults WHERE LIKE 'testing%' AND Access='read-write'" set foo [sql $query] foreach result $foo { puts $outfile $result } [/code

Part and Inventory Search

Back
Top