If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form - alphabetical
I am a new user to Access and have created a mailing list for our office.
However, as users type in new addresses, they are not alphabetical. I would like to put something at the bottom of the form so that I can click "A" and be to the A names when I am searching for a specific person - or have the form display the names alphabetical and not in chronological order of the ID#. Is this possible? And if so, how do I do it or can you direct me to the language I need to look up in the help menu. Thank you. |
#2
|
|||
|
|||
Form - alphabetical
There are several templates on the microsoft website that already do this.
No need to reinvent the wheel, just use one of those and modify it to meet your needs. I think the "contact management" one is good. If you don't want to do that, you can determine the sort order of the records in your forms. You should not be sorting by the order in which they are entered, you should be sorting by the name. Change the sort in your form's data source. -- Rick B "jlw" wrote in message ... I am a new user to Access and have created a mailing list for our office. However, as users type in new addresses, they are not alphabetical. I would like to put something at the bottom of the form so that I can click "A" and be to the A names when I am searching for a specific person - or have the form display the names alphabetical and not in chronological order of the ID#. Is this possible? And if so, how do I do it or can you direct me to the language I need to look up in the help menu. Thank you. |
#3
|
|||
|
|||
Form - alphabetical
Thanks - so simple. Is there a way to have basically the alphabet in the
form so that when I click on "D" it automatically goes to the D names? Would I need to build a macro? "Rick B" wrote: There are several templates on the microsoft website that already do this. No need to reinvent the wheel, just use one of those and modify it to meet your needs. I think the "contact management" one is good. If you don't want to do that, you can determine the sort order of the records in your forms. You should not be sorting by the order in which they are entered, you should be sorting by the name. Change the sort in your form's data source. -- Rick B "jlw" wrote in message ... I am a new user to Access and have created a mailing list for our office. However, as users type in new addresses, they are not alphabetical. I would like to put something at the bottom of the form so that I can click "A" and be to the A names when I am searching for a specific person - or have the form display the names alphabetical and not in chronological order of the ID#. Is this possible? And if so, how do I do it or can you direct me to the language I need to look up in the help menu. Thank you. |
#4
|
|||
|
|||
Form - alphabetical
I'm pretty sure the contact management database has that in one of the forms.
I know for a fact that the Northwinds database that comes with Access has this in the "Customer Phone List" form. it may also be in some of the other templates. -- Rick B "jlw" wrote in message ... Thanks - so simple. Is there a way to have basically the alphabet in the form so that when I click on "D" it automatically goes to the D names? Would I need to build a macro? "Rick B" wrote: There are several templates on the microsoft website that already do this. No need to reinvent the wheel, just use one of those and modify it to meet your needs. I think the "contact management" one is good. If you don't want to do that, you can determine the sort order of the records in your forms. You should not be sorting by the order in which they are entered, you should be sorting by the name. Change the sort in your form's data source. -- Rick B "jlw" wrote in message ... I am a new user to Access and have created a mailing list for our office. However, as users type in new addresses, they are not alphabetical. I would like to put something at the bottom of the form so that I can click "A" and be to the A names when I am searching for a specific person - or have the form display the names alphabetical and not in chronological order of the ID#. Is this possible? And if so, how do I do it or can you direct me to the language I need to look up in the help menu. Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Tell if Form is a Dialog | Alex | Using Forms | 7 | August 30th, 2005 06:22 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |