Ordering Form

Nov 4, 2006

I have actually 2 questions. They are probably very easy to solve, but I have no idea where to start looking.

1) I have a form (Form1) which has a combo box. When pressing "F2", I start a second form (Form2).

On Form2 I want my records order by Name, but I always have them ordered by ID. I tried the "Order By" property on the form, but that doesn't seem to work.


2) When closing the form, I want the selected (or the newly created record) to be the current record in the Combo box on Form1. How do I do that?

Thanks.

View Replies


ADVERTISEMENT

Ordering By Date In A Form

Dec 10, 2014

I have created a form with many companies. each companies have 4 events in one year,but the first event in the form is the last one. How can order this events in this form chronologically?

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

Ordering Help

Dec 8, 2005

i have a database with 3 main tabels: customers, items being sold and orders. i am having problems with having more than one item assigned to a order. can anyone help me please? i am new to access so if anyone can help can you explain in symple steps?
thanks
mooink

View 2 Replies View Related

Ordering Sheet Help Please!!!

Feb 22, 2006

hello i have created an ordering sheet for my company. i want to know if it is possible to automatically record the time of each order made?
If possible could someone tell me how it is done?

Also is it possible to put a clock in an Access database?

Thanks

Sean

View 2 Replies View Related

Ordering Sheet Help Please!!!

Feb 22, 2006

hello i have created an ordering sheet for my company. i want to know if it is possible to automatically record the time of each order made?
If possible could someone tell me how it is done?

Also is it possible to put a clock in an Access database?

Thanks

Sean

View 2 Replies View Related

Ordering Records

Nov 25, 2005

Is there a way of , when a database administrator enters a new rocord to a database, making the new record appear at th e top of the table it is enter ed into, i.e can he prefix the entry to tell access to put the record at the top of the table

View 1 Replies View Related

Ordering Dates

Jul 25, 2007

Hello

I have a question on date order please see attachment. I have changed the numerical value into a date abbreviation with an iif statement in design view via another crosstab query.

I am now trying find out a way to start the data with April and ending with March for my financial year. Any help would be appreciated.

Thanks

View 2 Replies View Related

Ordering Records

May 12, 2005

I have a database containing music library data, with fields <Composer> and <Title>. I have a form that shows a these fields as lists, but I want to add a button at the top of each list to order the data by that field. How do I do it?

View 4 Replies View Related

Manual Ordering.

Jun 9, 2005

I think this may be impossible but I am hoping it isn't :)

Have any of come across a way to Manually order a continuous form.

The way I would see it working is to have a column in the table called sort_order and two buttons on the form called move up and move down. Once clicked the sort_order value would change thus changing the order on the form.

I should imagine it would be alot more complicated than my brief description, in fact it may like I said be impossible.

If any of you have an idea how to achieve this I will be very grateful

Cheers

Paul

View 4 Replies View Related

Report Grouping And Ordering

Jan 5, 2006

Hi everyone,

I have a field in a table on Access 2000 database with takes the following information in any order and can be repeated. e.g. can have 10, etc people with contact signed, 10, etc people with PDD issued, etc.

contract signed
PIN issued
PDD issued
validation finished
Host country approval
EB approved
CER's issued.

I am designing a report in which I want to Group and order the info. in the field in the order shown above, e.g 1. contract signed, then 2. PIN issued followed by PDD issued, etc in Ascending order say and the other way round say CER's issued, EB approved, etc.

Can anyone help here? I have not much experience with designing reports but I have tried using the report Sorting and Grouping and it does it in aphabetical order, not in that order I require.

Thank you

dfuas

View 10 Replies View Related

Ordering In A Report Column

Jan 23, 2007

I have used the following Query statement to produce a variable that appears in a Report column:

ValueInReportColumn: IIf([Number1]=0,"NA",Val(Format([AnotherQueryName].
[Number2],"Fixed")))

Although the The Val function reconverts the text, produced by the Format function, back into a number the IIf function seems to convert back to text again. This means that in the Report, when I order the values in descending order I get:

NA 50 50 50 40 28.57 14.29 100 10 0 ...


Is there anyway round this, to order the numbers and leave the text value NA at either end?! Hope this makes sense! Any help very welcome. mcchu

View 2 Replies View Related

Ordering A DISTINCT Query Of Dates?

Jul 20, 2005

Is this possible, if using the following:

SELECT DISTINCT (Format([Month],"mmm yyyy")) FROM Table;

