finding records faster with list box--how do i do it?

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

I have an Access database that is growing too large/too fast. I currently
move thru the form by scrolling the records one at a time, but it's too slow.


The table/form is a simple identity database: last name, first name, birth
date, etc. I need a list box/combo box (or whatever would be best) on the
form to show a list of the names that are in the database/table, then let the
user choose that name and go directly to the record. For example, I
currently start at the first letter of the last name of the person, "Adams",
and have to do a lot of clicking one-by-one to get to the records that start
with "Smith". There is no data entry connected to this, just to be able to
see the total record.

I am VERY new at this, so any directions should be simple, clear and
specific. I've read thru posts looking for something similar, but can find
final resolution.
.

Relevant Pages

  • Re: my code is too slow, how do I speed it up?
    ... // and then checked against the first letter. ... Rather than calling the database 36 times for ... // we call it once and store the info in a static array. ... Since you're going to be searching all the data in memory, ...
    (comp.lang.php)
  • RE: convert text to sentence case
    ... Which capitalises the first letter only, After that you need a macro so post ... "Jacqueline" wrote: ... scrubed and then appended to a table in another database. ...
    (microsoft.public.excel.misc)
  • RE: convert text to sentence case
    ... There is no sentence case in Excel, there's Upper, Lower and Proper. ... Which capitalises the first letter only, After that you need a macro so post ... scrubed and then appended to a table in another database. ...
    (microsoft.public.excel.misc)
  • How can I filter by macro in access 2007?
    ... I have an Access 2003 database which includes a feature to filter the records ... displayed on a form according to their first letter. ...
    (microsoft.public.access.macros)
  • Re: BDE
    ... Yeah it is database:), and it is not fy first letter in forum ... > BDE, as far as I remember, is not a provider - it is just another database ... >> Can anyone tell me from where I can download datprovider BDE for NET ...
    (microsoft.public.dotnet.framework)