Recent content by root2007

Thanks I will try it.

will that bring the last digit because there are cases that the plate number may be place on the second or first number. Ex. ZVD-134, ZDA-321, ZMD-123, ZEE-653 If I use the '*' will it display all the number like for instance the user entered the 3? Supposedly the result I am looking for are...

Hi everyone, Can you please help me on how to get the last character of the string in query? I have a table name PlateNo and I want to get the last character for registration purposes. Ex. ZMD-123 - I want to get the number three(3) and if its possible every time the user types the last digit...

Thanks John for your help. More Power and God bless!

Hi folks, Can you please help with my dlookup function. I wrote this VB txtPlateNo = DLookup("DesignatedTruck", "Driver Info", "DriverName = " & txtDriverName) and the error is "syntax error (missing operator) in query expression" What will I do?

Thank to for your help and thank you for the info you gave me about posting. More power!

Hi everyone, Can you please help me on how to get the number of days per month? What is the VB syntax for it? Thanks and more power!

Hi Rain, thank you for your time but I already figure out the error. Thanks and more power

Hi, I am new here and just started learning MS Access. I have a problem with the code I am doing now and the error is "Sub or function not defined" the code is: Option Compare Database Option Explicit Private Sub AddToWhere(FieldValue As Variant, FieldName As String, MyCriteria As String...