Sorting My Form??

Jan 10, 2006

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 Table, Apply The Sorting To A Form

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

Sorting A Form

Aug 5, 2005

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 2 Replies View Related

Sorting On Open (form)

Apr 13, 2006

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 1 Replies View Related

Sorting A Datasheet In A Form

Oct 7, 2005

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 6 Replies View Related

Sorting A Secondary Form

Feb 17, 2005

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 6 Replies View Related

Sorting In A Continuous Form

Mar 24, 2005

Can I sort dates in an ascending order in a continuous form?

View 2 Replies View Related

Closing Form Slow After Sorting

Apr 26, 2005

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 4 Replies View Related

Sorting Form Like Reports Wizard

Mar 29, 2006

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 5 Replies View Related

Ordering/Sorting Data In Form

Feb 24, 2005

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 2 Replies View Related

Sorting Form By Filtered Data

Mar 14, 2006

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 3 Replies View Related

Continuous Form Sorting Problem

Mar 22, 2006

How can i let the continuous from sorting by DESC?

Thank!

View 4 Replies View Related

Report Sorting From Form Selection

Sep 27, 2004

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 1 Replies View Related

Sorting Of Records In Text Box In Form

Dec 7, 2004

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 3 Replies View Related

Continuous Form Record Sorting

Mar 17, 2005

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 2 Replies View Related

Help Needed With Sorting Dates On A Form

Sep 26, 2005

Why won't the dates in the form sort? 9attached) I have tried everything and cannot work out what i am doing wrong - desparate!!

View 1 Replies View Related

Sorting Months (not Alphabetically) In A Form

Mar 16, 2006

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 2 Replies View Related

Sorting On A Form With Control Buttons

Sep 5, 2006

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 1 Replies View Related

Forms :: Sorting Fields In A Form?

Mar 14, 2013

How is the easiest way to sort fields in a form. A database view sort is no problem but I can find no way to sort a fields in a form short of using a query. I am using Access 2010.

View 2 Replies View Related

Sorting Form By A Field Value In A Table

Sep 4, 2014

View 1 Replies View Related

Sorting Data In A Form By Clicking On The Header

Aug 31, 2006

Is there a way to sort data in a form by clicking on a corresponding control (e.g. label/txtbox) in the FormHeader?

View 5 Replies View Related

Forms :: Sorting Records In A Form (subform)

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

Modules & VBA :: Sorting And Filtering A Report With A Form

Jul 9, 2014

I'm having a bit of trouble with a piece of VBA code I have. What it's supposed to do is filter and sort a report using a form. But there are two lines, which both I need, in it that are not compatible with each other. When both are in and I apply the filter with only a sort, it gives me a "Run-time error '5': Invalid procedure call or argument."

But the code runs beautifully when only one of the pieces, which I've highlighted in red below, is in it. The debugger highlights strFilter = Left$(strFilter, lngLen) after I have received the error.

Code:
lngLen = Len(strFilter) - 5
If (lngLen <= 0) And ([cboSort1] = "Not Sorted") Then
MsgBox "Insert criteria before filtering.", vbInformation, "No Criteria"
Else
strFilter = Left$(strFilter, lngLen)

[Code] ....

View 14 Replies View Related

General :: Sorting Recordset In Form - Add Numerical Field With Sequential Value

May 23, 2013

I've been building a small app for some friends. At present, they enter "records" line by line into a word processor, then use (archaic, IMHO) macros to produce the desired printouts. They wanted the new data entry UI to mimic that process.

Ok, so I've adopted the datasheet form as the principal entry vehicle. Based on the initial info they gave me, there were two convenient fields to sort on, so I used them in the OrderBy clause of the query which serves as the form's recordsource. I also developed the code to maintain the sort order after they inserted or deleted a record.

Now it turns out they don't require an entry into those fields, and in fact there's no logical field at all on which to order by.

So the question is: how to approach this? From my reading, I can't use the primary key or an autonumbered field, since the former won't necessarily reflect the desired incrementation and the latter only triggers for a new record, not an insertion (is this correct?).

My thought is to add a simple numerical field (which will be hidden from the user) with sequential values. I can do the OrderBy on it, and add code to adjust those values whenever a record is deleted or inserted. (That will require looping through the recordset from the point where the deletion or insertion occurred.)

For instance, is there some way to add a calculated field to the recordsource for this purpose?

View 11 Replies View Related

Forms :: Sorting Recordset Clone Without Changing Order By Of Form?

Sep 27, 2013

I would like to get the Min + Max values of the data currently in the form, but without changing the sorting currently on the form.

So I was hoping for this, but it is not working. The data in the recordset are not sorted.

Code:
Set R = Me.RecordsetClone
R.Sort = "SendOn ASC"
R.MoveFirst
MinDate = R!SendOn
R.MoveLast
MaxDate = R!SendOn

Any other method except iterating through the entire recordset?

View 3 Replies View Related

Sorting?

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