Forms :: Cascade Combos With Union

Sep 19, 2014

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.

View Replies

Please Help! - Filtering Combos On Forms

Nov 22, 2004

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!

Sunil

View 14 Replies View Related

Cascading Combos On Continous Forms

May 12, 2006

Hi Guys,

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.

Thanks for you help

Ben

View 4 Replies View Related

Forms :: Combos With Tens Of Thousands Of Records

Aug 27, 2014

I'm trying to follow Allen Browne's - Combos with Tens of Thousands of Records [URL] ....

However, I keep getting the error...

Compile Error:
Invalid use of Me keyword
(This being a new module)

That's how it shows in his code (the use of me.comboname.rowsource) but it's not working for me.

View 7 Replies View Related

Forms :: Making Cascade Combobox With 4 Comboboxes?

Dec 2, 2013

I want to make a form where i have 4 comboboxes in a cscade combobox thing.

I already made 4 tables with info.

- My first table contains devices:

- ApparaatID (Primairy key)
- Apparaat(with 4 entries)

- My second table contains if it is hardware or software:

- TypeID (Primairy key)
- ApparaatID
- Type (where I entered hardware and software in 2 different entries)

- The thirt table contains operating systems:

- OSID (Primairy key)
- ApparaatID
- TypeID
- OS_versie (where I entered all the OS I want to enter)

Now I made a form I called problemen with 4 comboboxes.

- cboApparaat
- cboType
- cboOS
- cboProbleem

1) What I want is that when you select device 1 and 4 that cboType can select both hardware and software but with device 2 and 3 you can only select software.

2) If you have selected software is cboType I want you to be able to select 1 of the 11 OS I have pre-entered in the table.

3) That you get specific problems with the previous made choices. For example if you select Hardware in cboType, thta you only get problems with hardware to select from and the same with software and OS.

4) I want a textbox, that will contain the solution of the problem you selected and that if there and several solutions that you get all of them at once.

View 13 Replies View Related

Forms :: Auto Fill In A Text Box If Value Selected From Last Of 4 Cascade Comboboxes

Dec 9, 2013

I use access 2013.

1) How to auto fill in a text box if you select a value from the last of 4 cascade comboboxes.

I have 4 comboboxes where

1 = Apparaat - cboApparaat
2 = Type - cboType
3 = OS - cboOS
4 = Probleem - cboProbleem

With all 4 comboboxes I have the vba code Me.cbo[name combobox].Requery

If I select the last combobox, cboProbeem. I want the textbox underneath to automaticly fill in the solution of that problem. I already tried to use the following vba code

Me.Oplossing = Me.cboProbleem.Column(5)

But it does not work.

2) I want to make a form for customers, where I can fill in customer info, device info and date when there contract started. Now I want to use SUM to fill in the end date of there contract.

View 3 Replies View Related

Queries :: UNION / UNION ALL Query Crashed Access

Oct 24, 2013

I'm having a problem with a UNION / UNION ALL query.It seems there is a application crash fault when running the query that MS are aware of and have issued a hot fix. Unfortunately it will take my IT dept some time to check and install the hot fix If they agree to do it at all.

Problem signature:
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 12.0.6606.1000

[code]...

View 1 Replies View Related

Modules & VBA :: Opening Forms Based On Results Of Union All

Apr 13, 2015

I have some code in my database that will open a form based on the result of , I think, a union query.

Private Sub resultbox_DblClick(Cancel As Integer)

'Open report based on the ID from resultbox listbox

DoCmd.OpenReport "ResultsStan", acViewReport, , "[ID] = " & Me.resultbox, , acDialog
'End If
End sub

What I need to do is open one of a number of reports. The report that needs to be opened depends on another value that is passed from the union query - DOCCAT

Being still a bit of a novice I tried...

'If "[DOCCAT]= " & Me.resultbox Like "Standards" Then
DoCmd.OpenReport "ResultsStan", acViewReport, , "[ID] = " & Me.resultbox, , acDialog
'End If

Needless to say it didn't work.

View 6 Replies View Related

Cascade Deletes

Jun 13, 2007

I want to use Cascade Delete on a main table that has relationships with a few tables. The type of these relationships are weak and the delete will work perfectly I think. But, I am concerned about how I can only delete the FK from one of the tables because it contains a non-prime FK.

For example: Customer buys House. So Customer PK is in House as FK.
If I delete customer, I don't want house deleted. Is there anyway that is native to access in how I can only delete the FK from tblHouse without deleting the house record.

View 8 Replies View Related

Define Cascade From SQL

Oct 12, 2004

Hi, all... :)
I need to create cascade relationship on fly.
I've succeeded to create the relationship by:
ALTER TABLE tName ADD CONSTRAINT fk_id FOREIGN KEY(ID) REFERENCES tPrimary(ID)
and even succeeded to check the referential integrity by:
ALTER TABLE tName ADD CONSTRAINT fk_id FOREIGN KEY(ID) REFERENCES tPrimary(ID) CASCADE

The real problem comes when i am trying to enforce the cascades. I do not find any expression doing it.

the standarts of sql: on update cascade
or
of sql server: on update cascade go
just don't work in access :(

Thankful ahead

View 1 Replies View Related

Cascading Combos On Many-to-many

Mar 11, 2005

Hi!

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 :)

Please Heeeeeeeeeeeeeeeeelp :) :)

