Recent content by EzGoingKev

  1. E

    Deleting Files Using Author Name

    I have Excel files in a shared folder that I need to delete after importing the data into Access. The folder is a shared folder with co-workers files so I only want to delete the files I created. How do I select the files delete using an Authors name?
  2. E

    Solved Highlight Cells At Year Change

    Because Isaac's solution does not do what I am looking for.
  3. E

    Solved Highlight Cells At Year Change

    I ran into an issue. In my formula of =MOD($B1,2)=0 the 2 is selecting cells containing even numbers. If I change the 2 to a 1 it select cells containing odd numbers. Audi makes an A3 model that came with a 2.0 liter engine. They dropped the 2.0 liter in 2014 and then picked it back up again...
  4. E

    Solved Highlight Cells At Year Change

    He is doing it in Access on a form. I had to change it up some for Excel. I used =MOD($B1,2)=0 and selected the Fill option under Format. Thanks.
  5. E

    Solved Highlight Cells At Year Change

    Good morning. This is what I have in Excel: This is what I want: I want to highlight the rows at each year change. I am assuming I would need to use Conditional Formatting but do not know what to use for a formula. I tried google but came up empty on this. Thanks.
  6. E

    Solved ConcatRelated Issue

    I tried it and could not figure out how to get it to work.
  7. E

    Solved ConcatRelated Issue

    Regarding writing your own - I agree 100% but you need the knowledge to do it. I am at a point where I google what I am looking for. Sometimes the results are plug and play and sometimes it needs to be customized. I have been able to assemble my own code to do things using parts of one function...
  8. E

    Solved ConcatRelated Issue

    @arnelgp - thanks. It works great. @CJ_London - you need to go here and read Mr. Brown's instructions so you fully understand what each part of my ConcatRelated statement does.
  9. E

    Solved ConcatRelated Issue

    It does not work. The query runs without errors but it does not remove the duplicate values. See SampleData2 and the sample2 query.
  10. E

    Solved ConcatRelated Issue

    @arnelgp - I tried the code you posted and got: Compile error: Argument not optional. It opened the code window and ConcatRelated in the portion of the code below was selected: 'arnelgp 'create new dictionary object Set dictValues = CreateObject("Scripting.Dictionary")...
  11. E

    Solved ConcatRelated Issue

    See attached.
  12. E

    Solved ConcatRelated Issue

    So that would be like running a query that selects distinct values without actually creating the query? Also, how would you use that with Allen's code?
  13. E

    Solved ConcatRelated Issue

    I am using Allen Browne's code here. In several queries I am concatenating data from tables/other queries and the data I want to concatenate is in there multiple times. To do it in one step I changed Allen's code here: strSql = "SELECT " & strField & " FROM " & strTable to this strSql =...
  14. E

    Extracting Text From A Field

    That code works. There is a typo in the first line. star_string needs to be start_string.
  15. E

    Extracting Text From A Field

    OK thanks. I understand a little more now. So if you put it a query and there is an issue with the data, like a blank field, an error message would pop up for every single instance. This would hold things up. Leaving it out the query runs and you would just get the #Error in the field and not...
Top Bottom