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 Complete Forum Thread with Replies
Related Forum Messages:
Sorting A Table....
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 Replies !
Table Without Sorting
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 Replies !
Filtering/Sorting A Table
Hello, I have a project table that I track the progress of each job in by entering dates when certain portions are done. What I would like to do is when I fill in the "Project Completed" or "Cancelled" columns, to have that record automatically filtered out of the table. I still want to be able to turn off the filter at the end of the year to see all the projects we did, but I don't want this project cluttering up my table once it is finished or cancelled. Right now, I copy and move these completed projects to a separate table, but others say this is confusing and they can't figure out which table to use. I input everything in the table format and don't have any forms that I use. Thanks for any help. Matt
View Replies !
Sorting A Form
I have a tabular form, and of the fields contains a Priority Level for that record (High, Medium, Low). How can i manage to sort the records in this form by the Priority Field in order High, Medium, Low, because if i try Ascending i get them High, Low, Medium, and descending i get them Medium, Low, High. Any suggestions pls whether it is possible to sort them in High, Medium, Low ? Thank You
View Replies !
Sorting My Form??
Hey all I have a problem I would like to populate my forms with the data from another form, and I know one way of how to do this however, I would like to be able to sort my form data. Since I have filtered my data I only see user 3's reccords not all users on the one form, I would like to have the ability to sort the form by the most current date. Since I already have more forms done, i would like to keep it that way. The fields I have on my form are: PIN, PERMIT NUM, DATE, PHONE, PHONEWORK, OWNER, AGENT, CONTRACTOR, DECSCRIPTION, WIDTH, LENGTH, CLASS, DATE ISS, PENDING, HEIGHT, COST, NOTES. . . IN that order! So what I would like to do is put them in order by the date recored ie DATE. so that the most recent date shows up not Actually now just looking at it i think it is sorted by PERMIT NUM, so is there a way to sort by two different things? as well or what? Thanks in advance
View Replies !
Sorting A Resulting Table Of ComboBox
hello, I have a combo box that looks at a table with an SQL statement. In the form, the combo box shows the headers of the resulting table. Is there any way that the user can click on any header (let's say 'LastName' or 'Date' ) so the drop down list would be sorted by that header that the user clicks on?? Thank you very much
View Replies !
Text & Number Sorting In A Table
I have a table where my primary Key is of a text type, the key is made up of a single letter then a number... ie. R1 R2 R3 ... R30 R31 ..R100 etc. This is an indefinate table and will go as high as I need to Unfortunately I can't sort this table because if its mixture of both text and numerical characters, can anyone provide any assistance? Thanks!
View Replies !
Calculating Between Fields In A Table And The Sorting
Below is an example of my table "Pricedata" include 03 fields: Stock Name ___Price________Status Date A________________10________ __1/6/2008_ A________________11___________1/7/2008_ A________________12___________1/8/2008__ B________________22___________1/6/2008_ B________________25___________1/7/2008_ B________________29___________1/8/2008__ C________________2____________1/6/2008_ C________________2____________1/7/2008__ C________________3____________1/8/2008_ D________________56___________1/6/2008_ D________________45___________1/7/2008_ D________________27___________1/8/2008__ I want to create a query like this: can calcualte the price change and % price change in certain period, and then sort in % change. This result should be like the table below: StockName Change in three days % Change in 03 days C 1 50% B 7 31.8% A 2 20% D -29 -51.78% Thanks all,
View Replies !
Sorting On Open (form)
I have a form, which is based on a table. Usually I have forms open to new or last records, but in this case I need it to open sorted by reportnumber. I read up on the orderby property, which I tried on open without any luck. Any ideas, other than basing by forms on queries....
View Replies !
Sorting A Datasheet In A Form
Hi I have a datasheet subform on an unbound form. but the data on the subform will not sort in ascending order. I have used the ORDER BY in the table and form but it still will not do it?? Thanks
View Replies !
Sorting A Secondary Form
Hello I have a form that is bound to a table called "date". Date has to fields "date_id" which is a numeric value and "date_description" which is the name of the month. A secondary form is bound to a table called "Employees" which has fields regarding data about the emploees of a company (eg "surname", name" etc). I use these 2 formes together to select the month of year and show/edit the data of the employees. Everything work perfectly except one last thing. Is it possible that after I edit (or add) a record in the secondary form (table "employees") the secondaty form to be sorted by "surname"? How can I do such a thing? I would be grateful if you give me an example. Thank you in advance
View Replies !
Closing Form Slow After Sorting
Closing a form with a large amount of records is slow after sorting the records, is there a way to avoid this. Its slower to close after sorting than the the sum of the time to close the form and sort the records, which doesn't seem to make much sense. Can anyone help? Ta - Paul
View Replies !
Sorting Form Like Reports Wizard
I want to make an unbound form that has the functionality like the form found in access for reports wizard. I want the user to be able to select the sort order dynamically for a report instead of a fixed sort order. But i'am unable to sort out my own problem :mad: plz check out the functionality of this form by opening in your access. When the first combo is empty all the other combo boxes are disabled. Entering something in the top combo enables the combo below it. If we delete something in the top combo when something is already existing in the combo beolw it, the values of the bottom combo boxes are shifted to the upeer combos and the lower combos are disabled. i have also attached the picture for refference.
View Replies !
Ordering/Sorting Data In Form
Hi all, I have a simple 2-table database. the 'parent' table is tblProducts, and the 'child' table is tblDocuments. (one [products] to many [docouments] relationship) My data entry is done using a 'documents' subform inside a 'products' parent form. The data entry works fine, except i would really like it if my products and documents would be listed in alphabetical order in their respective form/subform {makes it easier on the user, and saves me needing a find record button}. At the moment they seem to be ordered by the time in which they were added to the table. I guess Access is using the primary Key as the 'order by' parameter. The thing that is infuriating me is that i have gone into my two tables and told access to sort the data by Product Name, and Document name in the respective tables. I can verify that this has worked by going to data view; lo and behold the data are listed in the order i specified. Further I have gone into my form and sub form properties, into the Data...Order By property and have keyed in the name of the field i want to sort by (product name in the parent form, and document name in the sub form). I have tried all combinations and permutations of the above processes but nothing seems to work. It seems i am missing one crucial piece to the puzzle, as i haven't had much luck finding a solution on groups.google or anything else (maybe im using the wrong search terms). I am having this problem with all of my databases, so any help would be appreciated. Thanks in advance.
View Replies !
Sorting Form By Filtered Data
I have a button that opens a second form and shows filtered data based on the selection of a ComboBox from the initial form. That all works nicely, I now wish to sort the Data in the new form by [POID]. The code I'm using looks like this; Private Sub Command5_Click() On Error GoTo Err_Command5_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "FRM_AWMPonum" stLinkCriteria = "[ClientID]=" & Me![Combo0] & " AND IsNull(DelDate)" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command5_Click: Exit Sub Err_Command5_Click: MsgBox Err.Description Resume Exit_Command5_Click End Sub What changes do I need to make to the code to sort the data?
View Replies !
Report Sorting From Form Selection
I am trying to create a form where the user can select which group of data they want (records complete, records due, etc) and also how they want the report sorted (project name, due date, etc.) I created an option group for the record selection part with a variable named myFilter being equal to the required filter (i.e. myFilter = "(([Assessment Details].[Completion Date]) <= Now())") I then created a combo box for the record sort part with a variable named myOrder being equal to the required sort (i.e. myOrder = " ORDER BY [Project Description].Deadline") Finally I created a variable named myCriteria which is equal to myFilter & myOrder. Then I try to open the report with DoCmd.OpenReport stDocName, acPreview, , myCriteria. Now, when I run the form and try to get the report, I get the following error: Syntax error (missing operator) in query expression '((([Assessment Details].[Completion Date]) <= Now()) ORDER BY [Project Description].Deadline)'. Is there any way to have the user be able to select the sort order and have it pass to the report? Thanks in advance.
View Replies !
Sorting Of Records In Text Box In Form
I have a text box called tboWorkstream on a form. I can scroll through the records using the navigation bar at the bottom. However, I want the records to be sorted by the Workstream Column, not the Workstream ID column (which is the primary key.) Is there a way to do this? I know you can list the way you want in a combo, but not sure how you do this in a bound textbox. Thanks sunil
View Replies !
Continuous Form Record Sorting
I doubt this is possible, but I'll see if anyone out there knows how to do this... so i have labor entries that consist of a laborID (the guy doing the labor) the serviceID (service being performed) and all the payment info (peripheral, not really important). what i would like to do is add a field, Area, that describes where on the house the labor is being performed, ie the roof, the master bedroom, the kitchen, etc... is there any way to sort these using continuous forms (maybe 2 continuous forms?) kind of like in a report where it goes, for instance (ignore periods, for spacing only): Area: Roof .....Tearoff yadda yadda .....Replace yadda yadda Area: Kitchen .....Redo electrical yadda yadda .....Replace toaster etc etc .....Fix plumbing etc etc Area: Bathroom..... etc thanks for any ideas...i know this is ridiculous, but i figured i'd give it a shot
View Replies !
Sorting Months (not Alphabetically) In A Form
I have a series of subforms that show customer mix percentages by month. These forms will be used for data entry and to ease the process I would like to have months in order of our fiscal calendar, July through June. Right now the months are listed alphabetically. Is there a way I can list the months in order without having to resort to a naming convention such as: 01June 02August 03September ect. Thanks
View Replies !
Sorting On A Form With Control Buttons
I would like to be able to use several control buttons to change the sorting order of the selected records on a form. The only way I have been able to do it so far is with a macro "go to control" and then using the Sorting Icons on the menu. Grateful for any help
View Replies !
How Do I 'copy' A Form Design And Apply It To A Different Table?
Hi! I am making a form that will be composed of two subforms. Each subform will be based on a differrnt table, however the tables are identicle as far as the number of columns. I designed form_1 to be based on table_1. Now, is there a way to copy form_1 (which will be changed to form_2 in the copied version) and redirect it to table_2? I tried copy and pasting form_1, opened it in design view, looked at the Form properties, specifically: Data-> Record Source, and changed it to table_2, but.....the form didn't pick up table_2 field names, values, etc. I am guessing this is not the way to do this but how does one do this? Thanks John
View Replies !
Sorting?
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 Replies !
Sorting Out By Dob
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 Replies !
|
TRACKER