View 3 Replies View Related

3 Cascading Combos

Sep 28, 2005

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.

Thanks for your help

View 3 Replies View Related

2 Combos In A Form

Mar 1, 2006

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.

Can anyone help?

wbr
Espen

View 4 Replies View Related

Cascading Combos

Apr 2, 2006

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.

View 3 Replies View Related

Depending Combos

Aug 16, 2006

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.

View 14 Replies View Related

Annoying Combos

May 27, 2006

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.

View 2 Replies View Related

Forms :: Error 13 When Setting Rowsource Of Combobox Using Union Query

Jan 18, 2014

I am trying to design an unbound combobox whose rowsource can be dynamically set based on a union query in order to search 1000's of names returning each name that contains a user defined string. The search does not start until the user defined string reaches 3 characters in length.

There are more details in the attachment but basically the vba code I used all saves OK in the vba editor but I get a runtime error 13 type mismatch when the code attempts to utilise the query to populate the rowsource of the combobox.

View 10 Replies View Related

Combos And Tables - I'm Confused!

Dec 7, 2007

Ok I just cant get my head round this stuff!

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.

Many thanks for your patience :P

Paul
(No scripting knowledge)

View 12 Replies View Related

Cascade-To-Null Foreign Key

Oct 19, 2007

Hello,

I'm using Allen Brownes very helpful cascade-to-null relations (http://allenbrowne.com/ser-64.html) code in my database project, but there comes problems whit a foreign key and null values, cause foreign key shouldn't be null. Is there anyone else using this method with relational tables? What I should do to make this work?

All hints and tips are welcome and approciated, thanks on advantage. =)

- IpeXeuS

View 14 Replies View Related

Cascading Combos With Many Entries

Feb 25, 2005

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

can anyone fix this please

i have uploaded a sample

View 4 Replies View Related

Cascade Combo - 3 Tiers?

Oct 14, 2005

Hello,

I followed the Microsoft guide detailing how to set up two cascading combo boxes. I would like to add a third box to the cascade. I have tried making some assumptions based on the code in the example but I can't get it to work.

I have three queries set up; qryBusiness, qryBusinessUnit and qryLocation.

I am using one form; frmToolInfo.

I have three combo set up; cboBusiness, cboBusinessUnit and cboLocation.

I amended my code to the following:

Private Sub cboBusiness_AfterUpdate ()
Me!cboBusinessUnit.Requery
Me!cboBusinessUnit.SetFocus
End Sub

Private Sub cboBusinessUnit_AfterUpdate ()
Me!cboLocation.Requery
Me!cboLocation.SetFocus
End Sub

Private Sub Form Current ()
Me!cboBusinessUnit.Requery
Me!cboLocation.Requery
End Sub

I want to cascade down from Business, to Business Unit to Location.

Can anyone advise me as to what I've done wrong here.

Thanks.

View 3 Replies View Related

Multiple Cascading Combos

Mar 3, 2006

Hi All,

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

tblLine
fld LineID (PK)
LineDesc

tblMachine
MachineID
MachineDesc

tblLine_Machine
LineMachineID (PK)
LineMachineDesc
LineID (FK)
MachineID (FK)

tblCategory
DTCategoryID (PK)
DTCategoryDesc

tblDTReason
DTReasonID (PK)
DTReasonDesc
tblCat_Mach_Reason
CatReasonID (PK)
DTCategoryID (FK)
MachineID (FK)
DTReasonID (FK)

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.

Any help with this would be most appreciated.

Regards

Keji

View 2 Replies View Related

Cascading Combos Issue

Feb 9, 2005

Hi,I shall be grateful for any help.

My problem

Tables:
Cars
Customer
Invoice
TblMake
Tbl Model

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

View 3 Replies View Related

Cascade Combo Boxes

May 25, 2005

How do I create Related Cascade Combo boxes by CD Group and Name of CD
To only display the records from NAme of CD related to the CD Group

Or to to a ABC and click on Artist and then click on the list with Name of CD

Someone else is wonderinf a friend of mine in Acess you can create a inventory Database to display records related like Name of Furniture Brand, Item and Search ny Last Name to see if they bought that Item

View 3 Replies View Related

Cascade Combo Problem

Oct 20, 2005

Hello,

I have a question on cascade combos.

I have a form named Welcome and would like to add two cascade combo boxes.

The first combo, named cbolist get's its data from a table named QUERIES which has three fields:

ID
QUERYNAME
QUERYDESCRIPTION

cbolist displays the records contained in the QUERYDESCRIPTION field which are basically the name of other tables of my database with different records (obviously).

I would like that after selecting a record in the cbolist, the second combo, which I will call cboresult, will populate with all the records of that specific table selected in the cbolist.

Any help with the correct code?
Thanks.

View 2 Replies View Related

Cascade Delete Query

Dec 7, 2006

Hello Friends,

I need some help to crete a query that will delete data in multiple tables.

My database has 5 tables. I store data in a main table and then append the ID and SSN to the other 4 tables.

The main table has also a purge date field that I will use to delete old records.

I use a form with a textbox where I type the starting date from which remove these records.

Is there a way or example I can see on how to remove all records at the same time. I have heard of cascade delete queries but really don't know how to use them.

My idea was to remove from the maintable all records with a date older than the date in txtbox and at the same time remove all records with the same ssn in all the other tables.

Thank you.

View 3 Replies View Related