How to create a button which opens Form again and which starts parameters again? (1 Viewer)

KissBambi · Dec 13, 2019

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 Formular, last button on Form (Aktualisieren)

I would like to create a macro with this kind of button which can be bound to this button, in order to start a new search and to load parameters of form again.

Please no VBA, too difficult for me

vba_php · Dec 13, 2019

bambi,

copy your form, called it "form 2", put a new button on your current form, and behind the button click on "macro builder" and set the embedded macro arguments to what you see in the attached image.

this is just an example of how to use a macro to open a search form. this is not a complete solution. you are already using PARAMETERS in the query your form is getting data from, so to say that you want to SEARCH the records and filter them on the popup forum you want doesn't make any sense. the parameter popup that you already have occuring IS a search in it's own right. see attached zip and image.

KissBambi · Dec 16, 2019

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 records. But it loads the parameters of the form again, asking PK AnzeigeNummer after Beruf and displays no records....maybe shall I do a query different, where the contents of parameters Form is analysed again and compared with existing string in the field Beruf, this would be something like this :

WHERE [Anzeige.PublikationName] LIKE "*" & [Beruf] & "*".

This was the code to display the records which contain the data we want to search.

How can I say to Access to open the form again and to run a search again, with a display of the found data?

KissBambi · Dec 16, 2019

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!

vba_php · Dec 16, 2019

KissBambi said:
How can I say to Access to open the form again and to run a search again, with a display of the found data?

ok honey, upload what you have so far and I'll take a look.

KissBambi said:
maybe if I put in the WHERE Condition the criterias of search this will manage a new search!

I already told you, doing what you're doing makes no sense, but i'll try to accommodate you the best I can.

KissBambi · Dec 16, 2019

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!

KissBambi · Dec 16, 2019

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

vba_php · Dec 16, 2019

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

it doesn't matter bambi. that would make no sense just like doing what you're doing now makes no sense. stand by, I'm looking at your stuff now....

vba_php · Dec 16, 2019

you have not done what I showed you to do my dear. in your recent upload, you only have ONE form in there called "Anzeige Berufsuche Formular". my instructions say to create a NEW form and call it "Anzeige Berufsuche Formular 2". did you read those instructions correctly?

perhaps the better way to do this is for me to upload an example to you that would be a better way to get this done....? you wanna do that? (i'm jumping in the shower now I'm "out of the office" for 20 minutes)

KissBambi · Dec 16, 2019

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

KissBambi · Dec 16, 2019

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

This is worse

vba_php · Dec 16, 2019

KissBambi said:
https://drive.google.com/file/d/1vGjjdIMwKMOD0OjkK__7TXiDrFXVEm7f/view?usp=sharing

This is worse

upload your file to THIS thread bambi. google drive is being stupid and telling me i'm disallowing cookies.

KissBambi · Dec 16, 2019

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

KissBambi · Dec 16, 2019

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

Please try again

vba_php · Dec 16, 2019

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

no luck. your link is:

https: // doc-0o-ak-docs.googleusercontent.com/docs/securesc/qpiq72snq6nifn87ce7mfrje4gl5gio9/7g2ern9i8hmn4lhsfb9bieengk69gn4f/1576490400000/07093255509404441803/10682309453065254788/1o-LcY8OROo7OVDobW133ZA_fZ__aYpDT?e=download&nonce=3l5b2s2q7mmj8&user=10682309453065254788&authuser=0&hash=p0lb6ict400cdl5uuppe0etpokv0fbpn

if you have a personal google drive account, a shareable link should not even come close to that length. it should look like this:

https: // drive.google.com/open?id=1EAxIZysdsfu34njhVYVO0-GSwlY8jI_D

or like this:

https: // drive.google.com/share?id=1EAxIZysdsfu34njhVYVO0-GSwlY8jI_D

do you know how to ZIP a file and upload it? your file is NOT that big. try a compact and repair on it and see if it shrinks in size.

KissBambi · Dec 16, 2019

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

vba_php · Dec 16, 2019

i was able to get it via chrome. but i'm seeing that many other people here are reading this thread, so hopefully somebody else will get back to you and help out here if I can't. I'll take a look at your new file in a bit. I'm headed to a resturant.

KissBambi · Dec 16, 2019

Here with zip file

moke123 · Dec 16, 2019

KissBambi,

Many of us on the forums will not download from exterior sites. In order to get the most out of your time here you should post your databases here. If the file is too big you should strip out anything not needed to demonstrate the problem at hand, take out or change any confidential information, and zip the file before uploading.

I looked at the example that Adam posted and my first thought is to use a filter rather than duplicating any forms.

if you remove the parameters and criteria in your query you would simply need a button with the following code under it

Code:

Dim strFilter As String
strFilter = "Publikationname  Like  ""*" & InputBox("Beruf") & "*"""
Me.Filter = strFilter
Me.FilterOn = True

No need to duplicate forms. You should try and get over your aversion to code over macros. You will find that code is actually simpler and a lot more flexible.

vba_php · Dec 16, 2019

bambi,

moke's post might be too tough for you to follow, which I assume it is. so, in that case, look at this attachment. this is the FIRST step for you. look at the query "Anzeige Abfrage". you will notice that there is a "IS NOT NULL" statement in the WHERE clause. what this does is force a 0-record result set if a user tries to bypass the parameters by not putting anything in the popup box. tell me if this is something you want first, and then we'll do the next step regarding the 2nd filtered form you want.

How to create a button which opens Form again and which starts parameters again? (1 Viewer)

Registered User.

Forum Troll

Attachments

Registered User.

Registered User.

Forum Troll

Registered User.

Registered User.

Forum Troll

Forum Troll

Registered User.

Registered User.

Forum Troll

Registered User.

Registered User.

Forum Troll

Registered User.

Forum Troll

Registered User.

Attachments

AWF VIP

Forum Troll

Similar threads

Users who are viewing this thread