Adding a ORDER BY [Month]; gives a "distinct and order by" conflict...

Is there any way to alleviate this?

I want to display a "mmm yyyy" formatted combobox in order (i.e. Jan 2005, Feb 2005, Mar 2005, etc...)

TIA!

View 7 Replies View Related

Ordering A Drop Down List In A Page

Aug 22, 2004

hey,

i have a page, with several drop down boxes, each containing quite a few options, but they dont show in alphabetical order so its a pain trying to find the one i want. how can i order them by alphabetical order,?

thanks

Baz

View 1 Replies View Related

Forms :: Ordering 10 Line Items At A Time

May 22, 2014

How to generate prescription order form, so that I can order 10 line items at a time. I have the following tables,

Suppliers
---------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No

Order Form Header
-----------------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No
Date

Order Items
-----------
OrderID
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty

Items
-----
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty

View 2 Replies View Related

Queries :: Ordering Columns Cross Tab Query

Nov 26, 2013

I have a cross tab query. Essentially it groups together posted volumes into week numbers for different offices.

However, when I run the query, the order of the columns is not in a logical number order. I get Week 1 then Week 10 then Week 11 and Week 2 is further down the list and then Week 20 comes after that.

I would like if at all possible the Week Numbers to follow after one another i.e. Week 1 first then up to Week 52 in correct number order.

In my Dates Table I do have a SortID column which I hoped would resolve this issue so I could sort on the SortID column however this fails to work.

Attached is the query...

Code:
PARAMETERS [Forms]![frmSumOfVolByCCAndFormat]![cmbOfficeSearch] Text ( 255 ), Forms![frmSumOfVolByCCAndFormat]![txtStartDate] DateTime, Forms![frmSumOfVolByCCAndFormat]![txtEndDate] DateTime;
TRANSFORM Sum(tblTrafficEast.TrafficVolume) AS SumOfTrafficVolume
SELECT tblOffice.CostCentre, tblOffice.OfficeName, tblTrafficFormat.Format, Sum(tblTrafficEast.TrafficVolume) AS [Total Volume]

[Code] ....

View 3 Replies View Related

Forms :: Ordering Database - Field Not Printing?

Mar 24, 2015

I have an Ordering database where the order form contains a subform with the order lines (Order_line_subfrm). In this subform footer I have 4 currency fields, one f which is delivery fee (default is set to zero). When I add a fee into this field on screen, everything works (i.e. adds up) and the value is there to see. When I go to print the form (paper or PDF) the delivery fee returns to zero (the database entry is still present).

View 11 Replies View Related

Ordering Lines Within A Memo Field By Date/time

Dec 7, 2006

I have a memo field which records the events that happen on a form. So for example when a user changes the assignment from one user to the next, a row is written to the memo field indicating date, time, windows logon and then a brief description

Basically I end up with :

07/12/06 11:16:34 kleaves : Assigned user changed from Joe Bloggs to John Doe

At present every new row is added to the memo field at the end, so the most recent action is at the bottom.

How can I sort this so that most recent is at the top.

View 8 Replies View Related

Sorting Table / Query - Ordering Numeric Values

Dec 30, 2013

I currently have records that end with a letter and 2 numbers. For example, A1, A2, ... , A10, A11. When I try to sort my table/query by these values, A10 & A11 come before A2. It seems that it is sorting by the first digit shown. Is there any way to fix this quickly within table/query properties so that this can be displayed in proper numeric order?

View 7 Replies View Related

Forms :: Button In Form To Open Different Form And Chose A Customer Based On Last Form

Mar 26, 2013

Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.

I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.

View 5 Replies View Related

Forms :: Opening A Form From Another Form Via Combo And Auto Loading Form Data?

Apr 14, 2015

I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.

The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.

The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.

View 9 Replies View Related

Forms :: Send Data From Pop-up Form To Main Form (sub-sub Form)

Aug 27, 2014

On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.

On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.

So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.

(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)

View 5 Replies View Related

General :: Create A User Form With Sub Form Using Form Wizard?

Aug 10, 2013

I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.

View 4 Replies View Related

Open Previous Form From Current Form Sub Form

May 7, 2005

I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??

View 9 Replies View Related

General :: How To Make Form Controls Change Size / Position As Form Is Resized

Jul 24, 2013

how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.

View 4 Replies View Related

General :: Bound Form With Search Box - Select Record In Dataset And Display In Form

Aug 19, 2014

I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?

View 1 Replies View Related







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