Search results

  1. 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...
  2. 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...
  3. 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)...
  4. Uldis007

    Solved Updating continuous subform

    Hello! I need to update the continues subform field “txtServisaVieta” after I update combobox “Combo19” in main form. I am trying to use recordset code but the code doesn't work. Main form: RemontaUzdevumiF Subform: PieteikumaPamatojums_uzdevums Can someone please help Private Sub...
  5. Uldis007

    Replace values in

    Hi! In the Access form I have a text box that by default displays the name of the system user who is logged in to the system. But the problem is that the username is displayed in the format "firstname.surname". I need to replace the "dot" with a "space" and the first letters of the name and...
  6. Uldis007

    New member

    Hello everyone! My name is Uldis and I am from Latvia. I've just started using Access and I'm impressed. I am a beginner so I will need the help of community members. Have a nice day!
Top Bottom