Search results

  1. K

    Filter in Access form

    Thank You vbaInet. Your reply was really useful. @ JANR: Thank you for the reply. In the before update event of the form i am "undoing" everything. This prevents any changes to be made. Hope this will prove to be enough.
  2. K

    Filter in Access form

    I have a combo box names "combo_1" in access bound Form. The combo box is bound to the field "Field_1" in the table "Table_1". Whenever I select a value from the combo box, I want the record set to be filtered by that value. I have tried the following code Private Sub Combo_1_AfterUpdate()...
  3. K

    Filter button on access form

    There are 8 combo boxes
  4. K

    Filter button on access form

    I did not understanding the control type. How do I check?
  5. K

    Filter button on access form

    Setting focus on the previous control works perfectly. Can you suggest any help for Access or VBA coding? I am fairly new in it.
  6. K

    Filter button on access form

    There are more than one fields in my form. So while writing the code I do not know the field where I have to set the focus to. So I plan to ask the user to choose the field using a list box.Using that value i plan to set focus. Name of the list box is "list_fields". So how do i write the...
  7. K

    Filter button on access form

    Just one thing... If I select the field where i have to set focus from a list box named "list_fields" , how do I use it in my code to set focus?
  8. K

    Filter button on access form

    It works by setting focus to a particular field. Thank you for the help. Have a nice day! :)
  9. K

    Filter button on access form

    Its a direct field from a table. And the filter button on the ribbon is working perfectly. However, the button on the form is not functioning.
  10. K

    Filter button on access form

    I had thought of the same thing. But that is not the case. The Filter button is ENABLED. Still I am getting this message.
  11. K

    Filter button on access form

    I tried to put that in the vb code. However, whenever I click on the button, I get the following message: Run-time error '2046': The command or action 'FilterMenu' isn't available now.
  12. K

    Filter button on access form

    I have tried that method. But it only gives the apply filter, filter by form and filter by selection options. In Access 2007 in the ribbon there is filter icon beside the advance filter menu. When you click on it, a filtering window opens in which you can put a tick across the records for that...
  13. K

    Filter button on access form

    Thanks for the reply. But I am afraid it does not answer my question. In Access 2007 there is an icon for filter in the ribbon.I just want to place that button for filter in my form.Can you help me with that?
  14. K

    Filter button on access form

    How do we put the filter button on an access form? I am talking about the simple filter button which when clicked pops up a menu for that field and asks the user to select the relevant data
Top Bottom