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 Replies


ADVERTISEMENT

Forms :: Sorting (DATE) Field In A Subform?

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

Forms :: Sorting Multiple Fields On A Continuous Subform

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

Forms :: Sorting Records In A Combo With Code?

Apr 25, 2014

Can you have a saved (unsorted) query as a row source for a combo and then add some code to enable the combo to sort the list?

Reason is, I want three combos to use the same query for finding records in different ways, but need the query to be saved, not a query built by the query builder that access takes you into from the row source on the combo data tab?

I only need the data listed in each of the combos to be sorted by one column in each of the combos.

Have seen something about bubble sorting, but not sure if this is OTT or even could be applied to this?

FYI, this is not a cascading situation.

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

Forms :: Open Up A Form To Specific Records In Its Subform?

Aug 6, 2014

I need to open up a form to specific records in its subform based on user input from combo boxes (Customer and/or PKGEngineer). The two combo boxes are on a switchboard. How can this be done?

Using:
Win 7
Access 2010

View 14 Replies View Related

Forms :: Set Up Navigation Form - Search Unbound Subform Records

May 16, 2014

have set up a navigation form which contains 5 unbound subforms that are made visible or not visible thru the on click event of command buttons on the main form, the subforms have a command button with an embedded macro that searches for a record based on what has been keyed to an unbound text box on the subform, this works fine when the sub forms are opened independently of the navigation form but when the search is done from within the main form, the error message is, "....cannot find the referenced from frmAQIFAList" subform, I tried referencing the main form name infront of the subform name but this also doesn't work, perhaps this would be better with code ? or is it because the subforms are unbound ?

View 4 Replies View Related

Forms :: Display Subform Records On Main Form As Text

Jun 28, 2014

I have a form with a subform in it. The Subform relates to a junction table.

For each record on the main form, there may be more than one record on the subform. The Subform only has one field on it (a combobox).

What I want to be able to do is have a text box on the main form that shows a concatenated list of all of the records on the subform.

For example, if I have 2 subform records, 'Yellow' and 'Blue', I want a textbox on the main form record to show 'Yellow, Blue'.

I have tried so many things I have found online (over about 5 hours, including a module called ConcatRelated) and absolutely nothing works!

View 5 Replies View Related

Forms :: Check All Records In A Subform Based On CBO Of Main Form

Jun 28, 2015

I have a form with 22 subforms (in about 11 tabs). Each one of these subforms has a controlling field in the main form (table) that dictates if the associated subform needs to comply with data entry rules or not.

For example:
Field in main form cboMed (Yes; No)
Subform: frmSubMeds has a list of medications

I want to be able to loop through all the records of the subform and determine if they are complete.

This check is run from a command button; that should also consider the value in the combo box. i.e. Check only if the combo has a value of "Yes"

Since i have 22 subforms and have to run the check on everyone of them, i have used the tag property to check if the record is blank or not. This is what i have so far

Code:
For Each ctl In Me.Controls
Select Case ctl.Properties("ControlType")
Case acSubform ' only look for subforms
If ctl.Enabled Then
If Not (IsNull(ctl.Properties("SourceObject"))) Then 'if it is a subform type

[Code] ....

The problem with this is that it only looks for the selected record in the subform and doesnt look for ALL the records.

View 5 Replies View Related

Forms :: Underlying Query In Subform Creating Duplicate Records On Form

Jun 18, 2014

I have an "Returns" master form that contains two subforms. The subforms contain items that we are returning back into our inventory. The underlying queries in each subform show only those records where the "Return Date" is null. The query(s) works fine, except that if there are 3 items that need to be returned there are 3 records that show in the master Returns form. I tried the Totals option in the query but the I need that Return Date on the subform. I only want one Returns master form to show the 3 records (not 3 records of the same master form).

View 5 Replies View Related

Forms :: Delete Records In Subform Based On Check Box In Parent Form

Mar 1, 2015

I have a parent form and connected to it is a subform. On the parent form I have a checkbox which enables and disables fields on the parent form and also hides the subform.

