Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Problems clearing Me.Form.Filter

Posted on 2013-02-05
6
Medium Priority
?
437 Views
Last Modified: 2013-02-05
Hi

Using Access 2010

Here is the code.

    Me.Form.Filter = ""
    Me.FilterOn = True

I would expect the value of me.Form.Filter to be =  "".
I would expect for the filter would allow everything even though the filter is still on.

Instead, the value of Me.Form.Filter seems unaffected by this code.  The old filter condition remains.
0
Comment
Question by:peispud
  • 3
  • 3
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38857990
me.filteron=false  ' will show all records
0
 

Author Comment

by:peispud
ID: 38858012
Will that be enough though?

I am concerned that I am not controlling the value of me.Form.Filter

So if Me.Form.Filter = "" doesn't work,  will me.Form.Filter = "Someting here"   work every time?

is Me.Form.Filter = "" valid code?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38858045
<Will that be enough though?>
why don't you try and see for yourself..
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:peispud
ID: 38858069
I am concerned that I am not controlling the value of me.Form.Filter

This is really what I meant by "Will that be enough though?"

If I can't purge the form filter with              Me.Form.Filter = "",  then  something is up.  It's bad code or a bug or something.

If I don't understand  why Me.Form.Filter = "" doesn't work, then I cannot be 100 percent sure that any other value that I assign to me.Form.Filter will work under ever circumstance / every time.  

I believe that my question was valid.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 38858072
try

me.filter=""
me.filteron=true

or
me.filter=""
me.filteron=false

also, open your form in design view and delete whatever is in the filter property, save the form and try the code again
0
 

Author Closing Comment

by:peispud
ID: 38858096
Thank you.   I appreciate your help.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question