Hi,
I'm trying to create a table which needs some feilds to be automatically filled up when the control goes to it. Say my table has feilds, "size" and "result". In each row, the result cell should be filled up corresponding to the size value of that row. This needs to be looked up from an existing table.
I am new to Access, I know I couold do this easily in other DBs using a dependant relationship... but I can't get a handle on it here.
I have Client, a State and Coutry tables. What I want to do is assign a Country to a State (in the State table?) and then when I choose a State in the Client table, the Coutry field is completed automatically.
EmployeeID-----Full name AD------------- --Alison Doody AM---------------Ape Monkey PT----------------Pet Tepee
etc etc
In a form i want to be able to select the Employee ID and then next to it in another box the full name appears.
I've looked at other auto complete post, but nothing seems to match what i want to do. Can anyone help?
[for those of you who read the extremely BIG writing in the last post of the same as above, i apologise!! My PC decided to have a hissy fit just as i hit the submit button :mad: :o ]
I have a table witch hold a reference number in one field, house number in another and street in another field. I need to create a form that when the refernce number is entered by the operator the house number and street are automatically entered in the other fields. I'm not sure how to go about it can any one help.
Does anyone know if it is possable to get access to complete some fields based on data you have already entered? For example, if there were 2 fields 'title' and 'sex', is it possable to set the database up so that when you select Mr, the next field automaticly enters male?
I'm using cascading combo boxes with sql in each subsequent combo similar to:
SELECT DISTINCT [incidentnavigation].[type] FROM incidentnavigation WHERE [incidentnavigation].[involved]=cboincidentinvolved And [incidentnavigation].[person]=cbowho ORDER BY [Type];
If the result of the query is one line, i.e. click arrow and there's only one choice, can I get access to auto-fill in the box?
I tried an excel kind of if(count(query=1) then etc and it doesn't like it.
Auto complete was working with a combo box. After adding much functionality to a database I find that auto complete does not work on any combobox in any form. So I create a blank database and a simple test shows that auto complete works. When a form from the faulty database is imported in the test database, auto complete stops working on the test form. Even if the imported faulty form is removed, auto complete still does not work.
I tried creating a new database and importing the faulty form after removing all controls and events from the form except for the combo box. Auto complete still stops working. Not only on the imported form but also on the existing form which works prior to the import.
I checked auto expand and it is 'Yes' in all conditions.
What ever is causing the problem on the faulty form seems to cause some property of the database to change.
Is there some database option or property setting that controls auto complete?
Is is possible that importing a form will cause a database property to change?
I have created 2 tables, one for direct customers and one for indirect customers. (I consider indirect a customers customer). The 2nd table has a field that links every indirect customer to a direct one. I also have a table for inserting credit notes. The credit note is either for a direct or an indirect customer. I am using a form for this one. So the form has 2 fields, one for each kind of customer. If the customer is direct, i only insert the direct customer field. If its an indirect customer i insert the indirect customer field. What i want is to create a combo box that when choosing an indirect customer, to display the linked direct customer and to save it to the direct customer field.
I have combo boxes set up with the different choices for major, minor, year, etc. Is it possible for these fields to have an autocomplete option? For example, there are about 30 different subjects that students can choose for a major, so rather than having to look for it in the drop down menu, could the person entering the data just start typing "ant" and have it automatically fill with "anthropology" for example?
I should also mention that the reason I made these fields into combo boxes is because I built SQL in the row source so that it is bound to the primary key but displays the description instead (with the column widths set to 0; 1).
I am building a database to store student assessment information. I have a table with student information, a table with teacher information, and tables which will store the student's scores on a certain assessments.
Q1: I have a field in the assessment table for Teacher ID and Student ID which are linked to their respective tables. What I want to do is create a form for inputting the assessment data but the fields for teacher ID and Student ID to auto-complete or be combo boxes, I don't care which. That is, when a person is entering a student's scores, and go to enter their ID, they won't have to type the whole number out and hope they dont make any mistakes, they will essentially have a list of choices to choose from. Or as they type, the corresponding number will filter down. I already have refferential integrity on so that they can't enter an invalid ID in either field but I want them to have the choice.
Q2: In an assessments table, there is a 1-1 correspondence btw student ID's because only one student can have one score on a particular assessment. However, clearly one teacher can be tagged to several student's assessment scores. Any better way to tag the teacher to multiple student's scores without having fields in the assessment table for teacher ID which is repeated multiple times.
I'm working with a DB to enter orders for picking. I have an item list that I'm linking to when entering orders, and bringing in the data from the item list such as item location etc.
It's setup right now that when I type the first couple of letters into the item field it automatically brings up the matching items and if I click enter it completes the item and brings in the other fields from the item list.
Example: If I type in 'tom' I get back 'tomato', 'tomato sauce' etc. and when I choose the right one and hit enter it fills up the rest of the required info such as item location.
What I would like it to do is have the auto complete also check for middle words.
Example: when I type 'alm' it returns 'almonds', 'almond milk', but don't return 'container almonds' or 'container roasted almonds' etc.
I have been struggling with this and would appreciate any help. It sounds so simple!!! I have 4 fields (Unit Price 1, Unit Price 2, Unit Price 3, Unit Price 4) in a Orders table that I want to add together and store in a 5th field (Sub Total) in the same table using a form. I am having problems with the sum and I am unsure how to get it to show in the Sub Total box in the form as well as the table. Thanks for your help!!
Is their a way to highlight a feild. I am using the duplicate function but after the record is duplicated their are certain feilds that have to be changed, how can i highlight them somehow. ANy ideas??? The feild is Price???
The situation I am in at the moment is that I have a database for a company who does work at different building sites. I have created a database so that it has the date the work was completed. With this company in particular the last possible dates of payment are 30 or 60 days after the work was completed, depending on the work. I would like to know how I would be able to create a calculated field that would display the first day that the payment is late.
I have have 2 feilds in my database, there can be the same value in one feild but not both.....for example say NAME and ADDRESS i can have the same NAME for more then one entery and i can have the same ADDRESS for more then one entery but i cant have the same NAME And the same ADDRESS....anyone know how to do this? :confused:
Im having a problem with controling duplicate records in a table
i want to allow duplicates in all feilds individually, but not if 3 feilds are the same in more than one record. (ei. if the entries in a1,b1,c1 are equal to entries in a2,b2,c2; prevent the second record from being entered)
so far, i've writen a macro to identify duplicates in an existing table, but i dont know how to delete records, or access values being entered in a form
Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.
I am sure I’m not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question.
For a graph i have the below code sql to define the chart results
SELECT [Load],[Displacement] FROM [try];
try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph?
options in the text box are for example
TABLE1 TABLE2 etc....
If i use SELECT [Load],[Displacement] FROM [TABLE1]; SELECT [Load],[Displacement] FROM [TABLE2];
all is well, i need to get it to look at the text box, well a combo box
For a graph i have the below code sql to define the chart results
SELECT [Load],[Displacement] FROM [try];
try is a text box containing a table name within the access DB. how do i change the FROM sql statement to look at the name in the text box and use it as to draw the graph?
options in the text box are for example
TABLE1 TABLE2 etc....
If i use SELECT [Load],[Displacement] FROM [TABLE1]; SELECT [Load],[Displacement] FROM [TABLE2];
all is well, i need to get it to look at the text box, well a combo box
i have a database with a few tables, but i need a special one that stores initial date and final date for a particular ID, but like this... :confused: The table has the folowing fields; ID,STAGE,INITIALDATE,FINALDATE
New record: ID1 - STAGE - INITIAL DATE - FINALDATE( leave blank )
New record: ID2 - STAGE - INITIAL DATE - FINALDATE( leave blank )
When ID1 is repeated it must detect the blank field ( FINALDATE) , fill with the now date ( to finalize the record ) and also add a new record ( ID1 - STAGE - INITIALDATE - FINALDATE ( leave blank again ).
It also can have other records of other IDs in between.
I think i need a VBA code to detect the last record for ID#, detect FINALDATE field, write the date on it, save, and add a new record again.