Re: Address list - filter by alphabet tabs

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

From: Adrian Jansen (qqv_at_noqqwhere.com)
Date: 03/17/04 

Date: Thu, 18 Mar 2004 08:20:51 +1000

In addition to the other suggestions, just use the right-click menu. Put
the cursor in the field you want to filter on, right-click One of the items
is 'Filter'. Just manually enter A* in the dialog box to filter on all
items beginning with A. 

-- 
Regards,
Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
"Allan" <allan.spencer@myrealbox.com> wrote in message
news:uy60vvDDEHA.576@TK2MSFTNGP11.phx.gbl...
> I'm relatively new to Access so I apologise if this is a silly question
> .........  but .......
>
> I have an address table and I want to be able to filter them in a multi
tab
> form. i.e. click on tab "A" and see details of all records with surname
> beginning with A etc.
>
> I have a solution ... by defining 26 queries (qryA - qryZ)and subforms
> (sfrmA - sfrmZ) but I can't help feeling this is a very inefficient
method.
> I'm sure there must be a more elegant way of doing this.
> Thanks ... Allan
>
>

Relevant Pages

  • Re: Database Filter question
    ... > Allan Nielsen wrote: ... >> I use ADO to connect to an SQL Database. ... I use an ADODataSet to hold a ... >> will it automatically Execute its CommandText and then filter the new ...
    (borland.public.delphi.database.ado)
  • Re: Getting a subform to Show All records
    ... I don't think this is the root problem, ... I am unable to programmatically "unfilter" so that the subform displays all ... "If a form and its subform are both filtered and you remove the filter from ... RuralGuy aka Allan Bunch MS Access MVP - acXP WinXP Pro ...
    (microsoft.public.access.formscoding)
  • Re: Selstart and cursor position
    ... I am trying to prevent the cursor from appearing at the beginning of the ... fires the after_update code to filter the data in a continuos form. ... cursor at the beginning of it, rather than the next textbox. ... All the filter code works correctly (filtering data dependant on 3 text ...
    (microsoft.public.access.formscoding)
  • Re: Making a search box
    ... one is to set a filter on your ... Private Sub txtFilterLastName_AfterUpdate ... At the cursor, type these lines of code: ... Now, if you open the form and type some letters in the textbox, ...
    (microsoft.public.access.formscoding)
  • Re: Using vi
    ... The ``{'' character moves the cursor to the beginning of the paragraph. ... passes the output through the fmt command, ... then execute the script to filter that range. ...
    (comp.unix.sco.misc)