Search results

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.

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.

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

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

@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.

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

@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")...

See attached.

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?

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 =...

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

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

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

@MajP - that did it. Thanks.

@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...

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 "-".

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

@jdraw - I ran into something this morning and cannot seem to figure it out. Here is an example of the data I am working with: L6 - 9.3L 570ci DIESEL DI Turbo/Aftercooled/Intercooled type MaxxForce 10 - 4 valve SOHC I want to extract the "MaxxForce 10" from it so in a query I used: EngDesg ...

No worries.

This is posted in the Queries subforum so I figured it was implied.