Search results

  1. R

    How to get the last character of the string?

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

    Help in DLOOKUP Function

    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?
  3. R

    Help Please

    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!
  4. R

    Sub or Function not defined

    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...
Back
Top Bottom