Search results

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.

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?

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

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

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

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

No, Not always

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

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

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

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

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

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

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

It worked! Thank you :)

Could you maybe help me with another issue please? I have the same navigation Formular in one of the tabs I have a subform (red) which contains the data in four columns. I would like to update these entries (green) with help of edit button and text fields above (see in attachment). I tried to...

Thank you sooooooooo much it worked!

Hi Sneuberg could you please help me? I have similar issue as above: I have a Main Form with to buttons once leads to navigation form (Personalhauptseite). In navigation form i have have four another forms and in one of them (Mitarbeiterdaten ändern) i have a search field (txt_Search) where I am...