Recent content by Dana_

  1. D

    Search employees by their first/last name in the correct order [A-Z]

    I have a primary key but I did this column hidden on my form I ordered it by LastName but still it doesn't work.
  2. D

    Search employees by their first/last name in the correct order [A-Z]

    Thank you for your reply but Unfortunately I get the same result with your code as before. I thought maybe I should change somehow preveous&next button?
  3. D

    Search employees by their first/last name in the correct order [A-Z]

    I did but it still doesnt work: And my next button is:
  4. D

    Search employees by their first/last name in the correct order [A-Z]

    No. Some Employees have the same Firstname/Lastname for example I have three Person which have the Lastname Muller. When I look for example for Muller at shows me just one record, although I have three records with the same lastname
  5. D

    Search employees by their first/last name in the correct order [A-Z]

    Hello everbody, I have a search field where I can look for an employees by writing their firstname/lastname. It works currently well, but when I look for firstname/lastname which exists more than ones, i cannot see all of them. E.g. there are two Persons in the table, who have the lastname...
  6. D

    How to set Subform data from a main form?

    It works actually like I wanted, thank you for your reply
  7. D

    How to set Subform data from a main form?

    No, Not always
  8. D

    How to set Subform data from a main form?

    Yes I did. I created a control named Abteilung on the subform
  9. D

    How to set Subform data from a main form?

    This code worked. Thank you and @CJ_London. I tried building with intellisense but id did not show Abteilung....
  10. D

    How to set Subform data from a main form?

    Yes I get an error (runtime error), which says it cannot find "Abteilung". I think I am missing something in my code
  11. D

    How to set Subform data from a main form?

    I have a form "MAF_Main" with a subform "AbteilungFunktion", which contains to other forms ("Abteilung", "Funktion"). If button in the main form is clicked, I want to set the value of Combobox inside the subform "Abteilung". Hence I wrote this line of code in my button clicked event, but it...
  12. D

    How to use a SQL SELECT statement with Access VBA

    Thank you guys for the quick reply. It worked with DLOOKUP :) like Ranman256 said.
  13. D

    How to use a SQL SELECT statement with Access VBA

    good afternoon everyone, I have a sql Table "AT_Abteilung" with three columns ID, Name, Description. I created a form where I have a combobox, where I can select a name. If I choose a name it should be able to show the description in the Textfield, where I can change the content. For this I...
  14. D

    Search Form inside of Navigation Form

    unfortunately, I've encountered some issues with this code. E.g. If I change a selected field, all other fields with the same value are changed. But I don't want that, I just want the selected field to change. So I thought I would try to make the change directly in the database using UPDATE...
  15. D

    Search Form inside of Navigation Form

    It worked! Thank you :)
Top Bottom