Can My Book Collection be sorted alphabetically by TITLE?

[Guest]

I see options in Access to sort My Book Collection by subject matter or
author, but how can I sort the database BY TITLE??

Thank you in advance for any help you have to offer.

 

[Guest]

Check this link about creating queries, and how to sort the data by a field

http://support.microsoft.com/kb/304361/EN-US/

 

[Graham Mandeno]

I'm assuming you have a database that has been built from some kind of
sample or template. You really need to give more information, but here's a
guess that might get you going.

Say you have an option group on your form, named "opgSortBy". It had two
buttons: "Subject" (value 1) and "Author" (value 2). You need to add a
third button, "Title" (value 3).

Then find the code associated with changing the value of the option group -
it's probably in the AfterUpdate event procedure.

Maybe it looks something like this:

Private Sub opgSortBy_AfterUpdate()
Select Case opgSortBy
Case 1: Me.OrderBy = "Subject"
Case 2: Me.OrderBy = "Author"
End Select
Me.OrderByOn = True
End Sub

You need to add a third "Case" line:
Case 3: Me.OrderBy = "Title"

 

[Guest]

Thank you, Mr. Mandeno! I GOT IT! and I apologize for failing to provide
complete information.

JacE

I'm assuming you have a database that has been built from some kind of
sample or template. You really need to give more information, but here's a
guess that might get you going.

Say you have an option group on your form, named "opgSortBy". It had two
buttons: "Subject" (value 1) and "Author" (value 2). You need to add a
third button, "Title" (value 3).

Then find the code associated with changing the value of the option group -
it's probably in the AfterUpdate event procedure.

Maybe it looks something like this:

Private Sub opgSortBy_AfterUpdate()
Select Case opgSortBy
Case 1: Me.OrderBy = "Subject"
Case 2: Me.OrderBy = "Author"
End Select
Me.OrderByOn = True
End Sub

You need to add a third "Case" line:
Case 3: Me.OrderBy = "Title"
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I see options in Access to sort My Book Collection by subject matter or
author, but how can I sort the database BY TITLE??

Thank you in advance for any help you have to offer.