Quick Access question

[m4cc45]

Hi,

Basically I have a DB with quite a few records. Now currently I just scroll through them to the correct letter then in to the record. This is very time consuming if the letter is M for exampe.

Is there a way to put seperate buttons for A to Z down the side and then press A for the first record beginning with A, B for the first record beginning with B, etc? If so, how?

Thanks,


M.

 

[PMKeates]

Is scrolling absolutely essential? If you not, you can just filter to records beginning with M with either the Access interface, or create a form and add the buttons yourself using select queries.

In the above image you can see a group of three buttons to the right of the AZ ZA sort buttons. If you click the one in the middle, filter by form, it will give you a basic form with drop down boxes for each field. Select the field you want to "scroll" to M in, select M from the distinct list of values, and then click the third button along, apply filter. It will then show you only records with M.

EDIT: Actually that won't work for you. The easiest way would be to create a form and add your own buttons. I think later versions of Access have better filtering that allows begins with etc.

EDIT2: No! You can filter more specifically

In the above image you can see a filter box. You can get this by right-clicking on the field/record. If you enter M* in to this box, it will filter to all records beginning with M