I have created a database in which I have used a combo box on several forms relating to corresponding tables. These combo boxes all reference the same table with names (text fields) listed. I am having difficulties getting the data to feed into the table from the combo box using the form. Only the ID numbers appear in the table.
View RepliesNew to the navigation form: I need several forms in the navigation form to all relate to the same client ID field. I have this information on the main form but the form with in the navigation form will not pick it up.
I have tried =[Forms]![Frm Client Information Navigation Panel]![ClientID] But just cant get it to pick up that information...
I would like to have something like the master link fields and, child link fields but when I add a form to the navigation form this option in not available.
Hi all. This is my first post on this particular message board. I'm having a little problem getting Access to do what I want and hopefully someone here can help me out.
I have 2 forms. One larger form called RTV and one smaller one called Product Line. Now, most of the fields that are in the Product Line form are also in the larger RTV form. What I want, is for the product line people to enter information into the product line form. Once they're done, they exit the database and then, later, their managers look at this information in the product line, verify that it's correct, and then hit a command button that transfers all the fields that are the same on both forms, to the RTV form.
For instance, a prod line person would come in, fill out a date, part number and PO number and hit add record. Then, a manager would get on that same form, make sure everything is ok, and send the data over to the end of the RTV table.
Also, the product line people should not be able to see or edit the RTV form. Only a few people should have the priveldge of seeing both forms. Anyone have any ideas?
I need help relating 2 Cascade combo boxes
I need the coding I see the example online at
http://www.fontstuff.com/access/acctut10.htm
But I need the Coding it explains good how it works
CD Group
CD Name
Displays CD Group related to the fields in CD Name
Thanks,
Mike Va nDer STad
I need assigning IDs across tables so I can relate them. I have two tables.
The first table contains data regarding schools.
SchoolID [autonumber, primary key]
SchoolName
SchoolPostcode
The second table contains data regarding children numbers in each year group for each school
VaccinationSessionID [Primary Key]
SchoolID [want this to match the school id assigned in the first table!]
SchoolName
WeekofVisit
YearGroup
StartingDenominator
Etc.
In the second table the data was imported from Excel, so all but the School ID was imported. Each school name appears 7+ times in the second table.
How do I get the school ID assigned to a school name in the first table, to automatically assign and fill in the (currently blank) School ID field in the second table? I want to remove school name from the second table eventually, to use the Primary Key school ID in the first table, and Foreign Key school ID in the second table.
I have form with a combo box that displays error messages from Table A. These error messages are linked to Table B via an ID. The other table also contains an error message. I can obviously display the error message and ID from Table A in the drop down box.
What I want to be able to do is display the error message from TableA and also the error message from Table B.
Is this possible and if so how?
The control is bound to a further table but the ROW source is via a select statement. Is it as simple as changing the select to some query? If so how do I select the fields to display or are all the fields in the query displayed?
I have an unbound Combo Box in a form that I would like to use to set criteria in the query. How do I do this?
View 1 Replies View RelatedI have an unbound Combo Box in a form that I would like to use to set criteria in the query. How do I do this?
View 2 Replies View RelatedI have an unbound Combo Box in a form that I would like to use to set criteria in the query. How do I do this?
View 3 Replies View RelatedI have a table with the following fields: Login ID, Description Password, Login Type, Location, Status. For every Login ID there are some old passwords that had different effective dates. I want my form or table to behave so that I can enter all the old passwords with the effective dates and keep adding to this record. I know it has something to do with subforms but I don't know how to do it. Please help.
Thank you
Yusuf
I think this is probably going to be an embarrassingly simple question. I'm new to access and still struggling with the simplest of concepts...
I'm trying to relate three tables:
tblContacts
ContactID - autonumber, primary key
FirstName - text
more fields...
tblPrograms
ProgramID - autonumber, primary key
ProgramName - text
ProgramDesc - text
tblProgram_Contacts
ContactID - autonumber, primary key
ProgramID - number, primary key
ProgramName - text
Selected -true/false
I have a main form, Contacts, for the user to input all the necessary data about a contact. What I'm ultimately trying to do is also include a subform which contains the name of each program (there are 12 or so) with a true/false checkbox. I'd like it to work so that if a program is added, it automatically gets added to the subform with a checkbox.
Also, I'd like the results of that subform to get dumped into tblProgram_Contacts.
Sigh...
A great vision... but I really am not sure on how to do any of this (specifically, properly defining the relationships and properly constructing the subform). Any suggestions would be greatly appreciated!
Hello,
I have a pretty basic question about creating relationships in Access. When in the relationship window that shows all tables and associated relationships, I am a bit confused as to whether you are to drag the parent field to the child field or vice versa. When trying both, it appears to create the 1 to many relationship in the same direction no matter what way I create the relationship. So I am hoping someone will explain this a bit further to me or at least direct me to a reasource to clear up my, and possibly others, confusion. Sorry for my ignorance on this one! :o
Thanks a lot,
Dana S.
I have a combox field on subform C that shows records from a query.How do I get this combo to only show records that relate to an ID on subform B.I have a subform for storing contracts and these are stored against a company name.On subform C I have a field that currently shows all records in a table. I need this combo to only show the records that relate the current record on subform B?
View 4 Replies View RelatedI want to relate two records in one table, a parent child relationship. I can accomplish this task with two tables I realize. I'm wanting to write a database that will map a family tree. Internal to one table I want to be able to establish a series of relationships, parent-child, sibling, et cetra. Can this be done?
View 2 Replies View RelatedI have form with an unbound combo box which is populated from a query
It should populate a field in a table which is related to another - however it only works when i query by id number (primary key) and not the text value i want - is it possible to query both so it returns say 1,option 1 - then when selected it will place a 1 in the table - which is related to option 1 in another table instead of just having to select '1' which will mean nothing to a user?
I've been tasked with creating an Access database..We have a main table that includes information found on every lease, however there are 3 leases types. Each which lead to another table or two. Basically, I want to create a form that allows me to link the main table with the corresponding variable tables.
View 1 Replies View RelatedI'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?
In my database I have a table that keeps track of a package of items. The package is assigned a package type (counter display, end cap, half pallet, full pallet for example). The record of the association of the package and it's type is held in the main table.
Each of these package types is either a case or a pallet (counter display and end cap are cases and half and full pallets are pallets) This relationship is kept in another table (we will call it description table).
Now, based on the type of package and therefore it being a case or pallet a UPC and a GTIN number are assigned. The GTIN number is different if it is a case or is a pallet. I have a table that stores all of the UPC and GTIN numbers available in 3 columns, one for UPC, one for GTIN Case and one for GTIN Pallet (the UPC is a standard 12 digit and the GTINs are 14 digit -with the first 2 different to designate pallet or case. and all are based on the check digit formula necessary)
The user assigns the UPC and correct GTIN number by clicking a button which applies the next available UPC code to the package and determines if the description of the type (case or pallet) and inserts correct GTIN number into that field. I actually have all of this functioning correctly.
Now the problem. If a user changes the package type, and therefore changes the description, I need to add code to the update event of the combo box that gives the choices for package type that does the following:
Check to see if the original package type was a case or pallet (it's description) and if by changing the package type it is now changed to the other, update the record in the main table to the correct GTIN number based on the existing UPC Code.
OR as I write this, maybe the code could simply update the main table with the correct GTIN code based on the new description and the existing UPC code. This was I would not need to check for a change just do the update every time.
In our organization, when employees need to ask for office supplies, they have to fill out a Supplies Request Form (SR). Then Procurement team makes a Purchase Order Form (PO) based on the SR. One PO could have one or more SRs. Then once the items have been delivered by the supplier, the Receiving team makes a Receiving Report Form (RR) based on what was delivered. One PO could have many RRs.
What I want to create is like the one in the Northwind Traders template in Access 2010. Where there is a Purchase Order and a checkbox to "Post in Inventory." When clicking the checkbox, the ordered items will automatically reflect in the inventory.
However, mine is a little bit more complicated. When there's an SR, I want to have a checkbox that will automatically reflect on a new PO. I also want a checkbox for PO that should automatically reflect on the RR. And the RR should have another checkbox linked to the inventory which should be able to update the total available stocks.
I am using Access 2007 and have inherited a database. It has linked tables of Excel spreadsheets that are information extracted from our main system. The user wants developing a much faster and customized approach to billing the customer based on payroll related information.
There is a table of payroll billing transactions and it has the following record lay-out,
job_num, employee number, employee name, union group, rank, regular hours, overtime hours, other hours, trans_date, seq_num
6430, 2301, john doe, 1, F, 8.0, 0.0, 0.0, 12/01/2012, 254333
On December 1st John Doe worked 8.0 regular hours as a pipefitter foreman on job number 6430 and this is record (sequence) number 254333.
There is another table that defines the union group. I am not concerned with this information at this time. The seq_num is a sequentially and uniquely assigned number given to each billing record in the main system.
There is also a Rate Master table and it has the following record layout,
job_num, union group, rank, regular_billing_rate, overtime_billing_rate, other_billing_rate
I am struggling as to how to relate these two tables so that I can develop some queries from it.
I have a couple forms with Combo boxes that look up data in queries. I noticed in testing that I could accidently type a "~" (and other characters) in the field and once I do, it causes a runtime error that shuts down the entire app (as opposed to letting the user backspace out of it or resetting the field). Before I put in some "Before Update" code to prevent the system from crashing, I want to make sure I am on the right track. I have already set the combo box to just show the list, not allow edits, limit to list, etc. Is there a way to prevent the user from doing this either by preventing the keyboard from working on combo boxes (not preferred) or by trapping it before the system crashes? I would think I could validate with a recordset, and create my own path out for the user, but I was hoping the combo box would have sort of done that work for me.
View 1 Replies View RelatedIs there any way to list a combo box with all the forms of an Access Database?
View 5 Replies View RelatedSo I've got a form set up, and it uses a combo box to find the name of a persons record to populate the form. Simple enough stuff, the wizard takes you through it. It works fine.
However the people that use the database have kinda thrown me a curveball by asking if the search function can search any part of the name. For example, you've got a John Smith. If you enter Smith into the combo box, it won't find the record because it's the second name, you have to type in John.
Is there a way to use wildcards in the combobox so you can type in first or last names and get the same normal combo box effect?
I'm trying to get a combo box & button to work together. On the main form of the attached database, I just want the button to go to the associated record based off my selection (or entry) in the combo box.
I've tried the following:
- Looked through the Northwind sample database for a close example. Tried my best to replicate the functions but it didn't work
- Looked through other examples posted and tried to manipulate the code to no avail
- Tried using [Forms]![Main Form]![cmbLastName] in both the filter & criteria section of the macro
I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.
View 4 Replies View RelatedI am a girl guide leader trying to make a faster way to keep track of my unit's completed badge and program work. I have made tables for every area I need (I started with one table but it was too large to change into a form).
In total I have:
- Basic Member table (main information like their name and how many years they have been in, whether they are still in the unit, etc)
- Program area tables
- Interest badge tables
What I want to do is be able to "add/edit" members from the main form, then go to all the sub forms for their program and badge work -- problem is, how to link them!
I am using Access 2007-2010.