Sorting Of Query In Subform Doesn't Happen
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 Complete Forum Thread with Replies
Related Forum Messages:
Sorting A Subform
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 Replies !
Sorting In A Subform
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 Replies !
Subform Not Sorting
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 !
Subform Sorting?
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 Replies !
Subform Doesn't Complete
ello everyone. I have a major problem. I have an invoice system. Everything works fine except this. I have a form where i select from 2 lists the customerid and the invoicenumber. When i click on the invoiceno list i refresh the page in order for the subform that contains the details to complete. This doesn't happen. I try with linked master - child fields, itried with parameters, nothing. Is there a trick when using this? Why the subform does not complete? Please i need urgent help. I have attached the db. Please help me.
View Replies !
One Subform Shows Data, The Other Doesn't
If you take a look at the Maintenance Request form, you will my 2 subforms - quotes & Invoices. The invoices subform shows the data relating to the Maintenance Request when you open the form, but the quotes subform only shows the quote information after you have saved the record.I can't spot anything different about the 2 subforms.I can't get the size down no matter how much I delete, so you will find the database at ftp://greven.serveftp.com/Copy%20of%20Rentals%20Maintenance%20Database.zip
View Replies !
Sorting A Subform With Ascending Values
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 Replies !
SubForm Doesn't Display Until Record Present.
Only just started happening, with no explaination! Only one subform out of 5 shows as just background space until a choice is made from a combo box and then the thing appears with the record. WHY?!?!?! I HATE ACCESS... It's rubbish!! Apologies for my outburst...
View Replies !
Why Would This Happen?
why would this occur??? this is my query: strSQL = "INSERT INTO tblRunItems ( SiteId, RunID )SELECT tblSites.SiteId, " & Me.RunId & " FROM tblSites, tblRuns WHERE tblSites.CollectionZone = '" & Me.RunZone & "' AND tblSites.CollectionDay = '" & Me.RunDay & "'" This results in the same records being entered 4 times into tblRunItems Cant for the life of me figure out why
View Replies !
Form With Subform Doesn't Show Totals Unless Keyed
I have an application that has two tables, linked on a common key. The main data entry form is for invoices, and has a sub-form for parts used. A similar report/sub-report is used for reporting. Everything is fine for records that are entered via the form. My problem is that when I import data from other sources ( consolidation process ) the calculations are not performed. So when those records are displayed no totals appear until I click on a control that drives the calculations. I don't want to store totals in the database but I need to have them reflected on the viewed form without operator intervention. Otherwise I'm open to incorrect decisions when the operator doesn't notice that an invoice doesn't reflect the cost of parts used.I'm looking for a "one-time" process that I can invoke after loading new data that would "touch" each record (ideally each "new" record but there's no impact to re-calculating existing ones) and drive the calculations so that the viewed form is correct.It doesn't need to be "easy" or automated since the end users won't do it, only myself as part of the data consolidation.Any ideas?Thanks
View Replies !
Subform Doesn't Complete After Selecting Master Fields
Hello everyyone. i have an access db that creates invoices. Simple. The problem is that i have an edit form where i have two lists where the user selects customer and date and then based on that selection the subform with the invoice details should be autocompleted. That is not happening. What am i doing wrong? I have linked the subform with the lists and i have added some refresh page code but still nothing. What should i do? My db is attached. Look at the edit invoice (editsalesfrm). The code is in english so don't worry of the greek labels.
View Replies !
Subform In A Form Doesn Show Controls When Link Child And Master Fields Derfined
Hello, I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded. Is there a setting on the parent form that also has to be changed, to make the new binding? Thanks, Aleksander
View Replies !
Help With Sorting A Query?
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 Replies !
Sorting In A Query
I'd like to sort in my query - used to populate a combo box - first by name, and then by ID. Is there a way to force Access to sort in a particular order? It seems like it starts sorting with the first field that's to be sorted, but I want it to start with field 2 and then sort by field 1.
View Replies !
Sorting A Query
I am fairly new at relying heavily on Access for my programming. Problem: I have a telephone database with call detail for every call. I only want specific records, which I am pulling by selecting sort (in query design mode) for that particular field. I need to sort like you would in Excel (Column A first, Column B second, and etc). Can someone help direct me in the right path as to how I need to run a mulitple sort? Your help is much appreciated.
View Replies !
Sorting A Table, Apply The Sorting To A Form
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 Replies !
"Tab" Doesn't Scroll Right In Subform
Hi, My question is: I have a subform which is located in a Tab control within a main form. The subform is horizontal and exceeds the page width. When inserting data the Tab key doesn't result in auto scrolling of the page to the right (as opposed to using Tab in a regular form). This means that I have to use the horizontal scroll bar all the time. How can I fix this? Any suggestions would be appriciated
View Replies !
Delete Query...Doesn't!!!
I want to execute a delete query on a table of account records. The query contains two tables linked on account number, one with a list of unique records, linked to the other with "many" records to be deleted. For each unique record from table A, I want the delete query to delete all records with a matching account number in table B. However, I get a message stating that I "could not delete from the specified table." Huh??? I can manually delete from table B, or I can get the query to work if I don't try using table A as the control table and instead specify literal criteria. I have tried all three join types but still no luck. Any ideas? Many thanks in advance for any help provided- SLH
View Replies !
Query Doesn't Always Sort
Hello, I have an access query that I run on a regular basis but that doesn't always sort. It sorts most of the time, but once in a while it won't, which makes it really annoying and impractical. Does anybody know why this is happening? Thank you. The query is: SELECT P.GEOSORT, P.TERR_CODE_IND AS TERR_CODE, P.GEO_CODE, P.GEO_DESC, P.PRODUCT_SHORT_NAME, P.M23VA, P.M22VA, P.M21VA, P.M20VA, P.M19VA, P.M18VA, P.M17VA, P.M16VA, P.M15VA, P.M14VA, P.M13VA, P.M12VA, P.M11VA, P.M10VA, P.M9VA, P.M8VA, P.M7VA, P.M6VA, P.M5VA, P.M4VA, P.M3VA, P.M2VA, P.M1VA, P.CMTHVA, P.M23VC, P.M22VC, P.M21VC, P.M20VC, P.M19VC, P.M18VC, P.M17VC, P.M16VC, P.M15VC, P.M14VC, P.M13VC, P.M12VC, P.M11VC, P.M10VC, P.M9VC, P.M8VC, P.M7VC, P.M6VC, P.M5VC, P.M4VC, P.M3VC, P.M2VC, P.M1VC, P.CMTHVC, P.M23VSAA, P.M22VSAA, P.M21VSAA, P.M20VSAA, P.M19VSAA, P.M18VSAA, P.M17VSAA, P.M16VSAA, P.M15VSAA, P.M14VSAA, P.M13VSAA, P.M12VSAA, P.M11VSAA, P.M10VSAA, P.M9VSAA, P.M8VSAA, P.M7VSAA, P.M6VSAA, P.M5VSAA, P.M4VSAA, P.M3VSAA, P.M2VSAA, P.M1VSAA, P.CMTHVSAA, P.M23VSAC, P.M22VSAC, P.M21VSAC, P.M20VSAC, P.M19VSAC, P.M18VSAC, P.M17VSAC, P.M16VSAC, P.M15VSAC, P.M14VSAC, P.M13VSAC, P.M12VSAC, P.M11VSAC, P.M10VSAC, P.M9VSAC, P.M8VSAC, P.M7VSAC, P.M6VSAC, P.M5VSAC, P.M4VSAC, P.M3VSAC, P.M2VSAC, P.M1VSAC, P.CMTHVSAC INTO SORTED_P FROM P ORDER BY P.GEOSORT, P.TERR_CODE_IND, P.GEO_CODE, P.GEO_DESC, P.PRODUCT_LOGICAL_ORDER;
View Replies !
Sorting Further From A Duplicates Query
I have a Duplicates Query that extract the following information from my Table Name Surname DOB Joined The query then extracts info such as... Bill Smith 25:12:70 1999 Bill Smith 25:12:70 2005 Most of the time the 'Joined' field has the same year. But I need to find the ones where the year differs but the rest of the information is exactly the same. Because there is 15000 odd records to check, I thought that there would be a quicker way to check. Could someone please assist me with this query if it is possible? Thank you in advance.
View Replies !
Sorting Crosstab Query
I have a crosstab query where my column headings are the names of the months based on invoice dates. what i currently have: Month: MonthName(Month([AnnualIncome]![InvoiceDate])) so this spits out April May and June in the column headings. The problem is that it is sorting it alphabetically, not by the numerical value - so my column headings are coming out as april, june, then may. (I assume once I have july that will come in between april and june.) Any help would be REALLY appreciated. Thanks in advance.
View Replies !
Sorting Records In A Query
I am having a problem sorting records in a query. I have about 5, 000 entries in a table and when I build my query based on certain fields, the numbers in certain columns are not in order although I use the sorting feature. ( e.g.) I have 5 columns with numbering data contained in the columns, and I have it set up to sort in ascending order, which it did, but I noticed that the Volume # column sorts the Volume numbers differently (see example below): V. 1 V. 10 V. 11 V. 12 then it goes back to V. 2 V. 3 V. 4 V. 5 V. 6 V. 7 V. 8 V. 9 It looks like it sorts anything with a 1 first then the rest later. How do I fix this? Thanks.
View Replies !
Sorting Query Results
Hi I have a problem sorting some query data and I wonder if someone could help point me in the right direction. I have a query with two columns, in the first column is a number (either 6 or 7) and the second is the name of a business. Eg Column 1 Column 2 6 Pizzas & Co 6 Pizzas & Co 7 Pizzas & Co 6 IPM Ltd 7 IPM Ltd 6 Computer Sales Ltd 6 Computer Sales Ltd 6 Computer Sales Ltd 7 Computer Sales Ltd 7 Computer Sales Ltd 7 Computer Sales Ltd 7 Computer Sales Ltd 7 Computer Sales Ltd And I want to produce some another query so that the output which looks like: Column 1 Column 2 (6's) Column 3 (7's) Pizzas & Co 2 1 IPM Ltd 1 1 Computer Sales Ltd 3 5 So for each company name, I am essentially doing a frequency count for all the 6's and 7's. I think this must be relatively easy to do, but I am getting it wrapped around my head! Many Thanks, Lee
View Replies !
Sorting Query & PivotChart
Hey everybody, I know this question maybe be very lame but its been ages since i've touched on my sql knowledge. I've set out my database and i have 1 table which is holding the info i need to extract so that i may put it into my report. I wish to count the different values in a specific row: Example: Whats the problem Behavioural Physical Physical Behavioural I wana be able to count these seperately as in: SELECT COUNT(Client.[Whats the problem] LIKE 'Physical') AS Phy AND COUNT(Client.[Whats the problem] LIKE 'Behavioural') AS Beh FROM Client; Result: Phy Beh 2 2 I havent got a clue if i'm doing it right but i need to get it to work in access 07. Also one more question i have created a Pivotchart in a form but when a create a button on my main startup form and click into the Pivotchart form all i get is the Datasheet view, how can i get it to open up the Pivotchart through the form. Any info would be greatly appreciated Thank You.
View Replies !
|
TRACKER
