Search results

Problem has been solved. Thank you to everyone for the help. Best reguards KissBambi

No I wasn't able to follow the post. I hope your cold is going to heal and that you can take care of yourself Adam. I go back home and will be back to Office tomorrow morning, my head is going to explode....thank you for your precious help Adam and Moke....not easy but very interesting, a little...

Hello Adam, please can you send me a zip file DB with your solution? I have to reorganize my work. I can't find again on that thread the good zipped file where Example button is based on VBA. Can you send me a full solution with screenshots explaining where I have to go on Access to write VBA...

The query ANzeige Abfrage is wrong. The good query is Anzeige Berufsuche

This is not what I want this should allow NULL value. I don't know where I can write VBA code in Access and how to make the same as you with Example button. Will try to change the query

Hello Moke...I should not use a query for the form? Is it possible to know where I should write on VBA? Problem is that I have an aversion for VBA, if possible I would like to use a simple button but if you explain me with screenShots where I can replace query by VBA, I think I could try to make...

Here with zip file

https://drive.google.com/file/d/1o-LcY8OROo7OVDobW133ZA_fZ__aYpDT/view?usp=sharing

https://drive.google.com/file/d/1o-LcY8OROo7OVDobW133ZA_fZ__aYpDT/view?usp=sharing Please try again

Adam, the file is too big. I will try a new time with Google drive

https://drive.google.com/file/d/1vGjjdIMwKMOD0OjkK__7TXiDrFXVEm7f/view?usp=sharing This is worse

Thank you so much Adam. I am ready to learn how to make things which have a sense with Access!

Maybe this would be more simple just to close the Form and just open it again!No?

https://drive.google.com/file/d/1ubiOxcPEk7IgtNw8WiUH1X-unmSGuJt5/view?usp=sharing You will see that the Macro code is the same you gave me but this asks to enter PK data!

Dear Adam, thank you so much to teach me how to make Access run! This is considerably hard for me to understand the code of the Macro but at least I tried to find a solution....maybe if I put in the WHERE Condition the criterias of search this will manage a new search!

Hello Adam, I put the DataBase under Access 2013 and it seems to work. I created the button and built a Macro behind the button how you explained. When I click on the button, this sends me no records back and Access asks to enter [AnzeigeNummer] which is the PK of Tabelle Anzeige. It displays no...

Here a link to my DataBase under Access 2007 https://drive.google.com/open?id=1FG14XHMVAGCckkOsudA-Ji1dGHw_1-pm Hello, I would like the final user can have a button to open search form again. I need this button to reload paramaters of the form. Name of the formular : Anzeige Berufsuche...

Because I must do first all my degrees and that I feel very bad when I travelled to Spain and Eastern Europe countries, a lot of bad things happened to me. I almost got killed several times during my travels and my stays abroad (traffic accidents, poisoning, food poisoning, physical...

Well Adam, when I was a child I dreamed about USA, and wanted to travel there, For what is moving, at the moment I must stay in Switzerland for the next 15 years. I am sure that if I would move from Switzerland before the next 15 years, I would finish starving under a bridge or killed....

I have swiss nationality and my parents were italian, so I have both citizenships. We don't have those subtilities in french language. For citizenship we use the word nationality. But in Switzerland, if you were born in the country and that your parents are aliens, you don't have the swiss...