I have just created a combo box to list and select all of the records in my database so they can be selected quickly, however for some reason the list is not in the correct order.
I have been back to the table and sorted all of the records into ascending order based on the field that is being used in the combo drop down box, but it is still not correct.
There must be an easy way to put them in order. Do i need to change the primary key so that it corresponds the field i am using to search or is it more comlicated than this??
Also, I created a form using the form creation wizard and now i have a grey stone background that i would like to get rid of. How do i do this? There only seem to be 9 or 10 pre-made formats to choose from?
does anyone know where I can find some different backgrounds for my forms and controls? I have Office 2003 and would like to personalize my forms without using the limited colours provided by MS Access.
I have a Table with 6 fields, 2 are named Initial and Surname. Is it at all possible to have a combo box on a form with these to fields "joined" with the alphabetical order on the Surname. I understand that using a query will not work as the result is based on an expression
What I am trying to do is create a data entry form to an "order table" using 2 cascading combo boxes. I have created a data entry form based on a query. I can't get the cascading combo boxes to work properly.Here is the code:
Private Sub Combo0_AfterUpdate() Combo2.RowSource = "SELECT L2_ID,L4_Element_name,L5_Category FROM qry_ord WHERE L3_ID = Combo0.Value;" Combo2.DefaultValue = [Combo2].[ItemData](0) Command4.SetFocus End Sub
i have a combo box on a payment form which shows existing permit #s. i'd like to make the sort order show the most recently added permit first. i clicked on the build button next to RowSource on the data tab of the properties of the combo box which opens the query my combo box is based on. there are only 3 sort order options...ascending, descending, & not sorted. can this be done?
the permits form has a button to open the payments form (payments can also be opened alone too - ie. if somone applies for a permit today but pays for it tomorrow...). usually this will not be the case but that is why i have to keep it either combo or list.
I have a form that house two record selection combo boxes, one for Customer Name and one for the Tracking number.
Both work as intended and return the correct record.
The problem is with the sort- I used a query for the source. That query will allow either the tracking number to be the sorted order OR the Customer name to be the sorted order.
I need code to make the sort order in the combo boxes on the fly, depending on which combo box the user selects.
I have code attached to a command button to fill a Combo Box with data from a music collection. A letter of the alphabet is entered into a Text Box then records beginning with that letter are copied from a table, either by Artist or Title. They are saved to a temporary table at which time they are in no particular order. Those records are copied to a further table and saved in alphabetical order. This table is then used to fill the Combo Box.
I used two temporary tables because the records were not displayed in the correct order. I hoped this might cure it, it did not. The records are in order in the table but not in the Combo Box.
Code: Private Sub Command68_Click() 'SEARCH AND FILL COMBO BOX On Error GoTo errTrap DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM tempList;"
I have a form for user to select multiple items from a combo box, and 18 unbound text boxes , each time user selects an item in combo and hits "add" the value appears in txt box by order, I mean select1 then "add" filling txtbox1, select2 then "add" filling txtbox2 ... and so on till we reach txtbox18, then msg box appears that he filled the whole 18 boxe. I have already done this before for one txtbox which is a very simple operation, but i cannot figure out how to do it with multiple txtboxes.
I want to use buttons on a form to change the sort order on a continuous form. In the buttons click event I am using a public function (named Sort_1) to change the sort order. The first element of the event call is the name of a generic query (named Sort_1_Query1) and the query field to sort (LAST_NAME OR FRIST_NAME, depending on the button.)This is the Click Statement.
=Sort_1("Sort_1_Query1","LAST_NAME")
This is the Public Function Public Function Sort_1(SortName As String, FieldName1 As String) DoCmd.ApplyFilter SortName, FieldName1 & "between 'A' and 'Z'" End Function
I think the problem is in the use of quotation marks or trying to pass the query field name to the Do Command or the use of an ampersand.
I am using a combo box in my form and its row source is set to Table A, however, the data in the combo box arent displayed in alphabetical order even though the data from Table A is sorted in ascending order.
can pls help me by teaching me How to display "row source" in combo box in alphabetical order??
I've been trying to sort out my order form for quite a while now with no luck but i am hoping someone will be able to help me so that i can complete the form and finish off the system. I want the order form to have combo boxes that actually work (At the moment all my combo boxes bring up a message at the bottom saying something like 'control cannot be edited'), The product subform does not work where i want to be able to created the order (and i need the rest of the boxes in the row to be updated some how with the product information when i choose the product), Also non of the other boxes seem to work either and need to know how to update fields when employee and customer are selected in the combo boxes. Also i want to be able to show previous customer orders in the 'View Customer' form.
Here is the system: Gamez System (http://www.savefile.com/files/6926006)
Any help is appreciated but please try and keep any help simple as i haven't really been using access for very long.:)
I have a form/subform linked to 2 tables, staff and training. The subform lists training done and is sorted by course. How can I change the sort order to a different field? E.g. date?
Hello, i am really struggling in access creating an order form and an invoice report.
the attached example shows what i have so far.
however for the order form what i would like to do is have a drop down menu at the top which will have a list of invoice reference number for that particular student. which will in in the format of surname/date eg Bannister11/01/2006
as people will be ordering things at different times and need a new invoice each time. i see this as the easiest way. could any body help me with this??
I have a form containing several fields for users to import data. The data comes from multiple sources, and I have arranged my layout the way I want it on the page. I have noticed though, that when you are using the database and pressing the TAB key, it isn't in a particular order (shoots to different fields across the form). Can you change the order of the fields that are selected when the TAB key is pressed?
Guys, please save me!!!! I have an order form called OrderForm. It has multiple combo boxes, where i select data. e.g i have a page in this form, where i select the company details, and a second page, where i select the order specifications, all based on combo boxes. The form is linked to 2 tables, Order and Customers. First page is linked to Customers, second to OrderForm. When i open the form, i can select the company name in the first page, where the fields are automatically filled. When i go to the second page, i select the type of product, e.t.c. Ok by now. What i can do to save this new order? I mean the Order specs to create a new order at Order table, and link this order to Customers table. The tables are linked correct. Thanks in advance Iannisro9
On a form i have a combo box called DATE The row source for this box is SELECT tblCleftClinics.Date FROM tblCleftClinics ORDER BY tblCleftClinics.Date DESC;
On the form what do i put in the "Order by" field to make the dates appear in descending order?
OK....I have done a search but am still none the wiser regards allowing for VAT (added to an old thread but no luck!).
I am designing a little DB for an accountant at work. He wants to be able to keep tabs on orders he places with various vendors (currently uses excel) but he needs to generate reports etc. I have done this but would like to afford him the ability to add VAT to the order total if required.
So here is what I want to do. I want to add a check box to an Order Form that will add VAT at the current rate. If the VAT rate changes at some point in the future I do not want historic data updated to the new rate.
I want to add it to the Order Form as not all companies being invoiced are VAT registered. This will give the user the option to add VAT or not.
I have had a little play (see attached) but do not know how to get it all working!
Help, advice appreciated (or if anybody has a working example of VAT?). Cheers, Phil.
I realise I could do it by basing the form on a query like:
Select * from table order by field
But I have allready made andlaid out the form, after basing it just on the table. Is there a way I can now order the data on the form, after having created it?
I've sorted out a problem that I had with a Form that had a subtable on it, by setting on the properties of the form for the 'Order by' criteria to equal the Id number of the form. eg: if each record has an Idnumber I have put [Idnumber] as the Order by property.
I have no idea what this does though, even though it seems intuitive? it's a form... so what is there to order? hope i'm not just being very stupid!