What I want to do is when the user unchecks the checkbox, this action also deletes the associated subform records, if there are any.I'm sure that this can be done with an SQL Delete query in VBA.

View 5 Replies View Related

Forms :: Adding Multiple Records To A Table Using Main Form And Not A Subform

Sep 12, 2013

I have an existing Main form that has a sub form that the user uses to enter multiple records into a table....it works fine EXCEPT that I need to make it even easier and more intuitive and add a lot of labels. Basically the user selects items from a drop down list that adds items to a Work Order. I need to add some labels to the form to make it more descriptive for the user.

So, what I want to add multiple records using a single main form.

Is is possible to?:

1. simply turn the subform into a single main form? Can this be done by using a Command button or something similar?

2. copy all of the controls etc from the sub form into a new main form and have it all work nicely?

View 2 Replies View Related

Forms :: Check / Uncheck Checkbox On Parent Form If Records Exist Or Not In Subform

Jul 23, 2015

I have a parent form which has a yes/no checkbox in the form's record source. Then in that parent form I have a sub-form. If NO records exist in the sub-form I want the checkbox to be UN checked. If records DO exist in the sub-form, I want the checkbox to be CHECKED.

But I want this to happen as records are added or deleted from the sub-form. In other words, if the parent form is opened and no records exist in the subform then the checkbox should be unchecked. But as soon as the first record has been entered in the subform, the checkbox on the parent form should be checked. Likewise, as soon as the last record has been revoved from the sub-form, the checkbox on the parent form should be unchecked.

What code do I need to accomplish all of this?

View 1 Replies View Related

Forms :: Show All Records In Datasheet Subform On Form With Combo Box Filters On Load

Apr 1, 2015

I am having an issue trying to show all records when I load my form. It loads correctly when I don't have a record source for the main form. However, the combobox filters will not work. My goal is to have users be able to use the datasheet, subdatasheet and combobox filters. I can get the form to work just fine when I link the Main form and subform, but when the form opens it is filtered on the first record. I have been successful with this approach when using other forms, but they didn't require a subdatasheet.

Is there anyway I can have the comboboxes to filter yet be able to show all records until the user selects filters? Is this possible?I finally got my Manager to agree to use a database instead of Excel files based on this form setup and I need to make as "user friendly" as possible (look and function like a spreadsheet) I attached some pics of the form along with the code for the filter.

View 1 Replies View Related

Forms :: When Subform Have No Records Then Total Field On Main Form Shows Error

Sep 1, 2013

In my database main form with subform. subform have query as recordsource.total of one of field in subform shown on main form. all is ok and show total correctly but when subform have no records then total field on main form shows #error. How to convert this value either into null string or zero(0).

View 2 Replies View Related

Forms :: Make Certain User Enter Records On Subform Before Attempting To Save Main Form

Dec 4, 2014

How can I make certain my user enters records on a subform before attempting to save the main form? Right now they can completely ignore the subform before saving the record.The Main form has business address, etc. on it. the subform is bound to a join table that lists the multiple categories, subcategories and sector the business is listed in for a directory.

I already have my fields set to required at the table level in the join table, and have some existing VBA in both my subform (to update edited date) and my form (to validate empty records where a certain condition is met) but that's not the issue...

How do I focus the user to enter a record on the subform to the point where they are forced to enter something and complete the subform before the record is updated.

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

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 A Subform

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

Sorting In A Subform

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

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

Subform Sorting?

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

Sorting A Subform With Ascending Values

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

Sorting Of Query In Subform Doesn't Happen

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

Sorting Records

Mar 11, 2005

I'm new to this but I am currently working on a DB for work. We are tracking employees that are trained by using an "X" in a Field to signify that they are in the process of being trained. Once they are trained they will enter the date it was completed. I need a query that will give me the number of "X"s and the number of dates. Currently it only gives me the total for all "X"s and dates. Is it possible to split the fields in a query and further receive the percentage of each including how many employees do not have any "X"s of dates? Any help would be greatly appreciated. I hope that this make sense.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved