Search results

  1. A

    Filtering via a query on a form

    Hello Wiklendt I will try this but I have no skills for coding access in vb. I found following code on this forum. Will it do the job? Me.Filter = "[Item] Like '*'&[Forms]![frmMasterBidItems]![txtKeyword]&'*'" Me.FilterOn = True Kind regards Al
  2. A

    Filtering via a query on a form

    Hi Wiklendt The filter works as expected. But the problem that I have is that I have to put a 'requery' in my macro and because that my query ask for input via a message box it shows twice at first use. Once for the 'query' and once for the 'requery'. For me it is not so a problem but for...
  3. A

    Filtering via a query on a form

    Hi Bird_FAT Sorry but I didn't use code for this. My filtering is done by a query and a simple access macro. Applyfilter with the query name. Kind regards Al
  4. A

    Filtering via a query on a form

    hello Wiklendt My goal is to use the macro button so that I can quick filter my data. As already mentioned this macro works fine in 2003. I think it is possible to resolve this issuie in 2007 but I can't find a solution. Thanks anyway for your reply Kind regards Al
  5. A

    Filtering via a query on a form

    Hello On my access 2007 form I have a button for filtering my data (macro > applyfilter > query for filtering) Each time I push this button the filter is copied in the property sheet for the form in the filter section. The ‘filter on load’ and the ‘allow filter’ property is set to No. How can I...
Back
Top Bottom