Re: Search box to filter subform records, using LIKE criteria

Tech-Archive recommends: Fix windows errors by optimizing your registry



"Piet Linden" wrote:

On Sep 5, 6:15 pm, CSOUSA <CSO...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi!

I am trying to make a text-box search on a Main Form that will filter the
Subform Records (which are displayed from a PRODUCT/TECH ISSUES Query). They
would be filtered using Product Number. The full product number is about 9
characters, but it would be ideal for the user to be able to enter only the
first 3 characters (indicating the product family) or the first 7 characters
(for family + version) and find ALL query records relating to the entire
family, family +version, etc. This way they can see all TECH ISSUES for the
whole family or version, not just a specific revision.

For example, there may be a product ABC1234-XY-Z1 and a product
ABC1234-YZ-A2, but I want to see ALL query tech issues for products starting
in ABC or ABC1234 or ABC1*, etc. (Whichever the user decides to enter.)

I am generally skilled in access but only mildy familiar with VB. What
would be the best way to do this?

Thanks and all the best...

SELECT ...
FROM MyTable
WHERE MyField LIKE [Enter A string:] & "*"


Thanks, how genius, of course it worked!

And much easier than linking it to a text box on a form, while yielding the
same results. Now I have a macro to filter by this query OnOpen and it
brings up the prompt just fine.

: )


.

Relevant Pages

  • Re: Search box to filter subform records, using LIKE criteria
    ... I am trying to make a text-box search on a Main Form that will filter the ... Subform Records (which are displayed from a PRODUCT/TECH ISSUES Query). ... first 3 characters or the first 7 characters ...
    (microsoft.public.access.forms)
  • Search box to filter subform records, using LIKE criteria
    ... I am trying to make a text-box search on a Main Form that will filter the ... Subform Records (which are displayed from a PRODUCT/TECH ISSUES Query). ... but I want to see ALL query tech issues for products starting ...
    (microsoft.public.access.forms)
  • Re: Need Help with Criteria Expression
    ... query that will do this and save this query. ... trying to filter text using a date. ... setting a validation rule that's commensurate with the way data would ... characters in the data. ...
    (microsoft.public.access.queries)
  • Re: .NET DataTable.Select Limitation
    ... That wouldn't work, since Select returns an array of rows, not a datatable. ... > some criteria and then filter it again from there? ... A query with more than ... > 10,000 characters should have a way to do this. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: .NET DataTable.Select Limitation
    ... some criteria and then filter it again from there? ... A query with more than ... 10,000 characters should have a way to do this. ...
    (microsoft.public.dotnet.framework.adonet)