Forms :: Possible To Have Combo Box On Form With Fields Joined With Alphabetical Order On Surname

Aug 1, 2015

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

View Replies


ADVERTISEMENT

Forms :: Bound Form - Items Not Appearing In Alphabetical Order

Aug 2, 2013

I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the form will not appear in order, because instead of going in order I am flipping through pages. What is causing this to happen? And what can I do to fix this?

View 2 Replies View Related

Forms :: Non Alphabetical Order Of X-Axis Label On A Chart

Jan 4, 2015

I have inserted a bar chart onto a form using a totals query. The query is grouped by days on stock, eg. '0-30', '30-60', '60-90' etc. which is therefore the labels on the x-axis.

The chart displays the correct data, however, the chart automatically displays the categories on the x-axis in alphabetical order... '0-30', '120-180', '30-60' etc.. Is there anyway to adjust this order to be eg. '0-30', '30-60', '60-90' etc?

View 1 Replies View Related

How To Display "row Source" In Combo Box In Alphabetical Order

Mar 29, 2006

Hi all,

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

thks alot

FT:)

View 3 Replies View Related

Drop Down Box In Alphabetical Order

Oct 23, 2006

I have created a form with a drop down box so that I can click on a client in the drop down box and it will pull the information from that clients record.. my question is :
Is there a way of having the clients names in the drop down box listed in alphabetical order without it changing the order in my table? My table is listed in order of project numbers not client names.

View 6 Replies View Related

Alphabetical Order Query

Jun 15, 2007

The main form of our contacts database has its source in a query which places all contacts in alphabetical order by surname. How do I get the query to sort by surname and then by first name? Also, how can I get the query to run each time a new contact is added so they are put into alphabetical order when they are saved, rather than appearing at the end of the list?

View 2 Replies View Related

List Box Alphabetical Order

Sep 26, 2005

Hi can anybody tell me how i can make a list box alphabetical and it updates as new records are added

Thanks

View 3 Replies View Related

Drop Down Menu In Alphabetical Order?

Mar 14, 2015

Just starting off with access. Is there anyway of getting fields in a drop down menu to be displayed in alphabetical order?

View 1 Replies View Related

General :: Concentrate First Name And Surname Fields In Form?

Aug 8, 2013

I am currently using Access 2007, where I used to be able to concentrate First Name and Surname Fields by simply using:

= [First Name] &" "& [Surname]

However I have downloaded Access Run Time 2010 on the other employees computers so they will be able to access the Database, however since i have done this the First Name and Surname do not appear, it simply shows:

#Name?

I am guessing this is because it is a newer version, however even when I open the Database with Access 2007 it still does not work, even if I delete it and add it again.

View 2 Replies View Related

Order By When You Have Joined Tables

Jun 27, 2005

If I use order by on a query that has two linked tables I keep getting an error:
This is the query
SELECT d.PDetailsID, d.po_id, d.po_uniqid, d.job_id,
d.p_qnty, d.p_desc, d.p_unitp, d.p_units,
d.p_extend, d.p_qos, d.p_grec, d.p_done,
d.cocreq, d.est_id, d.line, d.class,
d.selected, d.itemid, d.category, d.GroupID,
d.p_qosextended, d.late, d.lastsavedby, d.matid,
d.customer, SQLACCESS.tblctpur_d.jobid, d.DTime, d.Notes,
d.DescDetails, h.pur_ddue
FROM SQLACCESS.tblctpur_h as h INNER JOIN
SQLACCESS.tblctpur_d as d ON h.pur_id = d.po_id
ORDER BY d.line

The error is :
The colum prefix d does not match with a table or alias used in the query

View 8 Replies View Related

Create Access Form With Having Joined Tables Fields

May 14, 2013

I have at least 3 relates tables in my access database.the first(sessions) table stores session detailes like id,date,time

The second one (tblemployees) contains our employees details like name, idp ,the third (attreq) relates the first table to second it stores ids of sessions and ids of personals that which determine which personals have attended in special sessions.

Now,my problem is that I want when a personnel log in and opens "confirmed session"form ,the access check and open records that this person have attended. How can I do it?

View 3 Replies View Related

Forms :: Fields Missing On Tab Order Form

Apr 9, 2015

am trying to change the tab order but have noticed that some of the fields are missing from the tab order form. I am attaching a screenshot to show which tabs are missing.

Screen Shot 2015-04-09 at 21.44.55.png

View 7 Replies View Related

Forms :: Create A Data Entry Form To Order Table Using 2 Cascading Combo Boxes

Jan 31, 2014

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

[code]....

View 2 Replies View Related

Reports :: Grouping Multiple Fields (Firstname / Surname)

Jan 21, 2015

I have a report with the fields

