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!

Recent content by july07

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

Part and Inventory Search

Back
Top