Recent content by Gismo

  1. G

    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 will filter it further by Category, when I look at Airframe I will not need to see any Engine documents it will be difficult to filter by aircraft type as as...
  2. G

    Like Function

    Hi I have a list of a few items attached
  3. G

    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
  4. G

    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 have another layer of filtering so the options in the second could be limited somewhat I understand what you are saying and I am not sure on how to respond So...
  5. G

    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 form
  6. G

    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
  7. G

    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 the second form
  8. G

    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 second form So any value in the main form should be a lookup from So a combo box wont work I am just not getting any other result than 2010-0006-CN, not even...
  9. G

    Like Function

    How would I get 2010-0006 or any other string?
  10. G

    Like Function

    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 using Like "*2010-0006-CN*" I only get 2010-0006-CN but i know I also have a record 2021-0006 When I link this form to another form I would like to use below but...
  11. G

    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
  12. G

    Tables / Queries Duplicating Data

    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 some data is duplicated, when I don't have any query designed to do so, as far as I know, unless I have a Update or Append query, where I did not notice the...
  13. G

    Print Button

    Hi, For some reason the report does not print but instead it prints the form where I selected which report to print Below is the form where I select the record that needs to print This is my code, it does not refer to the form to be printed but a report Please could you advise
  14. G

    Excel Save as

    Well that did the trick Thank you very much for your assistance and everyone else that always handles my ignorance :) Maybe one day I would be able to assist others :rolleyes:
  15. G

    Excel Save as

    Hi Minty, I tried your suggestion, I even tried a direct Dim File name but still get the FileName Argument notification on cancel
Top Bottom