Search results

I figured it out. There is a RunMacro function and that did the trick.

Beyond my abilities.

I have an IF block in a macro. In the IF block is MsgBox("Check Data", 4)=6. If you hit yes it opens a form. I have the form set to run a submacro when you close it. The Submacro is in the same macro after the IF block. I thought if I select no in the IF block it would go on to run the...

See attached. The MDL_MAST table is the data I had to work with. The Delimiters query counts how many semi-colons there are in the field in the ENH_MODEL field in the MDL_MAST table. Table1 is numbers table that is used for the ParseText function. If you run the delimiters query the highest...

Sorry I had a lot going on. My niece wrote a VBA for me that took care of it. Thanks for the help.

For the aftermarket parts I would suggest either the parts manufacturer's site or using Show Me The Parts online catalog interface. There is an option there to search by part number. Possibly a combination of both. Also the big box stores usually have what else this part fits section. For OE...

Are you talking about OE parts, aftermarket parts, or a mix of both?

My way does not work. One model code is paired with 73/23475. Using the Like "*" & [FieldName] & "*" it comes back with both 73\23475 and 3\23. DBGuy, I just added the those codes to the tables and ran the query. Yours does the same as mine.

DBGuy - Thanks for sending that over. The funny thing is that after I posted the sample data up I thought about taking the other data set I was going to link to, combining the coding with the backward slash in the middle and doing what you did in your query.

OK I attached it. #1 is how the data is in the linked table. I can do nothing about that. #2 is an example of how I would like it unconcatenated. #3 is the final format I will put it in so I can query it against another table.

The zip folder is in a OneDrive folder. I tried to post the share link to it but like I said, you need (10) posts to post an image or a link.

Thanks. The stuff I do is mostly what fits what and then a lot of updating and QC'ing the data. I was a mechanic for a long time until I got hurt. Then I moved into an office. I was amazed at all the stuff that goes on in the background to sell auto parts.

The site will not let me post a link due to my post count.

What is the best way to share it? Does it need to be in ZIP folder like when emailing?

OK so I have two different data sets. Set one the largest string count is three. Using the union function I used this VBA I found: Public Function ParseText(TextIn As String, X) As Variant On Error Resume Next Dim var As Variant var = Split(TextIn, ";", -1) ParseText = var(X) End Function I...

The data is what it is. It is back end data for a program we use. I need to figure out a way to work with it. I do not want to export and re-import data to and from Excel if I do not have to. I thought of using unions but again, I would have to do a union for as many strings there are and that...

I am sorry for not stating this originally, the data is in Access. I updated my original post.

"Unconcatenating" Data In A Field - Access Good morning. I have an Access table with data in two fields - __F1__|______F2______ Name1 | 47;1295; Name2 | Name3 | 1412;1893;1912 Name4 | 14;1492;1812 Name5 | 1247;1298 The names in F1 will always be unique There might be some overlap in F2. If...

Hello all. I have lurked around for a while using Google searches. I figured I would finally set up an account. I currently work in the automotive industry. Aftermarket auto parts to be exact. I work with data files. I build data files that tell you what applications part X fits. I am...