Recent content by Uldis007

  1. Uldis007

    Solved How to find out the ID of the record to which I am trying to add a duplicate

    Your solution works great! Thank you very much for your help! Have a nice day!
  2. Uldis007

    Solved How to find out the ID of the record to which I am trying to add a duplicate

    Thank you for your response! In my case, this solution will not be the most appropriate.
  3. Uldis007

    Solved How to find out the ID of the record to which I am trying to add a duplicate

    Thanks for the reply! I had that idea but don't understand how to use Dlookup with multiple search criteria? ,. The customer table has three columns, Customer ID (Primary Key), Customer First Name, Customer Second Name, and Number.
  4. Uldis007

    Solved How to find out the ID of the record to which I am trying to add a duplicate

    Hello everyone! I need your help! I have an order form where I can select an already registered customer from the drop-down list, but if the customer is not on the list, I can open the customer registration form and add a new customer via the order form. Customer table columns are indexed to...
  5. Uldis007

    Solved Filters between the start and end dates

    Many thanks to everyone who got involved in solving the problem! You are the best!
  6. Uldis007

    Solved Filters between the start and end dates

    YES! Super big thanks, now it's work! You saved my day!
  7. Uldis007

    Solved Filters between the start and end dates

    The syntax error is no longer displayed, but the dates in the form are not filtered.
  8. Uldis007

    Solved Filters between the start and end dates

    I use : dd/mm/yyyy
  9. Uldis007

    Solved Filters between the start and end dates

    sorry for the mistake. I corrected, but nothing changed
  10. Uldis007

    Solved Filters between the start and end dates

    I added "And" but unfortunately no change
  11. Uldis007

    Solved Filters between the start and end dates

    Hello! I'm trying to create a filter that filters between the start and end dates, but there is a syntax error that I can't find. The other filters work fine, but as I try to filter between dates it shows error 3075 Help please! Here is my code Private Sub btnSearchCase_Click() Dim...
  12. Uldis007

    Solved Return all records in form if combo box is null

    Thank you all for your response, I really appreciate it. @ Ranman256 solution was exactly what was needed. Thanks again and have a nice day
  13. Uldis007

    Solved Return all records in form if combo box is null

    Greetings to all! I am trying to create a filter (for a form based on a query) using the combobox [StatusSearchBox], but it only works when a parameter is selected, if the combobox is empty the form remains empty. I've tried several options 1) Like "*" & [StatusSearchBox] & "*" 2)...
  14. Uldis007

    Solved Updating continuous subform

    I finally understood! It works! I'm so clumsy. Thank you very much for your help and time! Have a nice day!
  15. Uldis007

    Solved Updating continuous subform

    I add the textboxname from property sheet,
Top Bottom