list view

[Guest]

Hi, how can I create a view of records on the form that shows all the records
and there is a alphabetical list on one side so that when I peress the letter
'a' it shows oor goes to records starting with 'a' just like in outlook
contacts. thanks

 

[Guest]

Couple of different ways to acheive this solution...Here are some ideas:

Use a form that displays the letters of the alphabet in some way (i.e. combo
box, list box or even command buttons if you want).

Use a subform that is based on a query to find all records that start with
the given letter...try using the Like operator. Using the combo or list box
is probably the easiest but this also could be done by creating a separate
command button for each letter if that is most appropriate for your users.

HTH

 

[Joan Wild]

Hi, how can I create a view of records on the form that shows all the
records and there is a alphabetical list on one side so that when I
peress the letter 'a' it shows oor goes to records starting with 'a'
just like in outlook contacts. thanks

This will give you one method
http://www.lebans.com/selectalpha.htm

 

[Hermie]

AJ20

Take a look at the northwind sample datebase in Customer Phone List

Herman

 

[Guest]

Hi, I was able to copy customer phone list table into my database and it
works fine, but I want to change the view to show the records outlook style,
like the records move horizontally and theere is no vertical scroll bar. do I
need to change the properties? thanks