Re: Improper coding for my Form Filter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: shhsecurity (shhsecurity_at_discussions.microsoft.com)
Date: 03/18/05 

Date: Fri, 18 Mar 2005 02:11:01 -0800

Thank you! You were absolutely right. The tags were all mispelled. The
frmFilter works wonderfully now. As long as I create tables with text fields
for my numerical entries I have absolutely no problems. This little filter
for the 5000+ records I have stored works faster and looks more business like
than going thru a query and I appreciate all of your time you spent on
helping me. Thank you again Marshall.

"Marshall Barton" wrote:

> shhsecurity wrote:
> >I changed the 6 back to a 5 and now the form filter works... but doesn't
> >work. What I mean is, when I select or enter a query into any one of the
> >combo boxes then click on Set Filter a small window pops up and asks me to:
> >Enter Parameter Value. I enter the same query I clicked or typed in again
> >and It will not filter. I still get all records showing.
> >
> >The original code once again is here. http://support.microsoft.com/kb/q208529
> >Maybe the code is just bad to begin with?
>
>
> The code in the article is fine, as far as it goes. As I
> said before, it makes no attempt to deal with filtering
> numeric or date field types. At this time, do not attempt
> to use a filter for anything other than a Text type field.
> If you did, it should generate a type mismatch error.
>
> I would not try to provide users with this kind of after the
> fact filtering feature so I have no personal experience with
> this specific technique, but that code is straightforward
> enough.
>
> If you're being prompted for something, it means that the
> name you're being promted for is not a field in the
> table/query or it's an unquoted string. Check the prompt
> string in the pop up and try to figure out where it's coming
> from. Often, it means that you spelled a field name
> incorrectly (in each combo box's Tag property).
>
> --
> Marsh
> MVP [MS Access]
>

Relevant Pages

  • Re: Improper coding for my Form Filter
    ... This little filter ... when I select or enter a query into any one of the ... >> table/query or it's an unquoted string. ... >> incorrectly (in each combo box's Tag property). ...
    (microsoft.public.access.formscoding)
  • Information manager/organizer with tags question.
    ... stores records by tags and allows filtering and sorting by these tags. ... Interface would have a filter by: pull down menu separated in two ... posts, tag, my name. ... app that does this. ...
    (comp.lang.python)
  • RE: How to turn off WS-addressing and SW-Security
    ... These will basically remove the Security filter and thus not add in any WSSE ... This should be the way to remove the WS-Addressing also, ... when I send the Soap message to a Unix server running AXIS ... It is complainig that it does not like the tags ...
    (microsoft.public.dotnet.framework.webservices.enhancements)
  • Re: how to quickly get up to speed on wonderware line
    ... Excel inputs along with some field inputs, already in WWW, to perform ... that tags the input. ... I don't remember having any trouble finding how ... You can filter within the HMI but the alarms do not see this ...
    (sci.engr.control)
  • Re: Improper coding for my Form Filter
    ... when I select or enter a query into any one of the ... >and It will not filter. ... table/query or it's an unquoted string. ... Check the prompt ...
    (microsoft.public.access.formscoding)