Firstname_
Surname_
[field1]
[field2]
etc etc (they're not called field1/2 but they're irreverent at present.

On the database people can be entered multiple times so I may have

Bob Smith
Jimmy Carter
Bob Smith
Jackson Smith
Tim Jones
Jackson Smith
Bob Holmes

Now I now with the group function I could group by the firstname_ field but the results would group like the following

Bob Smith
Bob Smith
Bob Holmes

Jackson Smith
Jackson Smith

Jimmy Carter

Tim Jones

And if I do it by surname, well I am sure you get the drift.

So how can I sort so I would get the following

Bob Smith
Bob Smith

Bob Holmes

etc etc.....

View 2 Replies View Related

Can't Add Data Into Fields In Joined Query/tables

Jan 17, 2006

I can not, or not allowed to enter data in fields in a query built from three tables that are jointed by a common field with the same name. The parent table is linked to another Access data base as is one child table the other is local data. Also, I am not able to view the child table data when viewing the parent table.

View 1 Replies View Related

Queries :: Prevent Duplicates With Unique Field Of Joined Fields

Nov 2, 2014

I have a client database that has recently had multiple duplicate entries. I need to reduce or negate this erroneous activity. I have a client table where I record amongst others, the following;

key
[christian_name]
[family_name]
[dob]
......

I believe that to prevent duplicate entrie via form I have created an additional field called "unique" given it as a unique index which I want to have populated with the joined fields first_name & last_name & dob (IE johndoe01/01/90), and then as user enters a new client it wont allow a duplicate.

However I need to fill all the existing customers (3600+) with the relevant joined existing data. If I create an expression I can cajoin the fields in a select query but when I try to make an update query the same syntax comes up with empty fields.

select query sql that worked to show field ...

SELECT divers.christian_name, divers.family_name, divers.dob, [christian_name] & [family_name] & [dob] AS Expr1
FROM divers;

update query that was empty ..

UPDATE divers SET divers.[unique] = [christian_name] & [family_name] & [dob];

View 4 Replies View Related

Forms :: Created A Form With Combo Box Which Shows Certain Fields Selected

Feb 18, 2014

I have created a form with combo box which shows certain fields I selected. By clicking that I want to open a NEW form which has all the fields so that I can edit the record.

View 6 Replies View Related

Combo-box Order And Form Backgrounds???

Nov 29, 2006

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?

Thanks in advance

View 2 Replies View Related

Forms :: Create A Form Using Combo Box To Populate Multiple Fields And Tables?

May 26, 2013

I'm trying to create a form using a combo box to populate multiple fields and tables.

I've created a text field to display the added information using this format:

=Comboboxname.Column(x)

in the text box control source field, and this works for display purposes.However, I need it to populate this data into a field on a table.

For example:

My combo box looks up data that has 2 columns, Part Number and Description.

The control source for the combo box is "Part Number". And that populates the part number in the "Main" table no problem.

The text box I created using the above format in the control source populates the field in the form, but not the "Main" table.

Is there a way for the other (description) field to also populate the "Main" table as well?

View 5 Replies View Related

Forms :: Prevent Duplicate First Name And Surname?

Apr 25, 2013

I just need a simple method to prevent a member being imput twice on a form.

I have two fields firstname and surname ( this is necessary).

I want to stop duplication of the same person being entered when staff use the form.

How do I stop this?

View 2 Replies View Related

Forms :: Filling Multiple Text Boxes In Order By Choosing From Combo Box

Dec 1, 2014

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.

View 2 Replies View Related

Forms :: Use Buttons On A Form To Change Sort Order On A Continuous Form

Jul 23, 2013

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.

View 4 Replies View Related

Forms :: Cascading Form - Numerical Order ID

Apr 2, 2014

I have a problem with a cascading form, which writes back to another table. The scenario is:

There are three tables. Users, Departments & SubDepartments.

Each table has an Autonumber set as the primary key .

The form is to write back to the user table, and within the user table there is a Department & SubDepartment field. These are linked to the relevant tables and all that works.

For the form I have two combo boxes for Department and SubDepartment. Department simply pulls from the Departments table and displays/writes back to User table correctly.

The SubDepartment is the one I am having problems with. I have got it to cascade correctly but here is the exact issue:

On the existing records the subdepartment is being displayed as a number (the primary key autonumber). The drop down list displays the text of what the subdepartment is (which is what I require) but then when that is selected it throws up the error that the value entered isn't correct for that field. I guess it's because it wants to write back the numerical record ID rather than the text from the other field.

The row source query is SELECT [qrySubDepartment].[SubDepartmentName] FROM qrySubDepartment ORDER BY [SubDepartmentName];

The table fields for the subdepartment table are SubDepartmentID, SubDepartmentName, DepartmentID and SDID.

SDID can be ignored for the purpose of this question and DepartmentID links back to the main department. Just to confirm visually the cascading form does work in terms of when you pick a department it only displays the subdepartments associated to it.

View 2 Replies View Related

Forms :: Order Form Pasting Data Into Table

Aug 20, 2013

Okay I have an Orders Form, which generates a SubTotal Price (ex VAT), VAT, Shipping & Freight Charge based on an IIF statment of being under a 50.00 order apply 20.00 charge. And finally a Order Total with it all added together. This works fine, however I cannot seem to find a way to post these prices in my Orders Table. When I click on Datasheet View for the form, all the details appear as they should.

View 3 Replies View Related

Forms :: Setting Sort Order On A Form With Multiple Subforms

Mar 4, 2014

I have a tabbed form. The main form is titles ContractDtlsFRM. There are 3 other subforms in separate tabs. The first field in the ContractDtlsFRM is Contract No. I would like the form to sort in ascending order by this number.

I tried entering the following code in the Forms Order By event but it didn't work

Private Sub Form_Open(Cancel As Integer)
Me.OrderByOn = True
Me.OrderBy = [Contract No]
End Sub

View 2 Replies View Related

Forms :: Show Picture When Hovering Over Product Name In Order Form

Mar 11, 2014

I'm creating a database for a flower shop for training purpose. I have a main form with a sub form that has the orders in it. when placing a new order for a client and selecting the product from the combo box, it would be great if the product could show up to the right in the form.

I have no clue if this is possible and how to get it working. I have included the database as an attachment, which way to follow. I remember that I could do this on a web page, but a web page is not the same as a database.

View 5 Replies View Related







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