How do I organize my database of contacts alphabetically ?

[Guest]

Hi all
How can I get my database to organize my contacts into alphabetical
order using a field I have named "company name" ?

 

[Douglas J. Steele]

Tables don't have an order: they're "sacks of data", where each row fits
wherever the DBMS thinks is the best place to put it.

If the order of the records is important to you, create a query with the
appropriate ORDER BY clause, and use the query wherever you would otherwise
have used the table.

 

[Guest]

How do I get my database to show names alaphabetical order in form view ....I
got the query to sort them into alphabetical order in the query view but not
in form view

 

[Douglas J. Steele]

Use the query as the RecordSource for your form.

 

[Guest]

I dont understand what you mean by RecordSource ...I am just starting out
with access and I am a little bit of a Novice to it ?

 

[Douglas J. Steele]

Assuming the form already exists, open it in Design mode, and look at the
Properties for the form (View | Properties from the menu bar). Assuming
you've looking at the properties of the form itself (as opposed to a control
or section on the form), look at the Data tab. One of the properties is
"Record Source": set that to the name of the query you created.

If you're creating a new form, when you click on the New Form button, the
dialog that appears let you select the Record Source (there's a combo box
containing all of the tables and Select queries in the database)

 

[Guest]

The data tab is completely blank!

Assuming the form already exists, open it in Design mode, and look at the
Properties for the form (View | Properties from the menu bar). Assuming
you've looking at the properties of the form itself (as opposed to a control
or section on the form), look at the Data tab. One of the properties is
"Record Source": set that to the name of the query you created.

If you're creating a new form, when you click on the New Form button, the
dialog that appears let you select the Record Source (there's a combo box
containing all of the tables and Select queries in the database)

 

[Douglas J. Steele]

I've never heard of that!

You might try recreating the form.

 

[BruceM]

Are you sure you're looking at the form's properties? The listing will have
Form in the title bar at the top if it is the form's properties, otherwise
it will have something else in the title bar.