Driving Me Nuts!!!

Article View: comp.databases.ms-access

Article #535

Back to comp.databases.ms-access Previous Next

#535

From: James
Date: Tue, 08 May 2001 19:27

20 lines
2651 bytes

Access reports do their own sorting based on the sort fields you specify in
the Sorting and Grouping dialog of a report.  The recordsource Order By
clause is then ignored.

My problem is the following:

In the application I am creating, I allow the user to choose which fields to
sort by...  I then use the following code in the Report_Open procedure...

Me.GroupLevel(0).ControlSource = field
Me.GroupLevel(1).ControlSource = field
Me.GroupLevel(2).ControlSource = field

This code changes the Sorting and Grouping order for the report, but
unfortunately it 'Groups By' instead of 'Orders By'.  I did a little
research and found that this only happens when dealing with reports.  (Not
queries, etc.) - Found this information in the VBA help.

Does anyone have any suggestions on how I can dynamically specify an "Order
By" clause to the Report when it opens?

Technical Details

Message-ID: <9KXJ6.235669$Z2.2529860@nnrp1.uunet.ca>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!news.gv.tsc.tdk.com!newsfeed.berkeley.edu!ucberkeley!newsfeed.direct.ca!look.ca!news.uunet.ca!nnrp1.uunet.ca.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb7cd,211f97db499caa4f,start
X-Google-Attributes: gidfb7cd,public
X-Google-Thread: 113291,211f97db499caa4f,start
X-Google-Attributes: gid113291,public
X-Google-Thread: ff0ac,211f97db499caa4f,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10c7bc,211f97db499caa4f,start
X-Google-Attributes: gid10c7bc,public
X-Google-Thread: 114549,211f97db499caa4f,start
X-Google-Attributes: gid114549,public
X-Google-Thread: 10f31b,211f97db499caa4f,start
X-Google-Attributes: gid10f31b,public
X-Google-Thread: 11315a,211f97db499caa4f,start
X-Google-Attributes: gid11315a,public
X-Google-Thread: 1143dd,211f97db499caa4f,start
X-Google-Attributes: gid1143dd,public
X-Google-ArrivalTime: 2001-05-08 12:29:14 PST
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!news.gv.tsc.tdk.com!newsfeed.berkeley.edu!ucberkeley!newsfeed.direct.ca!look.ca!news.uunet.ca!nnrp1.uunet.ca.POSTED!not-for-mail
From: "James" <jamesmealin@asaglobalserv.com>
Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.activexcontrol,microsoft.public.access.chat,microsoft.public.access.commandbarsui,microsoft.public.access.conversion,microsoft.public.access.customcontrols,microsoft.public.acces
Subject: Driving Me Nuts!!!
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <9KXJ6.235669$Z2.2529860@nnrp1.uunet.ca>
Date: Tue, 8 May 2001 15:27:12 -0400
NNTP-Posting-Host: 216.94.12.130
X-Trace: nnrp1.uunet.ca 989349893 216.94.12.130 (Tue, 08 May 2001 15:24:53 EDT)
NNTP-Posting-Date: Tue, 08 May 2001 15:24:53 EDT
Organization: UUNET Canada News Reader Service