SearchBox and Datasheet View

[gio25]

Hi everyone

I have 2 questions

Anyone has used the students template in access 2007/2010??

If someone has used, how is that the search box works?


I trying to adapt this search box to my database and I can't make it work is there a better alternative?

Also my form displays in datasheet view, if I filtered the data, how can I make a query out the displayed data only??

[thhui]

Could you post the students database saved as 2000 mdb format for testing?

[161]

I do not have that search box, but from the description I would bet it is a QBF. I made one in my database, and its pretty simple to me now anyway. I had to figure this out myself, and if you asked me a few weeks ago, my face looked like this. But I owe a lot to everyone on here that helped me, so I'm returning the favor!

You can look up examples of "Query By Form". Or follow these simple steps to make one.

First, create a command button on your form. A window will pop up, but just X it out, we're flying manually today. Right click and go to properties, event, on click and hit the (...) to build your code. Some of the code is already written in for you. After the Private Sub line, you need:

stDocName = "your query name"
DoCmd.OpenQuery stDocName, acNormal

(if you want your search results to be uneditable, put ", acReadOnly" after acNormal)

Second step is to make your form fields. Very simple, create a text box with the right field unbound. Example: Give it a name.... "SearchField1", but leave the other fields blank, so it is not connected to a table.

Finally, you create your query. Go into the design view and select the field you want to be searching for and the table that its found in. Under Criteria, enter this:

Like [Forms]!(your form name)!(SearchField1)

Or, if you want to include a wildcard (will return a field "Pink" if you do a search for "Pin"

Like "*" & [Forms]!(your form name)!(SearchField1) & "*"

You are also free to fill up your other query fields at your hearts desire, so you will get more than one column of useful information in your search result. You may put a similar thing in the criteria for those fields as well, and it will narrow down your results to the fields in common. Example field 2 search is "Panther". You will return only the strings that are both "pink" AND "panther".

[chasemhi]

Like "*" & [Forms]!(your form name)!(SearchField1) & "*"

You could also allow your user to enter the wildcards. For example, they enter pin* and they would get pink.

Nice mini tutorial BTW. Thanks.

Chase