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!

  • Congratulations Chris Miller 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. ljhaley

    Macro to check if cell is empty

    Thank you so much. I do pretty well with VB but this is just different enough to confuse me. My boss does this kind of stuff all of the time and I think he just assumes that everyone else knows how. Thanks again to DaleWatson and Tranpkp for all of your help!
  2. ljhaley

    Macro to check if cell is empty

    Thank you guys so much. The code works but now I am getteing an error when there are no more cells that match my criteria. I tried to use error handling and it works to an extent but I have to push the OK button about 10 times. Here is my code: Sub Find()...
  3. ljhaley

    Macro to check if cell is empty

    Sorry I didn't make it very clear that I need to check four specific cells to see if they are empty. EX: I will search column CY for cells that meet my criteria and If the cell CY39 meets the criteria then I need to check X39:AA39 to see if they are empty. Then I need to mark them in some...
  4. ljhaley

    Reading in a text file through vb to access

    I am trying to read a text file (array) into access through VB. This is what I have but no matter what recordset function I try it doen't work. How do I get the information from one row and then move to the next record to get the info from the next row? Here is what I have: Do While Not EOF(1)...
  5. ljhaley

    Macro to check if cell is empty

    I am trying to automate a process and am not having the best of luck. I need a macro to begin in a column and go down cell by cell until it finds a certain value. (this part I can do) Then I need it to go over (in the row of the cell with the value) and verify that four cells are not empty. If...

Part and Inventory Search

Back
Top