Subform Not Sorting
Sep 24, 2006
I have a form that lists contact information for people, and also has a subform that shows their participation in different events that my group puts on.
The subform, when viewed by itself, sorts the data based on one of the combo boxes just fine, since I have the subform based on a query that is sorted correctly.
But when I view the main form, which includes the subform on it, the data on the subform is not sorting at all.
Any idea why it would sort properly when viewed directly, but not when viewed as part of the main form?
View Replies
ADVERTISEMENT
Nov 18, 2005
I need to order a sub form (which is a continuous form) by a Date field in decending order (so that the latest date appears at the top).
When I open the subform on its own the sort works fine by just sorting using the OrderBy property but when it is opened as a subform it doesn’t sort in the same way.
help
View 1 Replies
View Related
Feb 8, 2006
Hi All... please read on and see if you can help
GOAL: To sort my subform data in descending order;
I have a subform off a large query... the query has other forms off it...
so on the subform I have used the Order By property...
qryDeliveries.EntDate DESC
:) sure enough when the subform is opened the continuous data is sorted in descending order by date....
:( BUT.. When I add this subform to my unbound main form it doesn't sort the subforms data? I didn't want to sort on the query because it runs other forms???
Please advise
Simon
View 2 Replies
View Related
Oct 29, 2006
I have subform which displays correctly off a table but is there a way besides making it off a query to filter just one criteria? Such as Y instead of N? Or do I have to go through it and use a query for the source? Which is the best?
The box im using is Y/N
View 2 Replies
View Related
Nov 23, 2006
Hi All hope some one can help with this.
I have a sub for which is set to sort by ascending order for a given field which happens to be a text field with vales set something like abc1.1,abc1.2 ect. The problem is, is that when you get to abc1.10, and more these are then sorted as so
abc1.1
abc1.10
abc1.11
abc1.2
abc1.3
ect
How can I stop this and sort it:
abc1.1
abc1.2
abc1.3
.......
abc1.10
abc1.11
Thanks for any help with this
Paul
View 2 Replies
View Related
Nov 6, 2006
Hi,
I have a query for a subform which is displayed in datasheet mode (see attachment). I've created a form based on a query and used it as a subform.
The "casenumbers" per clients are displayed from 1 and upwards, I would like to have them sorted Descending. So in the query I sorted them that way. When I run the query they are displayed in descending order. When I open the subform based on that query however it is not. I can sort descending anyway by clicking the column on which I want to sort and do it that way, but that becomes bothersome and it doesn't need to be that way.
Record source is ok:
SELECT KlantNAW.ClientNumber, CaseInfoTable.Casenumber, CaseInfoTable.DateInitialCall, CaseInfoTable.DateCaseCreation, CaseInfoTable.CaseAccepted, CaseInfoTable.[1stAppointmentDate], CaseInfoTable.DateCaseClosed, CaseInfoTable.About1 FROM KlantNAW INNER JOIN CaseInfoTable ON KlantNAW.ClientNumber=CaseInfoTable.ClientNumber;
Order by:
Casenumber DESC
I thought, well, lets create a new form based on the query to see if that changes anything, maybe I've changed something I shouldn't have.
But nope, same result.
How can make the form sort descending in datasheet mode?
View 1 Replies
View Related
Jan 7, 2015
How to sort entered records in a subform by combo box. Notice combo box has integer value not text. I want to bo sroted by text visibled ASC. The code must be in Command control SORT (See pict enclosed)
View 2 Replies
View Related
Feb 21, 2014
I have a subform which tracks all the notes our personnel have entered in a specific project (which is the main form).
The issue is that I want the most current note to show in the subform when the project is "opened up". The underlying query for the subform has the [DATE] field sorted on "Descending".
View 2 Replies
View Related
Feb 10, 2015
I'm trying to use the following code to programmatically sort four fields on the continous subform:
Code:
Me.SPlanChange_03_OFFSET.Form.OrderBy = "AOBJ ASC, ORG ASC, AVAILABLE DESC, AGFND ASC"
Me.SPlanChange_03_OFFSET.Form.OrderByOn = True
It appears that the code works partially - the values in the "AOBJ" field are as they be and so are the values in "AVAILABLE" field. The values in the "ORG" and "AGFND" fields will not sort.
Is what I'm trying to do even possible?
View 1 Replies
View Related
Mar 10, 2006
Hi all.
I've created a database which contains information about stores. I want to have the forms automaticly sorted by the department number.
I've tried to sort the table by department, but when I try to add a department, the sorting doesn't seem to affect the form at all.
Lets say I have department 1,2,3,6,7,8 in the form, and I add department 4, it will be the last post in the form. I want it to be the fourth, and so on..
I'd apreciate some help with this :) Thanks
Here's the database (http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=12934&stc=1&d=1142018915&PHPSESSID=f730b7f11f6983965698faeacbe5a1ee)
View 5 Replies
View Related
Jun 14, 2007
Hi Everyone,
Could anyone tell me how I sort a field so it sorts by the surname, not the first name? It's one field with 2 names seperated by a space, i.e. George Michael.
Many thanks for any help.
Essex
View 5 Replies
View Related
Jan 1, 2008
I am doing a database containing names, dates of birth, dates of death etc of my ancestors. Does anyone know the best way of displaying it so I can sort them out by age of death? For example, I want to see someone for example who died aged 70 years and 6 months to be a place above someone who died aged 70 years and 4 months.
View 1 Replies
View Related
Jun 26, 2007
In Quebec there are a lot of place names beginning with "Saint-" or "Sainte-".
When I do an ascending sort on the table itself, these type of names don't seem to follow the expected pattern.
For the names Sainte-Marthe, Sainte-Thérèse, Saint-Ephrem, Saint-Eulalie I should see this order:
Saint-Ephrem, Saint-Eulalie, Sainte-Marthe, Sainte-Thérèse.
Instead, I get Sainte-Marthe, Saint-Ephrem, Sainte-Thérèse, Saint-Eulalie.
The names are spelled exactly as I have them in the table with hyphens and diacritic marks.
Any ideas why there seems to be a problem sorting "Saint-" from "Sainte-?
View 8 Replies
View Related
Jan 10, 2007
Yet another question! When I run the report, it gives me the results in alphabetical order (i.e. April August, etc) instead of monthly order... Is there a way to fix this?
Thanks!
Michele
View 5 Replies
View Related
Jul 26, 2007
I have a field with addresses (numbers and letters) Whenever I try to sort it sorts by the number. How do I get it to only sort by the letters but still include the numbers in the result?
View 1 Replies
View Related
Oct 4, 2005
I have been trying to solve this Access problem for a couple of weeks. I have 2 Access 2002 files where I import info from a Paradox DB. I have been doing this for 12 years. I just bought a new laptop and transferred the programs over (I didn't reinstall because I don't have a floppy drive). Paradox files have a default of an International sort order.
One of my 2 Access files is now requiring an Ascii sort order. The Paradox forum says that something in the Access file is asking for the Ascii sort sequence. I have to keep bouncing back and forth in the Regedit changing the sort order from International to Ascii and back again to use the 2 files.
Do you know how I can make the 1 Access file ask for the International sort order?
View 4 Replies
View Related
Jan 11, 2006
I have a table with an alphanumeric field I want to sort on. If I sort the usual ascending way, data that is numeric is sorted before data that is alpha.
Is there a way to have the alpha data sorted ascending come out ahead of the numeric data srted ascending?
Ex:
Currently,
1
2
3
A
B
c
Desired:
A
B
C
1
2
3
Thanks in advance to all who reply!!!
View 3 Replies
View Related
Jan 25, 2006
i have a simple datsbase with 2 fields - drawing number and description.
the drawing numbers are in the formatt STD123 e.t.c.
When I try to sort numerically the order ends up as
STD1
STD10
STD11
STD100
STD101..........
How do I get it to list in true numeric order in report and table view i.e.
STD1
STD2
STD3.......... Please bear in mind that my knowledge of Access is VERY limited. I've tried a search and don't understand about queries and such like. Even so I'd have thought that even the most basic database programmes would be able to handle something as simple as an alpha/numeric sort list....seems not!!!!!
????????????????
View 8 Replies
View Related
Mar 30, 2006
I have a table with two columns
skill and category
i need to write some type of query or report that will group the skills into the numerical categories 1-9 and then in each of those groups listthe skills autamaticall and then have a way to print it out either in word or excel looking some thing like this
category 1
askill
bskill
cskill
category 2
askill
bskill
cskill
.....
any ideas?
View 1 Replies
View Related
Feb 28, 2007
How can I sort string addresses so as to get the correct number order? I know that strings sort on each character, which causes the problem. I have tried some things (with VAL and Len), but was not completely successful. I do not want to enter an address number as 0630, when I want 630.
Why does this not work:IIf(Len(Str(Val([address]))=3),"0" & [address],[address])? Address has 3 and 4 numbers only.
View 2 Replies
View Related
Aug 9, 2007
I have a job database where I sort jobs by upcoming, inactive, closed and active. Each has a corresponding number 1-4 respectively. The main table I update the jobs in is the JOB TABLE. I print a weekly report for our weekly meeting but I only want the active jobs in the report. My question is: how do I perform a sort function in the query, so I will have only the active jobs in the database table show in the query? Thanks in advance! If more info is needed I wil post additonal.
View 4 Replies
View Related
Jan 23, 2006
Hey everyone,
Is there any way that you can do a secondary sort on a field?
Any help would be of great!
Thanks - edawson
View 2 Replies
View Related
Sep 1, 2006
Hi The beginner here again.....
How do I set a table to sort by specific fields???
ie i have an ID field which is an autonumber, then 6 fields
I want the table to autosort first by a field called [rank], and then by a field called [name]
Thanks in advance
Egg
View 8 Replies
View Related
Jan 27, 2007
I have a table of plant names such as
×Mahoberberis
+Crataegomespilus
Iris
Scilla
Hebe
Geranium
Acorus
Note that the multiplication and plus signs are part of the names.
If I sort the table (A-Z) I get
+Crataegomespilus
×Mahoberberis
Acorus
Geranium
Hebe
Iris
Scilla
What I would like to see is
Acorus
+Crataegomespilus
Geranium
Hebe
Iris
×Mahoberberis
Scilla
I am not a programmer so need to be led by the hand, but can anyone see a way of achieving this which I could copy? My simple mind tells me that I have somehow to suppress the × and + during the sort. But how?
View 3 Replies
View Related
Mar 2, 2007
I had been using previous versions of Access, and just recently "upgraded" to 2007. I used the search function, and didn't see exactly what I was looking for, so hopefully I don't get flamed too bad if I missed an obvious thread, but here's my situation:
In the previous versions of Access that I used I would get a sort order like this:
R-256
R-276
R-500
R2325
R2598
now I get the following
R2325
R-256
R2598
R-276
R-500
This is a primary key in my table, so stripping the field it apart, sorting, and reassembling is not really an option. I jumped from Office97 to 2007 with this particular database, so I am not sure when the non-alphanumerics were ignored when it came to sorting, but is there a way to get the hypens to be recognized when it comes to sorting?
Thank you.
View 5 Replies
View Related
Jan 1, 2008
Hi,
I'm using DAO in C++ to write data in MS Access table. I found that MS Access will automatically sort those records in ascending order based on the primary key. I need to leave those records based on the write sequence, can I do that?
Thank you in advance:)
View 2 Replies
View Related
