Search results

To me the funny thing is that if you run that IF block with the MsgBox and you do not tell it to stop it will go on and do other things after the block. When it hits the submacro it just stops.

I thought it was fixed. If delete the MDL_MAST_2 table from the query it will run. I fixed it and replaced the zip folder.

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