Use String Functions to Validate Part Numbers in Microsoft Access: Left, Right, Mid, Len, InStr

[@petewarby7158]

Omg is there nothing you don't know. This series of tutorials are EXCEPTIONAL

[@homeheart1276]

[2:38] "I know you need this for real work. The rest of us are just goofing around" lol! This is one of the reasons why I love you man. Thank you :)

[@599CD]

8-)

[@דודקלדרון-כ6פ]

Hi Richard! First of all, I learn A LOT from you! Thank you so much for your educational videos. I have a little problem that it not seems to be solved with these 5 methods and I bet you can help: I need to find all the records that contain fructure of a string from another string, in a case like this: "ABCDEF" - will return "ABC", "BCD", "CDE" and so on... if they are exist... I tried to figure it out, with no luck.. Thanks a lot in advanced!!!

[@599CD]

Sounds like a job for InStr

[@jstan3076]

Thank you , Professor Access , it help me too

[@599CD]

You're welcome

[@gregorytaylor2749]

Good video! I work a lot with string validation, so I sometimes write an expression like: IsValid:IIF(P LIKE "[P]???-?[1-9]##" AND P LIKE "*X*","VALID" , "*INVALID*")

[@599CD]

Thanks for sharing!

[@luzkrg]

Really interesting, thank you! 🤩

[@599CD]

My pleasure!

[@adamsanaf]

Thanks Richard. Helpful tutorial. I hope i could pick your brain abit. I am planning to create a database with a scanning feature. The thing is when i scan the dmc code, it gives out a 48 character string and out 48 characters, i need only two parts of it, i.e the 26th to 35th characters and the 40th to 48th characters. The first one acts as a foreign key while the second one acts as a entry name. Do u know how could i extract these numbers from the string? Thank you in advance

[@599CD]

Pick here: 599cd.com/ask

[@artistryartistry7239]

Thanks! What would be the syntax for the criteria entry on a particular field in query designer? Len([Field Name])

[@599CD]

Put Len(FieldName) up top and the

[@Thanogr1]

Gee thanks for the idea of breaking down the solution

[@599CD]

You're welcome

[@sudipsukantapaul9109]

How to make Part Number like following format :- YYYYMMDD-001 001, 002, 003 and so on.... On every new day. Please help

[@599CD]

599cd.com/Counter

[@botskie2354]

Good day sir, I wanna ask if is it possible to make this in access if I Have an item with amount 5000.00 and paying for 3 years... And I want to calculate and auto matically input in a table or query ... Like example of this client credit 5000 wnd every month is showing like this , jan-1-21 - 138.88, feb .1 -21 138.88 , mar.1,21- 138.88 And it will auto matically end Until reach the 5000.00 I hope you read this Thank you and have more subscriber ....

[@599CD]

Of course it's possible. Is this an amortized loan, or just a simple non-interest payment? If the former, see 599cd.com/amort

[@msiitian4064]

Great

[@599CD]

thx

[@RitaFonsecaSanchez]

No funciona, sale error

[@599CD]

Huh?