Search results

  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...
  16. E

    Extracting Text From A Field

    Thanks for the help with this. So I am at point where I can understand some of the VBA and write a little on my own. If I need to do something I will google it, search here, etc. Sometimes I can find something will do exactly what I need it to do. Sometimes it does not do exactly what I need it...
  17. E

    Extracting Text From A Field

    @MajP - that did it. Thanks.
  18. E

    Extracting Text From A Field

    @arnelgp - thanks for the code. I do not believe the validation is working correctly. I am running the function on field in a table using BetweenWords([FieldName], "type", "-"). Here are two examples. Original string -> BetweenWords Result L6 - 9.3L 570ci DIESEL DI...
  19. E

    Extracting Text From A Field

    I guess my understanding of how the function works is incorrect. Using my example: L6 - 9.3L 570ci DIESEL DI Turbo/Aftercooled/Intercooled type MaxxForce 10 - 4 valve SOHC I thought it would pull all text after the word "type" and stop at the second delimiter which I set as "-".
  20. E

    Extracting Text From A Field

    EngineFullDetail is the table's field name I want to extract the data from. Type is the first delimiter.
Top Bottom