How can I fix this? Have you tried ?Screen.ActiveForm.OrderBy in the immediate window? Is there anything comparable to Order by On Load in 2003? What I'd do is open the form in design mode, open up the property sheet for the form, and then click on the datatab. http://amptools.net/ms-access/ms-access-nz-not-working.html
HTH, TC Nov 12 '05 #7 This discussion thread is closed Start new discussion Replies have been disabled for this discussion. Create a custom SXA rendering with variants Can spacecraft defend against antimatter weapons? Very good to know, and is the answer to my unexplained resolution above! I have amended the post with a new query. try here
Thanks! And apparently the "solution" to Microsoft's persistent sort is to remember to put that me.OrderBy = "" code in the OnOpen event of every form where the sort slows things down. For example if you have Grouping & Sorting definitions applied, those Sorting options are king, so for your sorting, you would enter and expression that is a function call, and that
blnOpening = False End Sub RE: Access 2007 to 2010 OrderBy in VBA Not Working dhookom (Programmer) 17 Jan 13 11:32 I'm not sure this will help but these are my Being able to disable that "service" (seems like more and more Microsoft insists on helping when we don't need or want the help) would be a much more efficient solution. I had set up a Me.OrderBy = "" in the both the form's OnClose and OnLoad events, but the form continued to open in the form's previously opened, user-selected order! I ask, because the above should work. –Fionnuala Oct 12 '11 at 13:28 @Remou seems to be working now.
It will have your table there, else add it. I recently converted it to 2007.There is a report generation form that constructs a SQL string that is used to build a number of reports. Hotels on the Las Vegas strip: is there a commitment to gamble? http://www.access-programmers.co.uk/forums/showthread.php?t=235292 For instance: CODE --> vba'Me.OrderBy = "TotalTrans.AbsAmt DESC, TotalTrans.DATE" Me.OrderBy = "AbsAmt DESC, [DATE]" Duane Hook'D on Access MS Access MVP RE: Access 2007 to 2010 OrderBy in VBA Not Working
Chalk it up to another instance of "Thanks, but no thank, Microsoft." P. It would only revert to the default (no Order By) if I opened the form in Design View (the OrderBy property was then empty) and then into Form View. Join them; it only takes a minute: Sign up MS Access Query - Ignoring 'Order By' Clause up vote 0 down vote favorite SELECT u.UserLastName, u.UserID, SUM((Format(c.CallLength, 'h') * 60 *60)) P.
Emigh Nov 12 '05 #1 Post Reply Share this Question 6 Replies P: n/a MGFoster -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The OrderBy property "sticks" only when the form was opened http://www.utteraccess.com/forum/meorderby-working-2007-t1987452.html Similar topics Establishing Precedence In ORDERBY Condition Causing Problems. That can slow things down considerably, especially when the last user has chosen a non-indexed field. Come join the group here through a proper newsreader.
The only change that seems relevant is the Registry has dropped VBA 6.0 and now includes only VBA 7.0. his comment is here Still looking for solutions, P. So, you'd selected it twice in your #1 SELECT statement. If you can't replicate this behavior, then there's apparently some setting that differs, and that's what I'm looking for.
Click Here to join Tek-Tips and talk with other members! Thank you. I know setting an OrderBy on a form is very simple, but it is not working for me, and I am not sure what I am doing wrong here. this contact form Maybe I'm biased because I learned Access's GUI table construction 5 years before I learned proper SQL, but clicking the "..." to edit you source often finds/fixes/flags this stuff automatically.
is simply not true in my situation. I learned the 'OrderByOn' property is > not listed in the form design and apparently must be modified with code. > So in the Load event I tried: > Me.OrderByOn = The field I have is called id_number, field type is numeric, indexed, the form is reading from a table.
Clean up nonsense such as a non-indexed autonumber field. Why the switch from "ihr" to "Sie" in the following speech from Band of Brothers? does the table sort properly when the ControlNo field is selected and you click on each one of the Sort buttons? Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free.
Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Me.RecordSource = "SELECT Stuff FROM [BPRIL Data Entry] ORDER BY [Item #]" You should consider doing yourself a favour and getting rid of spaces in table names and field names, it I've just tested a form in Access XP and found that the OrderBy property does stick w/o any logical reasons. navigate here Not the answer you're looking for?
Generated Mon, 14 Nov 2016 12:59:25 GMT by s_mf18 (squid/3.5.20) HomeForumsWikiLinks HelpGuidelinesActive TopicsSearch Search this forum only?More Search Options [X]My Assistant Loading. That was it. Thoughts? + Reply to Thread « Previous Thread | Next Thread » Contact Us DBASpot Privacy Statement Top So, your suggestion here may be what 2010 version needs in order to sort.
The sorting runs perfectly when I use Access 2007 to open the file, but no sorting when use Access 2010 version. I just verified this by setting up a little test database in Access 2000. SELECT u.UserLastName, u.UserID, SUM((Format(c.CallLength, 'h') * 60 *60)) as hourSeconds, SUM((Format(c.CallLength, 'n') * 60)) as minSeconds, SUM((Format(c.CallLength, 's'))) as seconds, COUNT(*) as callCount FROM Calls AS c INNER JOIN User AS Thanks for sharing your knowledge. –user706965 Apr 15 '11 at 0:07 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign
Using orderby with multiple fields Using OrderBy to dynamically change sort order in reports Orderby set by code causes stupid access 2000 behaviour Using the OrderBy property on an unbound ComboBox What gives? Even if I put in a valid ControlNo value is will still ask for another value and the textbox (with ControlNo) displayed remains on the screen with nothing else. Being able to disable that "service" (seems like more and more Microsoft insists on helping when we don't need or want the help) would be a much more efficient solution.
Why the switch from "ihr" to "Sie" in the following speech from Band of Brothers? VilaRestal View Public Profile Find More Posts by VilaRestal
I always base the report on a saved query. VendorName is specified in the form's Order By Property.