Search results

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

Well I guess that is why I had so many problems with it.

I am trying to use it in a query. Does the Split function only work in VBA?

@theDBguy - I tried that statement and received the following error message: "The expression you entered has an invalid . (dot) or ! operator or invalid paranthesis. You may have entered an invalid identifier or typed parentheses following the Null constant." When I close the error message...

@jdraw - Thanks. That works great. I can get A LOT of use out of that. @theDBguy - Thanks for the examples. I was trying just the split part. I figured more to it so that is why I asked.

@theDBguy - I googled the Split function and tried using their examples and all I got was errors. Would you please provide an example of how to use the Split function in this scenario? @jdraw - Thanks for the function. I used arnelgp's statement but I guess if the code could be modified so that...

I have text like this: L6 - 5.9L 359ci DIESEL DI Turbocharged vin C - 4 valve OHV V8 - 6.6L 6599cc 403ci DIESEL MFI Turbocharged vin L type LGH - 4 valve OHV I want to extract the VIN info - just the letters in bold. In these examples they are both single letters. Sometimes they can be a...

No. The IN in the macro's SQL statement refers to the db where the source table is. I run that macro at least once a month every month. It has worked 100% for two years.

Vlad, the combination of your two things did it. The interesting thing with the INSERT statement is I use one in a macro to do something similar and I had to write it that way for it to work. That db is on a server so IDK if that is has anything to do with it. Pat - I want to keep the monthly...

I had thought of that. Trying that gave me an error message that had to do with my FROM clause.

I checked off the "Require Variable Declaration" but I am still getting the same error message.

The typos were in the post because I realized I could simplify the code after looking at it here. I fixed them in my post. I changed it from Option Compare to Option Explicit. I do not know what "in the VBA IDE, 'Require Variable Declaration." means.

Good morning all. I have some code that updates some local tables from one Access db into another. The source db is replaced with a new version monthly. The current file name is "VCdb_AUGUST_2021.accdb". I added "VCdb_" to the table names in the destination db. This is the code: Option...

@gemma-the-husky - six places? I hear what you are saying but no one at my company is working that hard that we would need six places. Right now I am using @arnelgp's code and it is working great. Thanks again.

@arnelgp - that code worked awesome. Thanks. If I had a payroll I would put you on it. LOL.