Hi folks
I have just devised a simply database but as usual when using it I found that I had left out some information.
To simplify - I could for example, make a drop down menu with the letters a-z but when finished realised that I had left out the letters K, L & R. How do I insert the missing data into the already created list?
Thanks for your help
Eulum:)
Okay I had an idea and I thought I might get ffedback as I am relatively new to this. I went through a period a couple of years ago when I used access alot and was becoming familiar with VBA etc but I havent touched it in 2 years so Im pretty rusty.
I am running a study and need to have to create a database that:
a. collects data about participants
b. Has a number of questionnaires (5), each of which can be filled out by participants.
THe main table has a number of fields that collects info about the participants the most important of which will be the ParticipantID - an automatically generated number which is my primary key.
In table 2/form 2 I will host questionnaire one. This will be linked to Table 1/Form 1 (Particpant Information) by this tables primary key - also the Participant ID. The relationship will be 1:1. Each participant can only have one Participant ID and will only need to fill out questionnaire one once.
Is it possible that when I add a new participant to the Participant Information table/form I also automatically create a record in Table 2/Form 2 (Questionnaire 1), as well as Table 3/Form3 (Questionnaire 2) and so on so that they have the same ParticipantID...?
I was reading a similar query somewhere else and they said to use the Form_AfterInsert Event command? Is this right (see here http://www.pcreview.co.uk/forums/thread-1687644.php)?
I feel a bit stupid but I am willing to learn and try new things Once I get started I think I will be okay. If you could steer me in the right direction it would be much appreciated.
I need to know when:
* a new record has been created
* data on a record has been changed
Does the On Dirty event capture this, or can I just use the forms On Change event?
I created a table in MS Access using a Lookup & Relationship data-type. This means that my record cells call upon a particular table for values. It creates a LIST of values for that cell.When I query a particular value in this table I get every possible combination of the value. My query and code are below:
OR,
SELECT MainT.Content.Value, MainT.Source, MainT.[Entities Impacted].Value, MainT.Update,
MainT.[Divisions Impacted].Value, MainT.Announced, MainT.Effective, MainT.Stakeholders.Value,
MainT.[Ref#ID], MainT.[Issuing Agencies].Value
FROM MainT
WHERE (((MainT.Content.Value) Like "*" & [Forms]![SearchF]![ContentCB] & "*" Or (MainT.Content.Value) Is Null)
[Code] .....
This means that if I query STATES: "California", I'll get back every possible combination that exists with the name California in that particular field.The issue with this is that I'll get MULTIPLE primary key values rather than just 1. So, if one record, under STATES has California in it, but the other fields in that record have the Lookup & Relationship data-type, then every possible combination of that record will query instead of the multiple field-values form that you'll see in the table I am querying.
notice that my primary key (REF#ID) is repeated numerous times! This obviously causes problems with generating records and forms concerning information for 1 particular primary key. Is there a way around this problem other than specifying search criteria down as much as possible?! Perhaps there is some SQL code.
Another simple question
I have 2 fields income and expenditure
i have a 3rd field disposable income
how do I get disposable income to automatically change when I input income and expenditure in a form
many thanks
His is itpossible to make abutton in access and then assign a equation to it to add the dat in two of the fields together, for example adding the "stock level" and the "re-order level together? ifso could some please tell me how greatly appreciated cheers
View 1 Replies View RelatedDear All
I want a help in adding data to a table w/o writing the whole word.
e.g. if a word like " Medical " need to be repeated in many records, how can i add it w/ just typing the letter "M" and the whole word will show up? like what’s happening in ms excel.
Please help me :)
I am using a database prepared by someone. But it seems that when i try to add data to a form I am not able to do that. Neither can I edit it. For both these purposes I need to use the table . i.e for adding records and for editing too.
Is it possible anyway that I can change the record in form it changes in the table as well. or I will have to work with tables all the time
Regards
Rahul
Hi,
how can I update the form with all the data of the table after modifying the form if it doesnot contain any data.
Hi i am a doctor dabbling in ms access and trying to make myself a database of patients. I have 2 forms named new and followup where i would add the data accordingly. I have a primary key named TSCID that is autonumber in the new patient form. I wanted to know how can i program my followup form in such a way that if i put in the TSCID as the foreign key and add that data, some other data such as name, age, gender, address, etc can be auto entered and it can remain modifiable.
thanks
Vinay:)
I have a form, created from a query. The query contains and links about six tables using an AutoNumber ID. The query also has fields from each of these tables.
OK, so when users enter their data into this form, I would like the autoincremented number to increase in each of these tables. The catch is that when the user enters data, he/she does not have to enter data into every field. Therefore, not every table will contain information. But there will be times later on that some of that information will become available and will need to be placed on the appropriate spot (based on the ID number.)
So, some of my tables do not auto-increment and some do. How should I go about resolving this so that when someone enters new data, each table's ID is autoincremented no matter if that table contains information immediately or not? Please Help.:confused:
Thank you.
hi
I had a form with TO,DATE,BODY and a button .
on click of a button this fileds should get added to a table.
I have created a table with same fields.
Thanxx
Hi All,
I need to make a payment based on the latest Verify Number to a specific person so i am trying to create a form that is focused around a person, looks up the latest Verify number and can make a new payment number to add new payments.
In my tables, it works perfectly excluding the latest Verify number whereas i do not have any filters set. The Verify numbers can change which is why i need to make a new payment based on the latest Verify number. Using this number, i can add many payments to a Payment Number and add many Payment Numbers to a Verify Number for example:
John
Verify NumberGo4566546
Payment Number 44
Payments101Work carried out £800
102Delivery costs £100
103Material Cost £400
Payment Number 49
Payment 168 Work Carried out £700
170Work Carried out£450
Verify Number Go4566952
Payment Number 50
Payments171Work Carried Out£900
177Work Carried Out£500
Steve
Verify Number Go5877654
Payment Number 51
Payments178Cleaning£120
My Tables are linked as follows:
Person Table( name of table )
PersonID( unique ID of that person )
Verify Table( name of table )
VerifyID( unique ID of the Verify Number )
PersonID( linking to Person Table )
PayNo Table( name of table )
PayNoID( unique Payment Number )
VerifyID( linking to Verify Table )
Payments( name of table )
PaymentID( unique Payment ID )
PayNoID( linking to PayNo table )
The Payments figures have no relevance as they are numbers given by the person to me so i do not need to link them, i only need to link the table they are entered onto.
I am trying to get this onto one form whereas i can see who i am paying, the latest verify number, the last payment number to the person and the last payments in a table. Then, i can click add a new payment number, and i can add a new set of payments t the newly created payment number.
Hope this makes sense!!
many thanks,
Nigel
In C# this combo box is calling "DropDownList".
How to make in in Access?
hi, i am new to access and struggling so any help would be great...
i have a db with 3 tables. students contains a Primary Key ('studentid') and then 'firstname' and 'lastname' fields. The two other tables (contactdetails, coursedetails) have 'studentid' as a Primary Key and then they each have other fields.
I set up relationships between the tables (1 to 1) but i would now like to create a form that will allow me to enter data to all three tables at the same time. (this would be ideal as it keeps the data normalised) if this isn't possible i would like to create a form that adds the 'studentid' record to each of the tables.
let me know if you need anymore details but if someone can point me in the right direction it would be cool.
cheers
I was wondering if it was possible to do this, currently if I need to add a new record, I have to add it all in the tables section, this works fine but would be easier if it could be done through the switchoard somehow.
View 4 Replies View RelatedI want to have a query that I run at the end of each Month to track a workers production and to store that data in a table for each worker by month. Can this be done?
Something like
Worker Jan Feb Mar
Mike 45 33 95
Sue 125 44 02
If this can be done could someone explain to me how to do this. I don't even know if a table can be used to keep stats over months and years.
Thanks for any help you can give
Hi.
I have a table with a NAME field and a GENDER field.
How would I code a query so that if the gender is MALE than MR. would be added to the front of the existing data in the NAME field? MRS. if gender is FEMALE?
i.e., the result would be MR. SMITH, MR. JONES, MRS. CARSON...
Russ
Please bear with me, first post, trying to get to grips with Access for work!
We (a primary school) had a "bespoke" database set up using MS Access by someone who has long left the area and now we need to make changes and I, as the most computer literate person on site, have been volunteered to make these changes.
My level is beginner (for now) and my first job is to add some new options to a "Titles" table, four columns, six records. Column1 = ID#, Column2 = Male Titles, Column3 = Female Titles, whilst Column4 seems to hold items from Columns 2 & 3.
If I add a futher option, I get the error "Can't perform cascading operation: Entry must be one of the Titles as featured in the drop-down box or in the Titles table.
Now, as far as I can tell, I HAVE added the new option to the Titles table, and they DO show in the drop down box in the main spreadsheet display, BUT the error comes back as soon as I try to confirm the new title.
Any ideas please?
This may be a very neebie question, but I have a form with drop downs for data choices. When an employee finishes with the selections, I would like all the data transferred to a table as a record. How would I go about doing this.
Any assistance is really appreciated!!
I have a Combo Box that places the Address into the given Address field. How can I have it place the second and third cloumns, from the Combo Box into the next two adjacent fields on the Form (Last Name & First Name)?
Please describe in detail, not just code, but where a how it goes. I am new at this thing.
I have an existing FORM called Evaluations where you can select a trainer and a trainee from two different combo boxes. Once a name is selected from both of the combo boxes I click on an assign button and I want it to record those two names selected into my evaluations table in the Trainer_Name and Trainee_Name columns.
How do I do that??? Please help??
Thanks
I have a query based on two tables and I have created a form based on that query. Now I want to take input in the form and then add that data to one of the tables, that the query is based on. How can I do that?
View 1 Replies View RelatedI have two tables in access:
TABLE 1:
ID
SINGLE_MULTI
TABLE 2:
ID
NUMBER OF VIEWS
MULTI
The data is a store of all viewers of a video.
Table 1 has all of my unique data within it. People within this table may have watched the video once or several times. People within Table 2 have watched the video several times.
I want to add a flag for "Multi" to Table 1. And, where a person is not a "Multi" create a flag that reads "Single".
I've spent countless hours (probably days) trying to achieve this and have failed miserably. Whatever approach I take I end up creating a new table that just contains the "multi" people.
I have a form that I'll populate with some data, I need to then append this data to a table and clear the form for use next month, is this possible?
View 1 Replies View RelatedI suppose a field could be added to tblProspectSkill, and the command button code could include that field in the SQL, but I keep thinking there should be a better way than copying the values. However, my attempts to link have led either to multiplying the record count by 9 or a recordset that cannot be edited.
the idea is that a position in football will be assigned nine key skills that are important to the team that is thinking about acquiring that player. For a position (quarterback, for instance) there will be a master list of nine skills, along with an importance rating (1, 3, or 5, which is essentially high, medium, or low) for each skill.
Then the prospect (the player being considered) is assigned a position such as quarterback. A command button creates nine records in a Prospect Skills table that is related to the Prospect table. The nine records that are added are the nine skills described in the previous paragraph. Each skill in this listing is assigned a grade, which has a numerical value as well as a letter grade. The numerical value is then multiplied by the skills importance rating (1, 3, 5) and the results are then averaged for a final value.The difficulty I described in the first paragraph is that when I try to link to the importance rating I end up with 81 records (9 skills * 9, apparently), but I can't sort out how to change that in a writable query.