Search results

  1. L

    Update records in subform on click

    I have a form that contains a subform. I want to make a button that on click updates all the records listed in the subform. This is the best I came up with. Can anyone help me get a little closer to a solution? Dim rs As DAO.Recordset Set rs =...
  2. L

    Cannot get vlookup to work

    I opened your sample that you sent and on the sheet 2 columb A all needs to be converted to numbers, you do this by manually selecting all the cells and then selecting the little popup that contains selections one of which is "convert to number" once I did this the error message was gone and it...
  3. L

    Cannot get vlookup to work

    Vlookup vs. Tools > Lookup option Have you ever tried using the lookup option under tools? This might be a good option concidering it writes the formula for you.
  4. L

    Copy string of invoices

    I have invoices that all start with the word "Bill" (conveniently in columb "A")and end with the word "copyright" (also conveniently always in columb "A")but all are different body information and different lengths in the amount of cells it takes up. All the invoices are text format and listed...
Top Bottom