Hello!
I got a database with two tables in it.
Site table has following fields: ID,SiteID
Customer table got following fields: DropID, Dropname, SiteID.
These two tables are connected in a One-to-Many relationship.
I got a form with two combo's . I want to select "SiteId" from the first combo and based on the selection i do in the first combo i want the second combo to just show the relevant data (dropid and dropname) for that "Site".
I got one table named "Site" and one table called "Cutomers".
The database contains alot of other stuff and much of it is in norwegian so im not sure how usefull it would be if i posted the mdb here but if someone think its usefull then i will post it.
I can choose from the combo boxes and it works fine but the connection between the two are not working. Not matter what i choose in combo1 i get all recrods in combo2.
I am trying to find a solution for this many to many relation and combos! I ve managed to do the one-to-many as the Mile-o example but i have trouble getting the same result right on many-to-many relations
as you know access needs us to create an extra table for many-to-many relations! but the example talks about the current an the previous table! how can i have 3 cascading combos with many to many relations to each other???
i also have a fourth but this one is related as one to many with the 3rd!
for more information i have:
Many Cars-to-many Categories of brands of parts Many Categories-to-Many Brands of parts One Brand-to-Many parts
the many parts combo is also a record selector!
In the beginning I had one table of parts with 4 foreign keys then i changed it to the current one with the previous chain of relation ending to parts with one foreign key! is this better???
Thanx! I hope I made my proble as clear as i could :)
Can anyone kindly help me with the attached database. I need to synchronize 3 combo boxes. based on the choice made in the previous box. I have seen it done before using text fields but not using numeric fields as in my case here and without using queries.
I have set the RowSource for the 3 boxes on the OpenForm event and have removed all my code attempts.
I am new at programming in Access and I am writing a database for our church. I have 2 tables, one called “Donators” and the other “Donations”. In the Donators table I have their Last Name and First Name along with their address etc. In the Donations form I use a combo for the Last Name and a separate combo for the First Name. I did this so the person entering data doesn’t have to use a mouse but simply tab and type. Both combos are bound to the ID number. Without using a cascading combo, all First Names appear not just the ones relating to the Last Name. I checked the examples on cascading combos and tried them but without success. I could really use someone’s help. Thanks.
I am making a Invoice DB. I have made a combo for Suppliers which takes data from SuppliersTable and data is recorded in InvoiceTable. I have another Combo for Services which takes data from SuppliersTable and records up in InvoiceTable. And I have another field (PaymentPeriod) dependent on ServiceCombo
I want to make Services Combo dependent on Supliers.
How can I do that?
Combo 1 = SuppliersCombo SuppliersTABLE: suppliers data origin Field: SupplierMaster InvoiceTable: supplier data destination Field: Supplier
Combo 2= ServiceCombo dependent on Suppliers Combo SuppliersTABLE: suppliers data origin Field: ServiceMaster InvoiceTable: service data destination Field: Service
Form Field: PaymentPeriod dependent on ServiceCombo SuppliersTABLE: suppliers data origin Field: PaymentPeriodMaster InvoiceTable: paymentperiod data destination Field: paymentperiod
How can I do these dependent?
I hope I explainned myself clearly, I am access first timer.
Hi There, I know this subject has been beaten to death, but I have searched the forum and cannot find a post relating to my particular problem. I have three cascading combos on a subform that work fine and dandy when I open the subform on it's own, but when I open the main form that the subform is embedded into, I get the following message [IMG]cascade[/IMG] I know I am missing something simple. Any advice would be most welcome.
I have created 2 tables TBL_ObjectList contains data for objects in the night sky e.g. IDMessier_IDNGC_IDCommon_Name Type DistanceConstellation Apparent_Mag 1M1NGC 1952Crab NebulaSupernova remnant6.3Taurus9
TBL_Observations contains observing data where the Object field looks up the data in TBL_ObjectList e.g. ObservationIDObjectDateNotes 1M122/11/2007blah blah
I created a form FRM_Observations with a combo box to select the object e.g. M1 and it fills in the rest of the data for the object in the form.
My question is: How does this then relate to TBL_Observations? When I switch to a new observation record the object selection stays at the one for the previous record.
I know this is probably basic stuff but I just cant see it.
Is there a simple online "how to" for this stuff? as I just cant seem to get to grips with it.
Right i have a project form which has a sub form of location
One project can have many locations
therefore it is nescarry to enter more than one location
Problem is with the cascading combo boxes i have for country to region to sub region, is that you can enter one fine, but if you enter another is deletes the information from the first entry
I have a query about cascading and combo boxes, which I was kindly, advised about previously. However, I’m stuck as to how to cascade using the selections from more than one combo box. Here are the tables involved
What I’m trying to do is create a form to enter downtime incidences and would like the downtime reason to be selected following a series of combo boxes. The first combo box selects the Line on which the downtime has occurred, using this, the next combo box selects the machine. I would like the category selected independently but then need the Downtime Reason selected based on the selections in the machine combo box and the category combo box. This is where I am having the problem.
I can get the machine combo box to display machines dependent on the Line selected and I can get the downtime reasons combo box to display machines dependent on either the machine selected or the category selected, but I don’t know how to get it to do it based on both.
e.g. the category may be mechanical, but there are reasons that are mechanical and specific to each machine.
I've asked this question before, but no one's answered it yet. How do I create a form where I can enter many records for projects (from tblProjects) and associated workstreams (from tblWorkstreams), so that I can select a project from a combo and then pick a workstream from a filtered list?
With help from Colm, I've been able to set up the combo's and get the filter to work, but unfortunately, the Project combo (cboProjectSelect) filters the cboWorkstreamSelect for ALL records! This means that only one project can be selected for ALL records.
The way it's been set up so far, is there is a query which lists Workstream, WorkstreamID and ProjectID, and the criteria for ProjectID in that query is: [forms]![frmTshtEntry]![frmTshtProj]![cboProjectSelect]. The cboWorkstreamSelect combo is then based on this query.
I am really stuck on this, and any help would be greatly appreciated!
I have used cascading combos for Make and Model. They work fine. I have set up tblMake as follows: ID Make I have make tblModel as follows: ID Make Model I use these cascading combos on a form. The data from this form goes into the "Cars" table. I have set the "Column Bound", "Width" etc. to show the name of the car, not the number. However, I have created a search form. This uses a SELECT...... case in the Row Source. The details of each car are shown in a unbound listbox. This select case is supposed to show "Make" and "Model", which it does, however - they are numbers!!! Please can anyone let me know how to change it so it shows the actual names of the car. Thank you
and I am creating a form to view the items currently on consignment with the customer. I have the main form 'Consignment' that holds the CustomerID, ConsignID, DateStarted, Employee (SalesPerson), Inventory Interval, and Closed (Y/N)... The subform lists in datasheet view the records in form 'ConsignDetails' that have the same ConsignID. The controls on the subform are :
ProductID UnitPrice Quantity Color Size
The ProductID is selected in a combobox from all products. The UnitPrice defaults to a DLookup() from the products table based on the ProductID, but can be changed and stored. The Quantity is a manual entry field. Color and Size are both supplier-dependent fields, in other words, the supplier of the product has unique Size and/or color codes or descriptions. I have no problem creating a combobox either in the AfterUpdate event of the ProductID or in the MouseDown event of the Color or Size field to limit the drop-down list to only those Colors/Sizes from the CompanyColors / CompanySizes tables with the same SupplierID as the Product in the first control.
So far so good, but here is where I am beating my head against the wall. Every time I choose a product from a different supplier, the Color and Size controls display ONLY the items from the current Supplier, not the items from the Supplier of the Product on their individual records. I have seen ways to make the combo popluate a locked textbox, hide the combo, and display only the text, but in a data entry application the user will be primarily on the keyboard, and the solutions seem to make it almost impossible to do without using the mouse over a continuous form.
I am using Access 2002 (ver 10.6501.6735) SP3 to create an ADP using MSDE to link to SQL7 tables....
Any help will be appreciated, I have spent almost two weeks trying different approaches and may be too close to the forest to see the trees.
OK ive got my 2 vaguely working combos which select the surgery, and the staff.
On the same form I want a couple of tickboxes which show for example, whether a person attended the course, if they had to pay etc (all yes/no answers).
How do I get the tickbox to update? i have tried to requery it but nothing happens, it just stays as what the last thing done to it was.
Ive got my combos working fine now (thanks to all you kind folk on this forum!) but now that I have opened the main form (in which the combo box form is nested), once I have selected an item in the first one, and then click on the 2nd combo, a parameter box comes up saying "Forms!Training Record!Course_title_combo" and wants a value.
I cant see why this doesnt work when the form is nested, any ideas?
Hello to all ! I have this db where i wantto include 4 and if possible 5 cascading combos where the user can select records from a table and view them in a subform which is in datasheet view. All is going well until i try to add the 4th combo.Then when i select the 4th combos selection the subform displays nothing. If someone could point me to the right direction i would be most thankful. I have attached the db. Thx for all replies :)
I have two unbound cascading combo boxes on a form that limit the data for a stored field.
I am designing this as a subform to show software installed on a PC (hence the need to have a continuous form). As the manufacturer, software package and edition are already stored in my database, I am storing only the ID of the edition to limit duplicating data.
I would like to show the values in the cascading combos that relate to the edition ID stored as well as filtering the edition ID using the combo boxes (i guess a filter and a reverse lookup)
Please see attached pic. First record was entered as Microsoft Autoroute. New record for Manufacturer Frontier, change the previous records combos.
I'm trying to filter a combo based on the selection in another combo.The twist is that I need the row source of both combos to include an "*", "(All)" selection, as I am using these combos to filter a listbox. When I add the Union query with "*", "(All)", the row source in the 2nd combo is ignoring the where clause.
After making a selection in the Comp combo, the Emp combo should be filtered. It works with no Union in the row source, but does not work with the Union in the row source.
Hello, i'm not sure how to write a query, maybe it'll take VBA function to accomplish this, but I need to display the results for all invoices for an item.
Little background: 1. This set of invoices are of only one particular product line as it's this product line that needs this special handling. These are Guitar orders. 2. Each guitar item can have option items on the same invoice. So basically these are all considered item numbers. 3. The guitar starts as the bare / basic guitar. The customer can choose to select one or many options for a custom guitar. 4. These orders will need to have special guitar programming codes that need to be entered into their guitar programming machines. Call these "Codes". 5. Depending on the option items for the various guitar items, the Codes could vary. 6. Need to be able to display ONLY the Codes specific to the guitar or guitar and option combinations.
I have several tables: 1. Guitar for all the guitar items 2. Options for all the option items 3. ProgrammingCodes for all the programming Codes 4. ProgramCodes for creating the above combinations with a field named ComboID. 5. GuitarHeader - the invoice number and guitar item 6. GuitarDetails - the invoice number and option item (invoice number to invoicenumber link to the GuitarHeader)
Then there's a main form and a sub-form for the end-user (guitar programmer). 1. The main form is the Guitar items 2. The sub-form is the ProgramCodes fields this form is used for this end-user select the Guitar and options (where necessary) and select the Codes and enter the ComboID for all.
for instance: These are all the possible codes for AE185. AND depending on the Options selected for AE185 on invoices, the Codes will differ. The ComboID is the differentiator. Code:GuitarOptionCodeComboIDAE185 185RR 1AE185 186RHT1AE185 187RT 1AE18538185RR2AE18538186RHT2AE18538187RT382AE185BB185RR3AE185BB186RHT3AE185BB188RT-B3AE18538185RR4AE185BB185RR4AE18538186RHT4AE185BB186RHT4AE18538188RT38B 4AE185BB188RT38B 4
so for the Codes that repeats in the ComboID is only because the Option(s) also requires that Code as well as the other Codes.
for instance, if the invoice ONLY has Option 38 from the Options defined for Codes, then the result would be:
Code:Invoice Guitar Codes123456 AE185 185RR 186RHT 187RT38 <-- say this invoice had Option 38 that was the only match234567 AE185 185RR 186RHT 188RT-B <-- because BB was the only one that matches345678 AE185 185RR 186RHT 188RT38B <-- because both 38 & BB matches
So guess the question is how do I write a query or function (VBA) to be used in a query to get the results for ONLY the matching options so the correct codes for just these options are displaying?
It's difficult to me in figuring that out. how to make sure that the result does not show the ALL the codes that match but ONLY the codes in the combinations. Again, hence the reason why I got to the point of having Combination IDs to differentiate that.
hope I made sense here. Not sure how else to ask the question other then to try and provide examples let me know how else to explain if this is not helping.
Combo A pulls from a query which gets surgery address1, address2, and surgeryID. It displays only the first 2 fields.
Combo B gets info from a query getting staff firstname, surname, title, staffID and surgeryID, and shows the first 3 fields.
I have the following code in the afterupdate of box A (surgery_combo)
Private Sub surgery_combo_AfterUpdate() staff_combo = 0 staff_combo.Requery End Sub
HERE IS THE PROBLEM:
The queries seem to work fine, as box B displays the staff that work at each surgery. However on selecting a staff member, you can only SELECT the ones who have a salutation (mr/mrs etc) in the first column. And when you DO select this - the combo shows a most unhelpful "Mr" whereas I want the name there.
How do I change the column that the combo displays once selected?
Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.
I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.
I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.
The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.
The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.
On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.
On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.
So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.
(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)
I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.
I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??
how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.
