I am following mice and am trying to build a form that lets me add a new mouse to the database. I want to be able to either enter the the unique mouse id of the mother if I know it or be taken to another form that lets me identify the mother from the females already in my system. I know this is possible because I have seen examples of it where, in the find mother form, I give the strain name in a combo box which narrows down the selection of mice in the DOB combo box which in turn narrows down the unique mouse id which is the information I really want. I then want to carry that id back to the original form to enter it as the mother id.
In an ideal world the database would recognize this id being put in for a mother and note in the mothers record that she has had a litter. The litter id, which I am currently composing of motherid&fatherid&DOB, would go into the mothers record.
When adding a new project to the DB (through forms, not tables) when we get to the Client Company, I have a look up menu for previous clients (many of which will be reused) and when I click on the company, I would like the information to auto populate the client company info (address, city, state, phone, etc.) form. The whole point of the look up is to not have to re-enter information for the same company over and over. However, if there is a new client company I will be able to fill that info in myself to be added to the table.
I have a main form EMPLOYEE RECORDS with employees information, with a Subform, where pay records are entered. Mysubform always shows record 1 of 1, and I cannot scroll back to see previous records. How can I see the previous entries.
I have a form that has four combo boxes on it that enable the user to select entrants in a golf tournament for tee off times and tee. (I have attached part of this database to this post) It all works fine but after selecting the first player in the first combo box and then selecting the second combo player I would like the player selected previously not to show up. Is this possible or do I have to rethink the way players are selected.
I have this estimate database for a construction company. In this database I calculate how much will a project cost. It's pretty much complete the only problem that I have is trying to figure out how to update the cost of a trade without affecting older records
Example let's say we have a painter that makes $15/hr in project A,B,C,D,E we decide to give him a raise so project F would have a new amount for painter. The problem with that is that it will affect record A-E
I don't want that my department wants to go back and view a history of records. Also take a look at my database it's my first time creating one ...
I've recently decided to move a database that had all its information on 1 table and divided it into multiple tables.
Attached is the relationship as well as the form.
The issue I have is that when I click the form, it only shows a blank record with none of previous records.
Data entry is already set to NO. I'm wondering if it's an issue with my relationships, tblStudioDescription is the parent table and the others are child tables so I linked them with the ID and set referential integrity.
I am trying to have cascading forms running on my database. The first form adds a new staff member. When you press the next button this happens...
Private Sub Command12_Click() DoCmd.Close DoCmd.OpenForm "Frm2" End Sub
But I want it to open Frm2 using the ID from the previous form. The stumbling block for me is I close the first form before opening the next so I cant pass the ID across.
I need to find out how to populate a blank form with the results of a query i.e. by selecting an item in a combo box and populating the form with the results.
Can a form be directly Bound to a dao recordset? I read an article form microsoft showing it being done in ado by setting the recordset property of a form.
I have a table that has the part number, the description, and the usage.
I am stumped on trying to get just the 2 fields to populate into this subform (datasheet view), when the part number is selected. I may have several lines of part numbers. How do I go about populating this form? The user will indicate the actual quantity. The quantity changes per order, yet the usage stays the same.
I have 2 forms. Information from one field links both forms (though it is not the primary key). Using a "open form" button I want the field on the second form to be populated with the contents from the same field on the first form, when a user selects the open form button. I imagine all of this is very doable in SQL, however I am using Access GUI to construct my database and have no time to learn SQL at this stage. Any ideas would be greatly appreciated.
I have a Form1 and Sub Form2...Form1 is a list of tasks: Each task has a quantity of Items.The forms are in Datasheet format.I have a list of people who can only do specific tasks and at present my Form2 is able to only select the relevant people for that task.The only way to "Trigger" who can do which task is to populate what quantity of work I want them to do. ie. create a link.
Is there anyway of clicking the little + button on Form1 that it prepopulates the total quantity to Form2 therefore creating a link and therefore being able to select who can do that task.If you look at the pic I want Items in the dropdown box to pre populate with the same amout as in the Form1 Items ie "1"
I am new to access but I am creating a form on access 2010 for a Pass Request. On the form so far I have two cascading combo boxes that work great so far. The problem is that once a name is selected from the second combo box(cboFullNames) I want a textbox underneath to populate(txtOrg). I have tried using requery and refresh but it never works. The only thing that seems to pull up the information is pressing the refresh button.
A subform on a main form is not populating after the user clicks on the subform and then returns to the main form and updates the field which the subform is linked to. The first time the subform populates absolutely okay; however once the user clicks on the subform and then returns to the mainform and updates the field which the subform is linked to the subform goes blank.
I have an address box that I would like to auto populate with a double click event. Basically, if the location address is the same as the main company address, and there isn't any data already in the location field, then I would like the user to be able to just double click the location address and the field gets automatically populated with the main company address.
Private Sub Address_DblClick(Cancel As Integer) If IsNull(Me.Address) Then Me!Address = Me.CompanyName.Column(1) End If
So this works fine if the main company address actually has an address in it. But if it doesn't then double clicking the location address produces a run time error 3315 for trying to populate a null value.
Now, I have created a main form based on student table and a subform based on studentCourse table. However, because I needed to populate the courseName and CourseDescription in the subform I changed its record source to a query (stID, courseID, courseName, courseDescription) so that when I move between the subform records the courseName and courseDescription still show in the subform.
To populate the courseName and courseDescription in the subform I changed the courseID to a combobox so that it brings the courseName and courseDescription from the course table and show it in the subform.
Everything is working fine so far BUT when I choose to input a courseID manually into the combobox, it does not populate the courseName and courseDescription as it does when I choose the courseID from the combobox.
In my database table I have a MainMember_Tbl which contains address fields. I also have a related table (via a field called Member_ID) called JointMember_Tbl which also contains address fields. For any particular member, mostly there is no joint member, but when there is a joint member the address fields are often the same as for the main member, but not always.
In the case when they are the same, I would like to use a button within the data input form for the joint member to 'duplicate' the address fields saved in the MainMember_Tbl - For example ....
Hi Experts! I'm having a problem that I hope some of the experts can help me with. I am in the process of designing a database for a health insurance company that does health fairs.
I need to have a data entry form for the nurses to enter the Health Fair results. I created a form for them to search for the Employer group. They type first few letters of the group, click "find group" button and it brings up a subform (frmGroup_sub) with the filtered group. I then have the group number (field PARGRP) hyperlinked to bring up another entry form (frmHF_entry) when clicked. I need the user to be able to find the group, click on the group number, then bring up another form which autopopulates that PARGRP from frmGroups_sub into the new form, frmHF_entry and stores that group number in the table tblHF. Further, they will need to do more than one "employee" for the pargrp. So I was going to make a subform of frmHF_entry where they could enter multiple records for that same PARGRP.
I just confused myself and probably all of you...but the problem I am having is I cannot get PARGRP from frmGroups_sub when clicked to open and auto populate the form frm_HFEntry.
Here is a screen print, maybe it will help explain what I need. http://img82.imageshack.us/img82/1065/frmhfentry1ed.png
As simple as it sounds. I have set up a table with a list of items and the costs. I then created a form with a list comprising 10 combo boxes. I want to be able to select one record from the underlying table per combobox on the form.
I am able to do this but the records in the underlying table keeps switching to the primary key field as I go along using the combobox.
I have a Form in a datasheet view and i would like to be able to double click on a record (ideally any part of the record but if not, on the name at least) and have it open up a form to that record details.
Picture 1 is the table with the records in.
Picture 2 is the form i want it to open and populate.
I am trying to build a build calender to display customer orders on given days. I have the calender in place with intentions of having a list box on each day to display the orders.We have a daily report that is an excel file that lists these orders. I have linked this file to an access table in my db.
I am able to use this linked table to run a query and generate a report without any problems.When I try to use the information in this table to populate a list or combo box the only fields that will display are all numbers. If I use a field like "Customer Name" I get no information displayed. The data in excel and access are both set as text.
I have a Pupils database where I have a form with Pupil name and ID.I have a query with a calculated field and the ID and this works great.
I can display the associated calc on the form using a sub-form (I link the ID in the calc to the ID on the form) but I dont know how to get this value to display in a listbox.
I have a form in which I want to capture today's date when another field on that form is changed from active to Closed. In excel I would write an IF statement but can't get my head round what I would do in Access to achieve the same result. basically it's if (field name 'status')=(criteria 'closed') then populate field (date closed with 'today's date').
