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