Problem with Search Button

[Mahendra1000]

Hello,

Am very inexperienced person in the field of ms access. I would like to have some help from one of you.

I have created a basic form with fields Name, Title, Location and Date. I have created a search button which returns the values that satisfies the search criteria.



For Ex : If I search for M in the name field then it should return all the names which contains the letter M. It worked well and am quiet happy with it.

1)The problem is that, the search results are opened in a new tab. If I again search for a letter A in the name field then it's not displaying the results until i closed the tab of 1st searched results. I would like to have the multiple search results in a multiple tabs.

My Search button is allowing me to only display the results one at a time only.

2) As the search results are displaying in the new tab, I would like to have the search results at the bootom of my current page instead of new tab.

Am awaiting for your answers.

Thanks!!

[TG_W]

Can you share your VBA code? You've explained the issue well, but the code will help provide a quicker answer. Thanks.

[friendlyfriend]

Hello,

Am very inexperienced person in the field of ms access.

Quick! Learn Ruby on Rails, or Spring or Django before it's too late (not really kidding, but...)

I would like to have the multiple search results in a multiple tabs.

I would like to have the search results at the bootom of my current page instead of new tab.

So, which do you want? tabs or no tabs?

[Mahendra1000]

Can you share your VBA code? You've explained the issue well, but the code will help provide a quicker answer. Thanks.

I haven't used VBA code. I just used the below query

Like "*" & [forms]![formname]![columnname] & "*"

I have created the search button and the above query from the following video

http://www.599cd.com/VideoPlayer/?FN...mv&W=645&H=430

Could you kindly have a look into this video and let me know how to proceed with my queries?

[June7]

You have to refresh the query. Either click the Refresh button on ribbon or run code.

Why open a query instead of a form or report bound to the query? Users should not interact with tables and queries.

[Mahendra1000]

You have to refresh the query. Either click the Refresh button on ribbon or run code.

Why open a query instead of a form or report bound to the query? Users should not interact with tables and queries.

Sorry. I didn't get you.

Could you kindly elaborate it please.

[June7]

Review:

http://datapigtechnologies.com/flash...tomfilter.html

http://datapigtechnologies.com/flash...mtoreport.html

http://datapigtechnologies.com/flash...earchform.html

[Mahendra1000]

Review:

http://datapigtechnologies.com/flash...tomfilter.html

http://datapigtechnologies.com/flash...mtoreport.html

http://datapigtechnologies.com/flash...earchform.html

Hello June7,

Thanks for those videos. I followed the same procedure from the 3rd video but still am getting only one search results. If I closed the tab of previous search results then only it's returning the new searched results.

[June7]

If you want to apply different criteria to already open query, form, report, then must Requery/Refresh. Have you tried setting focus on the open query and clicking the RefreshAll button on ribbon?

Again, why open a query instead of form or report? Programmatically re-filtering form or report is easier than a query. And users should not work with tables and queries.

[TG_W]

Try this database example. I based this on the two videos you indicated that you followed and added some light VBA.

[Mahendra1000]

Try this database example. I based this on the two videos you indicated that you followed and added some light VBA.

Thanks TG_W

The file which you attached is the one I was looking for.

Thanks for doing it to me.

It was awesome!!

I got my search button working it now. [I haven't added refresh in the macro which resulted in showing only one result at a time. Am Novice to Access]

[Mahendra1000]

The results returned by the search query having write permissions too. I don't want the front end users to modify the data returned by the search button.

Could you kindly let me know how to grant only read access permissions to the results returned by search button?

[TG_W]

To restrict from additions/deletions/edits, go to your Results form and change the parameter to "No" for each under the 'Data' tab in the 'Property Sheet'.

VBA is really the way to go in Access. Macros might not be bad when you are first learning, but VBA is quicker and cleaner to use. I cannot count the times when I wanted to do something in VBA and found it almost immediately just from searching this forum, especially when I first got started.

[Mahendra1000]

Got it

Thanks for your reply.......

[TG_W]

Make sure to click in the open space so nothing is selected. They are general settings to the form.