Filter by form not working in Runtime

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I have a problem, where I have added a filter by from button to a custom menu toolbar for my form. When I open the database in Access 2000, and I go to my form and I hit the filter by form toolbar button, It does what I want(it clears all the text boxes and allows me to select what I want and the filter by that selection.) However if I run this database in a runtime environment the filter by form button doesn't do anything! Can someone please help me solve this problem - it quite urgent:( I can't understand why it doesn't work if I run it in a runtime environment - and I HAVE to run it in a runtime environment

Thanks for any help

Kevin
 
Sorry, Kevin: bad news. Filter By Form does not work in the runtime.

You will need to provide an alternative approach to filtering your forms.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Kevin said:
I have a problem, where I have added a filter by from button to a custom
Click to expand...
menu toolbar for my form. When I open the database in Access 2000, and I go
to my form and I hit the filter by form toolbar button, It does what I
want(it clears all the text boxes and allows me to select what I want and
the filter by that selection.) However if I run this database in a runtime
environment the filter by form button doesn't do anything! Can someone
please help me solve this problem - it quite urgent:( I can't understand why
it doesn't work if I run it in a runtime environment - and I HAVE to run it
in a runtime environment
 
Hi Allen

Thanks for that. :) Isn't that pretty stupid? I found an "alternative" on the microsoft website eventually, but their implementation of the filter by form is not as nice as the one avaliable in Access, what I mean is that when you use the one in access it gives you a combobox for every textbox on your form for you to make a selection, but this implementaion doesn't have that, you actually have to type the criteria in yourself(which could be quite errornous!) - got any other kind of alternatives for me?

Thanks for the help so far
Kevin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Add a Right Click Menu to A Form in Access 2007 in the RunTime Environmane 6
Filter parameters asked on first open, subsequent unfilter/re-filterdoesn't re-fill the parameters 2
Right-click filtering forms in runtime 3
Filter By Form Alternative for Runtime versions? 2
Please help: Can not "Filter" forms in Runtime, only in Full Acces 6
Problem with report passing filter 1
Filter by form in linked table database 2
Filter by Form not working 3

Back
Top