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!!!
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
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*")
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 ....
![🔴 ฟุตบอลแชมป์กีฬา 7HD แชมเปียน คัพ 2024 [รอบรองชนะเลิศ]](http://i.ytimg.com/vi/zPm8ClLVhoE/mqdefault.jpg)
![[Part 1] รักมาไม่ทันตั้งตัว❤ หนุ่มสาวโสดถูกจับมาแต่งงานกันกะทันหัน แถมเธอยังเป็นหัวหน้าของเขา?!](http://i.ytimg.com/vi/y2pOOMkuFI0/mqdefault.jpg)
[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 :)
8-)
Omg is there nothing you don't know. This series of tutorials are EXCEPTIONAL
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!!!
Sounds like a job for InStr
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
Pick here: 599cd.com/ask
Thanks! What would be the syntax for the criteria entry on a particular field in query designer? Len([Field Name])
Put Len(FieldName) up top and the
Thank you , Professor Access , it help me too
You're welcome
Really interesting, thank you! 🤩
My pleasure!
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*")
Thanks for sharing!
Gee thanks for the idea of breaking down the solution
You're welcome
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 ....
Of course it's possible. Is this an amortized loan, or just a simple non-interest payment? If the former, see 599cd.com/amort
How to make Part Number like following format :-
YYYYMMDD-001
001, 002, 003 and so on.... On every new day.
Please help
599cd.com/Counter
Great
thx
No funciona, sale error
Huh?