Gismo's latest activity

  • G
    Gismo replied to the thread Like Function.
    Hi, This really looks good but I see what you mean and I never actually looked at it this way as you mentioned how much like is like I...
  • G
    Gismo replied to the thread Like Function.
    Hi I have a list of a few items attached
  • G
    Gismo replied to the thread Like Function.
    I would not know what i need, that is why the second form should suggest all possible records based on the record in the main form
  • G
    Gismo replied to the thread Like Function.
    How much like is Like, agree, so many different variants Yes the first form is just one record, second for could display multiples I do...
  • G
    Gismo replied to the thread Like Function.
    I am not entering any characters, when any of the above list is in focus on the main form, any like records should reflect in the second...
  • G
    Gismo replied to the thread Like Function.
    Hi, There is no pattern in any of the data. I can not hard code, I have 8025 record with no specific format
    • 1631102085444.png
  • G
    Gismo replied to the thread Like Function.
    With reference to just this sample see below When the main form has focus on 2010-0006 or 2010-0006-CN, I would like to see both on...
    • 1631101438256.png
  • G
    Gismo replied to the thread Like Function.
    No these are not existing known value, this was just an example Any value in my main form must have a lookup for like values in the...
  • G
    Gismo replied to the thread Like Function.
    How would I get 2010-0006 or any other string?
  • G
    Gismo reacted to Minty's post in the thread Like Function with Like Like.
    The wild card comes after the -CN at the end of your string so in your first example it won't return 2021-0006. Your other expression...
  • G
    Gismo posted the thread Like Function in Queries.
    Hi All, Please could you assist I have a string value of 2010-0006-CN, I want the query to show me all records like this one When...
  • G
    Gismo reacted to Pat Hartman's post in the thread Tables / Queries Duplicating Data with Like Like.
    Do you know which form is bound to which table? If so, that is where you start. Look for code in the Current, Open, and Load events...
  • G
    Gismo replied to the thread Tables / Queries Duplicating Data.
    I am not sure from which form the duplication comes from so not even sure where to start looking for the error code
  • G
    Gismo reacted to Pat Hartman's post in the thread Tables / Queries Duplicating Data with Like Like.
    Phantom records whether they are duplicates or not are usually created by your own code. Check the forms that update the table(s) in...
  • G
    Hi All, Hope all is well. I have a weird scenario where some users does some action, not sure yet as to what, where in some instances...
Top Bottom