PC Review


Reply
Thread Tools Rate Thread

Can My Book Collection be sorted alphabetically by TITLE?

 
 
=?Utf-8?B?anc=?=
Guest
Posts: n/a
 
      24th Jan 2006
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.


 
Reply With Quote
 
 
 
 
=?Utf-8?B?T2Zlcg==?=
Guest
Posts: n/a
 
      24th Jan 2006
Check this link about creating queries, and how to sort the data by a field

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

--
\\// Live Long and Prosper \\//
BS"D


"jw" wrote:

> 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.
>
>

 
Reply With Quote
 
Graham Mandeno
Guest
Posts: n/a
 
      24th Jan 2006
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

"jw" <(E-Mail Removed)> wrote in message
news:C9D5FA2C-06BF-4912-9D0F-(E-Mail Removed)...
>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.
>
>



 
Reply With Quote
 
=?Utf-8?B?anc=?=
Guest
Posts: n/a
 
      24th Jan 2006
Thank you, Mr. Mandeno! I GOT IT! and I apologize for failing to provide
complete information.

JacE

"Graham Mandeno" wrote:

> 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
>
> "jw" <(E-Mail Removed)> wrote in message
> news:C9D5FA2C-06BF-4912-9D0F-(E-Mail Removed)...
> >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.
> >
> >

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get my inbox messages to be sorted alphabetically Vanayssa Microsoft Outlook Discussion 3 3rd Jan 2009 12:19 PM
Form does not remain sorted alphabetically when re-opened =?Utf-8?B?Zmx5Z2FsNQ==?= Microsoft Access 3 19th Sep 2007 06:52 PM
An alphabetically sorted list of findings... JemyM Microsoft Excel Misc 4 19th Sep 2005 06:50 PM
Why aren't my files being sorted alphabetically? Mizukori Windows XP Basics 1 28th Feb 2004 04:50 AM
Creating a dynamic list sorted alphabetically Alex Barulho Microsoft Excel Worksheet Functions 5 24th Oct 2003 06:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:03 AM.