 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / February 2007Filtering a Datasheet
Hi, I am looking for simple ways for my users to further refine their search results in a datasheet using filters. So far I have a QBF (query by form) set up to refine the records by two fields, and then display the results in a datasheet. I then want my users to be able to further refine their search using the "filter by form" option. I have been informed that there is some way of making the "filter by form" option automatically appear when the datasheet opens, but I have no idea how to do this. Can anyone help? I assume that you are opening a form in datasheet view rather than simply opening a query. In which case put the following in the form's Open event procedure: RunCommand acCmdFilterByForm Ken Sheridan Stafford, England > Hi, > [quoted text clipped - 10 lines] > > Can anyone help? I have a form which is linked to a query via a macro. The results which display are the results of the query. > I assume that you are opening a form in datasheet view rather than simply > opening a query. In which case put the following in the form's Open event [quoted text clipped - 19 lines] > > > > Can anyone help? I'm not quite clear. Is the macro opening a form bound to the query or is it opening the query itself? Ken Sheridan Stafford, England > I have a form which is linked to a query via a macro. The results which > display are the results of the query. [quoted text clipped - 22 lines] > > > > > > Can anyone help? Hi, The macro opens the query in datasheet view. The macro is then linked to a command button on my form. Someone types in a query on the form page and hits the command button which runs the query and displays the results. As I am not very skilled at using Access I simply used the steps outlined by microsoft at http://support.microsoft.com/default.aspx?scid=kb;en-us;304428 It works well but I want my users to be able to further filter their search results without having to actually click the filter by form button in the datasheet view. Thank you Louise > I'm not quite clear. Is the macro opening a form bound to the query or is it > opening the query itself? [quoted text clipped - 28 lines] > > > > > > > > Can anyone help? In that case all you need to do is to add an extra action to the macro. For the Action select RunCommand and as the Command select FilterByForm. You should then find the query will open with the datasheet already in filter by form mode. Ken Sheridan Stafford, England > Hi, > [quoted text clipped - 44 lines] > > > > > > > > > > Can anyone help? You're my hero!! Thank you, thank you, thank you!! > In that case all you need to do is to add an extra action to the macro. For > the Action select RunCommand and as the Command select FilterByForm. You [quoted text clipped - 52 lines] > > > > > > > > > > > > Can anyone help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.