have a combo box that looks up a product number form another field but i also have a combo box in the next field that has product name. It would be much better if once you select a product code that the product name comes up automatically.
I'm trying to get one combo box control what tables are available from another combo box. Example, combo box (a) includes numbers 1-5. Selecting (1) makes the data in combo box (b) specific to that selection. Selecting (2) makes the data in combo box (b) something different (pulls data from a different table).
In my Medical Insurance form the Insured field will be a combo box and I want this combo box to display both the employees and dependents names. Does anybody know if this can be done.
Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:
If Me.OptionGroup = 0 then recordsource = "Asset Categories" Else RecordSource = "Consumable Categories" End IF
I am a new Access user, and I am trying to create a database that will store and track print music.
I want to be able to track data by a text box called "Item Number". The item number is obtained automatically when the user inputs data from two different Combo Boxes.
"cmboInstrument" and "cmboMusicType"
Both these combo boxes look up separate tables which have in them two columns each 1. Instrument (Eg. Bass Guitar) 2. Code Number (Eg.0012)
The combo boxes look up the tables fine.
My problem is, that I want the txt box to display the data from both combo boxes (Eg: an eight digit number 01002111). I then also want the text box to generate a Item number starting from 0000. So all in all the Item Number after selections have been made will display 010110000000 (an ID number example).
The numbers generated need to be displayed in the table under Item Number so that they can be associated with the product, therefore I assume they need to be bound and I am currently using the code
"Private Sub cmboMusicType_AfterUpdate() Me.txtItemNumber.Value = Me.cmboMusicType.Column(1) End Sub"
Though this only works for one combo box, if I put it in another combo box - the numbers will not join together.
I want to create a combobox from 3 tables. The tables are like this:
Table / Field
TblSource / Source
TblAdverts / AdRef
Tbljobcentre / JobCentre
I now want a combo box listing everything from these fields in the 3 tables. Can this be done through VB or will I have to create a series of queries to append etc (which I think tends to run slower than code)?
I also want everything in the tbladvert table to be prefixed by PR and everything in the TblJobCentre table to be prefixed with JC.
Help on the first one would be great, but even jufirst part would be a big help.
Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:
If Me.OptionGroup = 0 then recordsource = "Asset Categories" Else RecordSource = "Consumable Categories" End IF
I have been designing a database and finally was making good headway. I have a junction table that references 2 tables (1-m) and the junction table creates an autonumber primary key that many tables will reference. I realized that the junction table could have duplicates. I did not want to use a composite primary key, but found that I could create an index that contained the unique combination of my foreign keys. No more duplicates. I thought things were looking up. I found out that it is a bad idea to use a combo box in dataset view to have look-ups to other tables. If it is a bad idea why have the option? It does make data entry easier. Anyway not my question. The other tables that refer to my junction table no longer show the values of the foreign keys, but displays an id number for my 2 columns.
I have combo boxes on a form which are pulling values from a one table and being stored in another table. However they are being stored as '1' or '2' in the other table once selected on the form, as instead of being stored as their literal values ie 'car' or 'van'. Is there any way of making this happen, as it makes reporting a nightmare! Thanks in advance...
I am trying to create a database which will act as a timesheet and management system.
I have several tables set up. some are: 01-Staff details containing Staff ID, Names, etc 11-Timesheets containing Timesheet ID, Staff ID, Timesheet Period ID 17-Timesheet Periods containing Timesheet Period IDs, Start Date and End Date. 13-Hours containing Hours ID, Timehseet ID, Project ID, Hours etc.
I want to set up a Combo that lists Names from Table 01-Staff Details, and when the user selects their name, enters the Staff ID on a new row in the tabll 11-Timehseets.
I am able to create the Combo to list the names from 01-Staff Details, but am not able to get the selected name to jump into 11-Timesheets. The field is not available in the Control Source.
Could you please assist? I am not an Access expert, nor have I done any programming, so a step-by-step solution would be greatly appreciated!!
Many thanks in advance
Sunil
p.s. I would then like to ensure that users can't edit data in certain tables (eg. they shouldn't be able to create a new Staff ID/name, etc)
My next task will be to create a sub-form (which I am able to do) where the user can select a project from a combo-box and enter the hours worked on it. I would like the project and hours to be entered on a new row under the table 13-Hours
I have combo boxes on a form which are pulling values from a one table and being stored in another table. However they are being stored as '1' or '2' in the other table once selected on the form, as instead of being stored as their literal values ie 'car' or 'van'. Is there any way of making this happen, as it makes reporting a nightmare! Thanks in advance...
I have a form (frmHourEnter) with a combo box (cmbJob) and if the number entered into the combobox is not in the list then another form (frmJob) is opened and a new number is entered. On closing this form I run:
Code: Me.Form!frmHourEnter!cmbJob.Requery
The combo box (cmbJob) does not show the new number unless I close the form (frmHourEnter) and re-opened it. If I add the following code to the one above:
Code: DoCmd.Requery "Form!frmHourEnter!cmbJob"
Then click out of, and then back into cmbJob the number is in the list! What can I do so that the number is in the list when the second form is closed?
I have been reading about how to set the table up for cascading combo boxes. Some recommend breaking down into several tables, others say keep it to one table.
Mine is broken down to 5 tables (and work) but if you go to the form (split form) and make a change in design view - even something as simple as changing the width of a field - then the split table looses 2 fields information (the middle fields) but the information is still saved in the main (studentcourse) record table.
My question is how do i make it more stable so that the split form table section does not lose the information?
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 tblProducts - Where is my inventory list and tblServices - where are my services
Also I have made an invoice form and a datasheet subform (orderDetails) where I enter/choose (using combo box) said services/products but I know only how to do it for one table ex. tblProducts. My question is can I make a drop down list for two tables? One column - ServiceName / ProductName So I can choose a service or a product in the same order line.Or do I have to join my services and products in the same table?
I have a list box with 5 items and need to design an option for a user to add a value that is not listed. how will the new fields be added to the table?
i have a table of 3 columns Named as C_Name, C_City and C_PIN..i have a combo box with All Value (All,C_Name,C_City and C_PIN)...i want to display All columns ,when i select All in Combo box and when i select Column C_Name, only display C_Name Column).
I have a combo box in a form that is used to populate one of the columns in a table. How do I get the description to appear in the table instead of the primary key?
Im kinda new to Access and only been using the "Access 2003 for Dummies" for learning and making small databases. So far I can find out how to do the things I want, but recently got stuck with a combo box feature. What im trying to do is select entries in my combo box so that it will filter the table and show all its contents based on that filter. Im not sure how to link the combo boxes the right way and it seems some VB coding is needed which I dont normally use. If anyone has any idea how to do it, tell me how! Thanks. BTW im using Access 97.
I've run into a little problem while working on a electronics component database:
My plan was to use one specific table for each kind of components, i.e. resistors, capacitors, transistors etc as the specific data of each type is quite different from the other types (resistance/capacitance etc). I also thought I'd use a main form with a drop box allowing the user to choose which component to look for and then a component type specific subform to let the user make a more detailed search.
The thing is that I'm not quite sure how to call different subforms based on the drop box selection (I guess I need a subform for each type of component)? Or can I call a table with each component's specific data types and generate a subform based on this table? (I'd prefer the latter...)
To find a specific resistor you might want to specify the resistance, the type of resistive material, size and tolerance whereas an integrated circuit requires information on type of circuit, package, size etc.
All similar questions I've found relates to the use of a single, main, table only, I can't really see how to do that here...
In a Related Tables, you need to enter a FK to link to the other table.You either key in the FG from memory..The standard procedure is to design the field as combo box AND use SQL to select the field that will input the ID of the other table. So, if you want to input foreign key 3 , the combo box will display what 3 is then when you selected Access will insert 3 for you.
My question is since I can later on, edit the table and change the the value to another value, and mess the whole thing up!!! HOW can I lock my first choice so it will stay unedited ? My second question is: Is this the only way to input the FK if you do not remember the exact ID number or there are thousands of records in the related table.?
So I've been reviewing cascading combo boxes and I am finding some good stuff. But here is a preliminary step I need. I need to tag each record with something like what month are they assigned in, and what products. Then I need the combo box to display what that month is that they are tagged in, and then populate the second combo box. It is the second combo box that will show the record on the form. Its possible that there will be two items they are tagged with.
I have a field showing who equipment is being distributed to pulling data from my US Employee table. If I make it to only the last name from my lookup
(SELECT [US Employees].[Last Name], [US Employees].[First Name], [US Employees].[Dept] FROM [US Employees] ORDER BY [Last Name], [First Name], [Dept])
I can also view the equipment listed under the individual it is assigned to on a subform on my US Employee table. If I try to have the first and last name displayed on my Equipment table, however,
(SELECT [US Employees].[Last Name]&", "& [US Employees].[First Name], [US Employees].[Dept] FROM [US Employees] ORDER BY [Last Name], [First Name], [Dept]; )
it will not display under the individual on the US Employee table. Is there a way around this without having to combine the fields on the employee table or separate them on the equipment table?
Today and yesterday I added new fields to a table and they are showing wrong when everything is right. I added yes/no fields and a combo box look up and when I drag them over to my forms they are just showing as textboxes and not a checkbox or combo box. When I look at the backend and look at the fields it clearly says it should be a checkbox or combo box. Iv done it the same way I always have and this time its just wrong.
I have a subform with a combo box selection field among other fields. Can I export the data showing on the subform together with the drop down combo box data for each record and all its choices so that it appears as the same combo box on the worksheet. The user will then update combo box selections as required and the results would be imported back into access in the correct boxes for inclusion in a report, is that easily achievable for a moderate access user?
I have a main form that has fields from different tables. This is a research study, so each form enters data into different tables. Well, each record is a person's data. Instead of scrolling through each record, I need an option on the main form that allows me to search for a specific person and have their data populate into the form.So far I am able to make a combo box that pulls up the record from one table. Well, HOW do i do it from ALL the tables!?? Do I have to make a query?