Over 1 million tech questions and answers.

Solved: Populating memo box which depends on chain for combo boxes

Q: Solved: Populating memo box which depends on chain for combo boxes

Hi,

I know this is probably a rather tiresome query, but I've surfed the net endlessly and not found a solution. I'm attempting to populate a memo box, which depends on user choice from a chain of combo boxes (unbound).

I'm creating a classroom planning/assessment database application (the new Learning Essentials for those involved in Australian Education). The system I'm creating, database-wise, is a little complicated (I am an absolute self-taught beginner, so please be kind and precise with your terminology, explaining where I should find the tools you mention). We have 7 "KLAs", which are each chosen with an "Assessable Element" (depending on the KLA) for each grade, which each act as an umbrella for a number of "Knowledge and Understandings" (each K & U has a descriptor of more than 255 characters. Under each "Knowledge and Understanding" is a dozen or so "Detailed Elements" (that the kids get assessed on). So I have the following hierarchy of tables:

KLA
Assessable Elements
Year (or Grade in America-speak)
Ways of Working (differing and dependent on previous choices)
Knowledge and Understandings (includes the descriptor)
Detailed Elements

Each table is linked in hierarchy to the one above via foreign keys (and sometimes to more than one table above (my description is the simplified version - it's more complicated than that). So you can imaging that the KLAs table is quite small (only 7 records), but the tables get larger as each one lower in the chain is increased to account for grades, categories and more detailed categories towards the bottom.

My fields down to "Knowledge and Understandings" are fine. The problem occurs with the "descriptor" field being truncated on my form. The "Knowledge and Understandings" combo box provides the user with options based on the previous 4 choices, but it is only really a 'title' field (because I certainly couldn't include the descriptor for it within a combo box). Next to this combo box is a text box that displays the contents on a memo field (from the same table) depending on this choice. It is this descriptor field that is being truncated.

All the fields are 'unbound' as they all depend on choice of the previous field (and there are 'duplicate' records as some grades have identical choices), then a search is carried out on the next table using the Primary and Foreign Keys to retrieve 'after_update':

Private Sub cboKnowledgeAndUnderstanding_AfterUpdate() Me.txtKnowledgeDescriptor = Null Me.txtKnowledgeDescriptor = Me.cboKnowledgeAndUnderstanding.Column(4) Me.cboDetailedElement.Requery
End Sub

My Row Source Type is Table/Query
My Row Source says:

SELECT [Knowledge And Understandings].KnowledgeAndUnderstandingsID, [Knowledge And Understandings].KnowledgeAndUnderstandingsName, [Knowledge And Understandings].KLAIDF, [Knowledge And Understandings].ByEndOfYear, [Knowledge And Understandings].KnowledgeDescriptor
FROM [Knowledge And Understandings]
WHERE ((([Knowledge And Understandings].KLAIDF)=[Forms]![Planning Development]![cboKLA]) AND (([Knowledge And Understandings].ByEndOfYear)=[Forms]![Planning Development]![cboByEndofYear]));

My format fields (both on the form and table) are empty. I can't find where there is any property called "Unique Value" either on my form or table (I read that this could be a problem). As you can see I have not the word DISTINCT anywhere within my query. And I don't have GROUP BY in my SQL statement, nor am I sorting or manipulating the results. I have checked out Allen Browne's web page and, unless I am misunderstanding something (highly likely), none of those suggestions are the problem.

These tables will not require editing in the finished product - they are simply to be stored as ID numbers in a new database as the pillars upon which to create planning. The descriptor, in fact, is disabled and for display purposes only. In fact all of these tables need only ever be read only.

As a NOOB, I've probably made some silly little error, or perhaps I am going about this using the wrong strategy?? I've sort of self taught myself solely on the Access help (rather useless!) and google (nearly always a winner! - except for this time). What is the problem with my descriptor field? Why is it truncated? I'm happy to upload my Access file if need be - only it's almost 10 MB...

RELEVANCY SCORE 200
Preferred Solution: Solved: Populating memo box which depends on chain for combo boxes

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Populating memo box which depends on chain for combo boxes

Read other 16 answers
RELEVANCY SCORE 80.4

Hello, I have two list boxes on a form, which are synchronized so that the list that appears in the second one (listSub) is dependent on which item is selected in the first one (listTop). Each is associated with underlying tables: tblBenefitTopCategories and tblBenefitSubCategories.

What I'd like to do is allow the user to add options to either of these lists using one of two text boxes, each under its associated list box. After the user is done entering the new value, they hit the Add button, and the list box is re-queried so the new value shoes up in the box. The value needs to be entered in the underlying table on which the list is based.

It seems I can only find this kind of tutorial for combo boxes, and append queries only seem to work if I'm pulling from another source, but since the user is defining what's going into the list I'm stuck, so I'd really appreciate any help.

Let me know if you need to know the names of the tables, columns, queries, objects, etc. I'd be happy to provide more info.

Thanks in advance!
 

A:Solved: Populating a List Box with Text Boxes

Read other 12 answers
RELEVANCY SCORE 78.8

I have a form that has a few combo boxes. The list presented in the 2nd combo box is determined by the input in the first combo box. This works. Now I need to have a subform that is populated when all the combo boxes are filled in.
Eg: They choose a line - depending on the line only teams in that line appear in the 2nd combo box drop down. Then they may type in a part number in a text box - but this could be blank - but that's a problem for later.
1. I can get the subform to populate from the entries of the combo box, but only on the NEXT attempt. The first time I go into the form and populate the combo boxes nothing happens in the subform. If I close the form and go back into it, the subform is populated with the information that was previously in the combo boxes - the combo boxes are blank on going into the form a second time. I have this subform set up as the source object being a query. There is an event setting - On enter and on exit. Should I be using one of those to get it to populate only when the current info is entered?
 

A:Solved: Populating a subform from combo box entries

Read other 12 answers
RELEVANCY SCORE 78

Current design displays combo box w/ sort by ADP Company and Location Number. I have two combo boxes. The first on list all the ADP Companies located in table, the second list Location Numbers depending on which ADP Company is selected from the first combo box.

I am trying to get a couple text boxes to populate based on what has been selected using the two combo boxes located on the screen. I am running into trouble with a DLookup function and Im not exactly sure why. Here is my DLookup function:
=DLookUp("[BranchNumber]","[tblAllADPCoCodes]","[ADPCompany]= '" & [cboADPCompany] & "' And [LocationNumber]= '" & [cboLocationNo] & "'")
ADP Company combo box
Then
Location Number [with in ADP Company] combo box
Then
List Branch Number [based on selected ADP Company & Location Number] text box
Then
List Description [based on selected ADP Company & Location Number] text box
 

A:Solved: Populating Text box based on combo box selection

The combo boxes also need to have the fields included in the select statement that you want to populate each textbox. Set the number of columns to the number of columns in the query and set the column widths for the fields you do not want to show to zero. Set the after update event for the combo to something like Me.TextBox.Value = Me.Combo1.Column(Index# of column u want)
 

Read other 1 answers
RELEVANCY SCORE 70

Ok, this is driving me crazy. I have scanned with several different antivirus software including Avira, AVG, Bitdefender, and Housecall. All came back clean except for AVG found the following two items: Virus Win32/Heur and Trojan Dropper.Agent.AGTB. Both were deleted by AVG. I thought everything was good, but no. The virus or whatever it is has come back within 20 minutes.

What happens is that 1's or 0's (zeroes) or 8's will populate any text entry box or even a blank word document. The search box on google, the web address entry box, the start menu, any seach data entry box. The only way I can get rid of it is to shut the computer down and then power it back up. When the logon box comes up it will sometimes be populating text as well. I can then choose "switch user" and the entry box for the computer's password will come back and act normal. The computer will act normal for a little while and then all of a sudden, I'll start getting 0's or 1's or 2's or other numbers populating again.

I have also run Malwarebytes and Spybot. Both came back clean.

Here is my log file from Hijackthis:

Logfile of Trend Micro HijackThis v2.0.4
Scan saved at 11:06:00 PM, on 9/5/2011
Platform: Windows 7 SP1 (WinNT 6.00.3505)
MSIE: Internet Explorer v8.00 (8.00.7601.17514)
Boot mode: Normal

Running processes:
C:\Program Files (x86)\Switcher\Switcher.exe
C:\Program Files (x86)\Spybot - Search & Destroy\TeaTimer.exe
C:\Program Files (x86)\Ad... Read more

A:Numbers populating in all text entry boxes

Read other 9 answers
RELEVANCY SCORE 69.6

Hi,

I have a combo box on a form that gets it's data from "tblJobs"

In the table i have a text field that stores a "Y" or a "N" what i want is if the job has a "Y" i would like the job to be visible in the combo on the form, but if the job has a "N" i dont want it to be in the combo.

Is this possible?

Thanks.
 

A:Solved: Access Combo Boxes

Read other 12 answers
RELEVANCY SCORE 69.6

Ok this is related to my last question about Combo Boxes.

I figure it is probley going to work similar, but I am not sure how I can get this to work.

Is it possible, actually more so how would I go about changing the list in a combo box based on the selection of an option in another combo box.

i.e.

4 Differnt Combo Boxes.

1- Office
2 - Rule
3 - email address
4 - fax numbers.

The first box, lets say I would select Austin, when I select Austin, it would give me the differnt rules for Austin, then once I selected the rule, it would give me a list of email address assosicated with that rule, and finally when I select the email address, it would give me a list of fax number assosicated with the email address?

I figured its it going to work very similar to the way I updated the, working with the "After update" but I am not sure how to point the next box to differnt lists.

I hope I am making myself clear as to what I am asking form.

Thanx in advance.
 

A:Solved: Access - Combo Boxes

Here's a couple of great sites dealing with your question, which is both a procedural question and a referencing question:
FAQ: How can I filter one combobox based on another combobox selection?
Refer to Form and Subform properties and controls
HTH, if reading those doesn't answer your questions post back.

chris.
 

Read other 3 answers
RELEVANCY SCORE 68.8

Hi, say i have 2 combo boxes

1. Make of car
2. Model of car

How can i get combo 2 to display the results of a certain make of vehicle?

Any help will be appreciated.
 

A:Solved: Access 2003 Combo Boxes

Read other 8 answers
RELEVANCY SCORE 68

I have a database for tracking expenses. In the form I am using I have several fields populated by combo boxes. When I type in a entry not in the combo box drop down list I allow it to be entered in the field anyway. I want to add these entries to the combo box drop down list but I am not sure how to do it. I think I need to write an expression for a event procedure but I can't seem to grasp how to do it. Please help me.
 

A:Solved: Access 2000 combo boxes-updateing

The way that I do this is to have the combo based on a table and query. I then add the new value to the table and requery the combo. I use the combo's Double click event procedure to open a form based on the combo's table/query in add mode and add the new value there.
Want me to post an example?
 

Read other 3 answers
RELEVANCY SCORE 68

Hi Everybody! Windows 2000 & XP OS; MS Office Pro 2002 & 2003
I have a customer database in Access 2003. There are 2 forms that I will briefly explain.

Form 1: Student’s Information
Has 2 combo boxes (1 for “Division”; 1 for “Program&#8221
The Program combo box selections is based on the selection of Division combo box
This form works fine…it’s a basic form

Form 2: Employers
Same combo boxes but titled: (1 for “Industry”; 1 for “Department&#8221 - Division & Industry are the same; Program and Department are the same.
This form has several sub-forms. Only one sub-form has the same combo boxes as form 1.
The combo boxes work fine in the sub-form alone. However, when placed in the main form (Employer) and I execute the main form, The following message box appears:

“Enter Parameter Value”
Forms!frmJob Order Form!Industry

This is the query that is in the RowSource property control of “Department”

And once I open the form “Employer”, my combo boxes won’t work. When I make a selection in the “Industry” field, the same “Enter Parameter Value” box appears.

Where “frmJob Order Form” is the sub-form that contains the combo boxes.

Will someone pleeeeeease tell me what I need to do to solve this problem? As I stated, it works fine until it&... Read more

A:Solved: Combo Boxes in subforms in Main forms

Read other 9 answers
RELEVANCY SCORE 68

Hi,

I'm using Access 2010 and struggling to get the numbers in a combo box to display in the right format:
The source table holds a series of numbers (years) in the Double, fixed, 0 decimal places format and displays them correctly, 2010,2011 etc. When I use this table as the source for a combo box lookup in a form the numbers are also stored correctly but when i click on the combo box to choose a number they are all displayed as 2010.00, 2011.00 etc.

I can't see any way of removing those decimal places in the drop-down list displayed but there must surely be some really easy/obvious thing that I am overlooking - can anyone help? Thanks.

Richard
 

A:Solved: Access: Number formatting in combo boxes

I would set the Field type in the table to "Long Integer", which is only whole numbers with no decimal places at all.
 

Read other 2 answers
RELEVANCY SCORE 68

Hi Everybody! Windows 2000 & XP OS; MS Office Pro 2002 & 2003
I have a customer database in Access 2003. There are 2 forms that I will briefly explain.

Form 1: Student’s Information
Has 2 combo boxes (1 for “Division”; 1 for “Program&#8221
The Program combo box selections is based on the selection of Division combo box
This form works fine…it’s a basic form

Form 2: Employers
Same combo boxes but titled: (1 for “Industry”; 1 for “Department&#8221
This form has several sub-forms. Only one sub-form has the same combo boxes as form 1.
The combo boxes work fine in the sub-form alone. However, when placed in the main form (Employer) and I execute the main form, The following message box appears:

“Enter Parameter Value”
Forms!frmJob Order Form!Industry

This is the query that is in the RowSource property control of “Department”

And once I open the form “Employer”, my combo boxes won’t work. When I make a selection in the “Industry” field, the same “Enter Parameter Value” box appears.

Where “frmJob Order Form” is the sub-form that contains the combo boxes.

Division & Industry are the same; Program and Department are the same.

Will someone pleeeeeease tell me what I need to do to solve this problem? As I stated, it works fine until it&... Read more

A:Solved: Combo Boxes in subforms in Main forms

This problem is now solved.
Thanks to such a FAST response in this! This is the BEST forum to be a member of!!!
Many thanks to ALL OF YOU!!!!!!
 

Read other 1 answers
RELEVANCY SCORE 68

Clearly at beginner level on Access...

Need to create combo boxes on a form where just 1 is initially displayed, then when an option is selected... a second combo box appears, etc. - all feeding data back to the same column/table.

e.g. What did you have to drink this morning? (tea, coffee, oj, water,...)
Once oj is selected, a new combo appears beneath the first to allow for further selection - if user had coffee, water & oj.
 

A:Solved: Access - Display New Combo Boxes Automatically

In each combo box's "after update" event procedure enter -
if comboboxname.column(number) = "your selection criteria goes here" then
comboboxname.visible = true
where comboboxname is the name of the next combo you want to appear.
In the form's "On current" event procedure set all but the first combos as
comboboxname.visible = false
to make them invisible.
The "number" in the brackets represents the column that holds the selection you want to match.
 

Read other 1 answers
RELEVANCY SCORE 68

Ok I have been struggling on this one all morning.

What I am tring to do is this.

I have a combo box, when the name is selected in the combo box, I would like it to auto populate the Addres/City/State/Zip of the persons name.
 

A:Solved: Access - Combo Boxes and Text Fields

Read other 16 answers
RELEVANCY SCORE 67.2

I have been able to get a combo box to control and enter in data into 1 text box, but I need it to do the same with 2 more text boxes.

This is what I have to control my first text box.

Private Sub List25_AfterUpdate()
Me!Text67 = Me!List25.Column(1)
End Sub

The next boxes need to be controlled the same way on update, but there is criteria they need to look at to determine if the data should be seen in the next 2 text boxes.

Column 5's data is either going to be a "B" or "M" - I only want this to show if it's a "B" and then that makes the next tex box (Column 4)appear also if it's a "B"

Please forgive me I am very new to this and I am just trying to write a pretty simple database.
Let me know if I am missing any information.
 

A:Solved: Access Form Combo box that controls several text boxes

Read other 10 answers
RELEVANCY SCORE 66

Hi, I have two list boxes, one named listRegion and one named listCountry. When you click a region from the first list, I need the countries to show up in the second one (based on the tblProjects table).

tblProjects and has fields called Region (text) and Country (text) to hold the region and country names. The reason they're formatted as text is because I want to avoid linking to ID numbers if possible for a reason that we don't need to go into here. Don't worry, there's no chance they won't be unique.

I've gotten this to work in the past using code like this:

Private Sub listRegion_AfterUpdate()
' Update the row source of the listCountry list box
' when the user makes a selection in the listRegion
' list box.
Me.listCountry.RowSource = "SELECT Country FROM" & _
" tblProjects WHERE Region = " & _
Me.listRegion & _
" ORDER BY Country"
End Sub

But now when I click a value on the listRegion list box, it prompts me for a value (for example, if I click Africa, it asks me to enter a value for Africa). Can Access not pass non-numerical data from one listbox to the other? Am I stuck using IDs?
 

A:Solved: Access 2007 - linking combo/list boxes with text values instead of ID#?

Access can pass anything you like, but you have to tell it to pass the correct thing.
For instance if you use the Combo box wizard to create a combo it invariably uses 2 fields/columns, the ID and the text.
If you refer to Me.listRegion and it is using the ID as the first Column, that is what you get. not the text, you can use the Column funtion to specify which column you want Access to use, starting with column 1 as 0 so the ID would be
Me.listRegion.Column(0)
and the text would be
Me.listRegion.Column(1)

However, Access does not like the Columns reference in queries and will quite often ignore or mis-interpret them, so if that happens it would be safer to set the value to a hidden dummy text field which can be referred to in the query.
 

Read other 3 answers
RELEVANCY SCORE 65.2

Hello,
I am trying to update three Combo boxes based on other Combo Boxes.
I have Product Group, Product and Product Type.
When I select PG, I want a list in Product that is associated with the PG. And once P is selected, I want a list in PT that is associated with P.
Here is my code below but it is not working..
Can someone help.
Thank you,
Stephen
Private Sub Category_AfterUpdate()
Me.Product = Null
Me.Product.Requery
Me.Product = Me.Product.ItemData(0)
End Sub
Private Sub Form_Current()
Me.Product.Requery
End Sub
Private Sub Form_Load()
Me.Category = Me.Category.ItemData(0)
Call Category_AfterUpdate
End Sub
Private Sub Product_Change()
Me.Type = Null
Me.Type.Requery
Me.Type = Me.Type.ItemData(0)
End Sub
Private Sub Form_New()
Me.Type.Requery
End Sub
Private Sub Form_New()
Me.Product = Me.Product.ItemData(0)
Call Product_Change
End Sub
 

A:Basing One Combo Box on Two Other Combo Boxes

Read other 8 answers
RELEVANCY SCORE 60.8

Hi,

I have got two cascading combo boxes. The second box is depedent on the data in the first box. Is there a way that I can have an option in the second box that is Null? For instance if I just want to query on the first combo box?
 

A:Combo Boxes

Read other 9 answers
RELEVANCY SCORE 60

I am trying to set up a form thart uses a combo box to select a name from a table and will then put the correct address details in the boxes underneath automatically......help!
 

A:Access Combo boxes

Create your form.

In the header of the form, drag a combobox from the control toolbox (you may need to "turn the control toolbox on").

The wizard should take over from that point and you want the one that allows you to "look up a value to display in the form" or something like that is what it says.

If the wizard doesn't kick in, I'd close out of all of it, get my disk out and reinstall Office. A typical install of Office does not include the wizards---ya believe it??
 

Read other 2 answers
RELEVANCY SCORE 60

I attached a simple example of what I am trying to do in excel. I have a list of 5 names. Then I have a combo box, where the 5 names populate the list.

Here is what I am trying to do. When I pick a name from the combo box, I want it to populate the shaded box on the page.

Is this possible.

Thanks.
 

A:Using Combo Boxes in Excel

Rightclick the box, choose "Format Control". On the Control tab, enter a cell link, e.g. $B$10 (that way the box sits on top of the link & hides it).

Then use a formula in F3 like:

=INDEX(B3:B7,B10,0)

This method requires no macros.

Rgds,
Andy
 

Read other 1 answers
RELEVANCY SCORE 60

I created a form to update a table using a SQL function and I need to have the combo boxes on the form revert to their initial blank state after the table is updated. The combo boxes are created from a query on two other tables. Do I need to set a default state for the combo boxes or is there a seperate function I can call after the table is updated? Seems simple enough considering it took me all day to figure out how to update 3 fields from this form..

TIA guys and gals
 

A:Refreshing combo boxes

Use:
ComboBox1.Clear
Either Before repopulating the ComboBox OR
After the procedure has been completed and you're ready to move on to the next step.

[I used ComboBox1 as default... modify the ComboBox Name to fit the Name that you have set to it.]

Hope This Helps!
 

Read other 1 answers
RELEVANCY SCORE 60

Hi! I am placing a combo box in a form within access, the problem is that when I select the item from the combo box that item is them added to the list in the table that contains the information for the combo box.

i.e. I want the combo box to use the selected item but not add that value to the table, which is creating duplicate data.
 

A:combo boxes in access

Read other 8 answers
RELEVANCY SCORE 60

I have a form with some combo boxes
The form is based on a table
One field is lastname and one is firstname

The row source is based on table/query

The lastname field works fine but the firstname brings in the lastnames
What am I doing wrong
 

Read other answers
RELEVANCY SCORE 60

I'm working on an access project where I must calculate the pay of a contractor for my company. I seperated the contractors into multiple departments, and they are paid according to their rate type (Straight Time, Over Time, Double Time...). I want it set up so that when I select the department and rate type the program selects its rate automatically,

Also I'm looking for a way to find the difference between a period of time (sometimes over 24 hours) accuratley. The way I currently have it set up it's only accurate to the hour, with no decimals.

TIA

-Billy Bob Joe
 

A:Using combo boxes to figure out another one.

Read other 8 answers
RELEVANCY SCORE 59.2

Hi I hope someone can help me with this (might be a bit of a head wrecker though).
I used to work with databases a while back, and have recently returned to working with them. Alas I'm a bit rusty.
My problem, is that I want to create a form that allows admin people to quickly record reported user errors. The object is to record the error and how long it took to resolve the error.

There are 3 categories of error (a,b,c) for 3 different applications (x,y,z). A is a serious error, b is not so serious and c is trivial.

Each error category can have an unlimited number of error descriptions. E.G. a category A error might be a 'system error that requires a rebuild' or a 'corrupt database message, requiring instant repair and server downtime' and so on. (these error descriptions will not necessarily be the same for each application).

On the form, I want the user to be able to select the application (x/y/z) from a drop down menu and then pick the category of error from a dropdown menu (a/b/c). Finally and this is the hard bit (for me anyway), I want the user to get a dropdown of the applicable error descriptions. The descriptions are different according to the application chosen. So the combo box would somehow be able to know what application and categories were chosen and filter the descriptions accordingly. It should also be possible to manually enter a unique error description that doesnt appear on the list in the combo box.

Don't know if this mak... Read more

A:Access 2000 how to use combo boxes?

Read other 6 answers
RELEVANCY SCORE 59.2

Hi Guys, me again...

Still working on my database and combo boxes.

At the moment I have a combo box [SelectReportList] that lists all the available reports to run.
I also have 2 combo boxes [SelectSupplier1] and [SelectSupplier2]that allow the user to select a supplier based on what report is selected in the first combo box. These 2 combo boxes are visible or not depending upon which of the 2 reports in box one are selected. To make the form tidy I have layered the two combo boxes on top of each other. As far as the end user is concerned, if they select a report where they have to choose a supplier, they see the combo box to select the supplier. I know its a bit 'clunky', but for only 2 reports it works.

However, I was hoping that I could replace these 2 combo boxes [SelectSupplier1] and [SelectSupplier2]with just one [SelectSupplier3]that displays the suppliers and runs the relevant report.

i.e.
If the user selects Supplier Report 1, the suppliers are displayed in the new combo box. When the user selects the supplier, Supplier Report 1 is generated.
If the user selects Supplier Report 2, the suppliers are displayed, but when the supplier is selected Supplier Report 2 is generated.

I've been experimenting with Select Case and the RunSQL commands in the code builder but can't find a way to get it to work. I need the code to tell 'it' that whatever is selected in [SelectSupplier3] runs the SQL in the RowSource property for the two reports in ... Read more

A:Access 2010 and Combo boxes again

Karen, a question first, are you using Access Macros or VBA Code?
 

Read other 3 answers
RELEVANCY SCORE 59.2

I am having great problems understanding cascasding combo boxes. Basically, I have 2 fields in 1 table.
CarManu
CarType

I would like in a form if the user selects a specific car manufacturer, they would only be able to select specific cars made by their choice.
As much as I have tried reading over many forums on this, I am getting nowhere. Maybe I need this explained to me as though I am a 2 year old lol.

Can anyone help?

Many thanx
 

A:Cascading Combo Boxes In Access

You are going to need two tables or it will never work correctly and will eventually give you trouble. Make one table for manufacturer's only and onother for the type that has a joined field to the manufacturer's table. Then you will have a one manufacturer to many types relationship. Get that done and the rest is cake.
 

Read other 1 answers
RELEVANCY SCORE 59.2

Hi,

I know how to make a combobox selection populate or filter what you can select from another one. However, i'm not sure how to make this happen automatically.

I've tried putting my code in the afterupdate event of the first combobox, hoping that when i make a selection, the next combobox automatically displays something else.

I've been told that 'requery' may be involved, but really not sure.
Help is appreciated as always.
Lewis
 

A:Access 2007 Combo Boxes

Read other 8 answers
RELEVANCY SCORE 58.8

I have two questions.

First, I have a form that lists approximately 300 physician offices. I then have a subform that lists which physicians are at each office. I created a find button but I am only able to search by office. Is there a way I can search by a specific physician without searching for the office first? It appears that I have to find the office that the physician is located in order to find the physician.

Second, I want to have a list of the physician offices for the data entry people to click (when searching for an office) instead of having to type the actual name of the office. I was thinking of using a combo box, but this would be cumbersome with approximately 300 offices. How else can I list the actual offices without having them to type it into the find box? Access will only recognize an office if it is typed exactly the way it was originally entered. I would also like to add that I am not familiar with writing codes so if this is what I will need to do, I will need some help. Thanks.

Tonya
 

A:Access: Forms/Subforms/Combo Boxes?

Read other 13 answers
RELEVANCY SCORE 58.8

Dear Tech Savy Peeps,

I am in the process of putting together a database for a client that allows them to track several maintenance metrics for alignments, lubrication, inpsections, and the like...

All is progressing well, and for the most part, the coding and the development is going well and I am getting everything I need and passing all the arguments effectively, no worries.

HOWEVER, I am hung up on a small detail, and since this whole DB is made specifically to generate reports, I have a syntax error that I cannot seem to get around. I was wondering if there is any help out there that would either A.) show me my problem, or B.) present an alternative solution to generate the desired result for my report.

I have a Form with various controls that allow the user to select the type of equipment and I can filter by one selection without problems. For example, generate a report for all 100 hp motors. Same for motor types, AC or DC, frame size, bearings, etc.

I have included a set of combo boxes that allow the user to select the Process Line, the Process Section, and the Equipment, to narrow down the search. All of the combo boxes are referenced to static tables to minimize the 'fat fingering' errors.

I want to generate a report with a filter that selects base on a Where clause in a DoCmd.OpenReport format. I just can't get this thing to work with more than one selection.

Here is the code that is causing me problems...

If (ckbxProcessLine.Value = True) And... Read more

A:Filtering with Combo Boxes in Access for Reports

The where and criteria available in the 'DoCmd.OpenReport is a bit limited and not easy to use, it is fine for single items but not more than one.
I use either a Query with criteria rows set for items selected, or VBA generated SQL to replace the query definition or set the Report's Filter based on a string passed using a public variable, you could probably use open args for passing it as well but I like the public variable as it can be used with multiple reports etc.
 

Read other 1 answers
RELEVANCY SCORE 58.8

Hi,

I have to create several forms to develop a database I have been tasked to complete. The problem is that really do not have much experience working with access. To fuel that fire, I am in the military so I can not be sent off for training since it costs money...lol Anyhow, I have been working on a dummy database that I made up just to get the boxes to link. I was able to link two combo boxes, but my issue now lies with linking multiple based off of the choice prior. Can anyone help me? So I can learn and adapt the database I have to create, I made this one simple.

1st Combo box should be a color choice
2nd Combo box should help with a sub color tied to first one
3rd Combo box should tell you what part of area it is located (I would like to add to list, but made it small to be simple)
4th Combo box should tell you top, middle or bottom (I would like to add to this list as well, but kept it simple)

Can anyone please provide me with some rudder steer to get me where I need to get to? I would be most appreciated.

S/F
 

A:Synchronizing several access 2007 combo boxes together

Read other 16 answers
RELEVANCY SCORE 58.8

Hello there

I'm trying to develop a form in access 2007. It's a student grade system. There are at least 4 combo boxes on the main form. The instructor should be able to select the year group(combo box 1), that selection would then filter out the values in the 2nd combo box (say the 2nd combo box is the section of that particular year group Like 7C, 7G etc). The value selected in the 2nd combo box should then filter and select those students(3rd combo box) whose section id corresponds to the selected value in the 2nd combo box. Then the selected student id (3rd combo box) should filter out the registered subjects(4th combo box). Now, i've managed to sync the 1st and 2nd combo boxes. when the year group is selected, the corresponding section is filtered out after update. but i'm not able to sync the 2nd combo box (section) with the student combo box (3rd). if anyone can help me out please. i just can't mange to figure out where i'm going wrong . i've tried applying the same method via vba code, but then that messes up the sync b/w the 1st and 2nd. Please Help.
 

A:How to synchronize more then two combo boxes in access 2007

Qureshisn, you would have got a quicker response if you had posted this on the Business Software Forum.
The simplest way is to refer to the first combo box in the second combo box's SQL Query using the format
Forms![Formname]![Comboname]
or if the first combo sets some kind of ID refer to that ID field instead of the first combo.
 

Read other 2 answers
RELEVANCY SCORE 58.8

I'm trying to figure out how to do the double drop down boxes in Adobe Acrobat Pro X.

For example if I have the first drop down list that says state then I select NC and then another drop down list shows cities that are in NC.
 

Read other answers
RELEVANCY SCORE 58.8

Hi Guys,
Back again....

I'm a bit stuck on getting a report to run.
I used to have a database that the user could select a report using a radio button in an option group. Each option has a corresponding ID number. They could then select the name of a person from a drop down list. When the report was run it would display the report detail for the selected person only.On the OnClick property of the preview button was the following code

This is an extract...
With CodeContextObject

If (SelectReport = 8) Then
'Preview rptCandidateTestsTaken
DoCmd.OpenReport "rptCandidateTestsTaken", acViewPreview, "", Eval("IIf([Forms]![frmReportsDialog]![SelectCandidate] Is Null, """", ""[CandidateID] = Forms![frmReportsDialog]![SelectCandidate]"")")

End If

End With

8 equalled the ID number of the radio button in the option group
SelectReport was the name of the option group
frmReportsDialog was the name of the form containing the option group and other controls, buttons etc.
SelectCandidate was the name of the combo box
CandidateID was the name of the field in the query on which rptCandidateTestsTaken was based. It was also the primary key of one of the tables on which the query was based.

I've used a similar principle in a current database i'm working on. The only difference is that instead of using an option group i've used another combo box.
Private Sub Preview_Click()
With CodeContextObjec... Read more

A:Access 2010 - Combo boxes and reports

Read other 7 answers
RELEVANCY SCORE 58.8

Hello there

I'm trying to develop a form in access 2007. It's a student grade system. There are at least 4 combo boxes on the main form. The instructor should be able to select the year group(combo box 1), that selection would then filter out the values in the 2nd combo box (say the 2nd combo box is the section of that particular year group Like 7C, 7G etc). The value selected in the 2nd combo box should then filter and select those students(3rd combo box) whose section id corresponds to the selected value in the 2nd combo box. Then the selected student id (3rd combo box) should filter out the registered subjects(4th combo box). Now, i've managed to sync the 1st and 2nd combo boxes. when the year group is selected, the corresponding section is filtered out after update. but i'm not able to sync the 2nd combo box (section) with the student combo box (3rd). if anyone can help me out please. i just can't mange to figure out where i'm going wrong . i've tried applying the same method via vba code, but then that messes up the sync b/w the 1st and 2nd. Please Help.
 

A:How to synchronize more then two combo boxes in access 2007

Read other 16 answers
RELEVANCY SCORE 58.8

Hello there,

We've got an MS Access database (provided by a 3rd party who are useless when it comes to support!) which amongst other things, has lots of forms for data input!

We are trying to print one particular form, not too hard you'd think!
There are a lot of combo boxes on this form, which when you do a print preview, it looks fine, but when you actually print it, no data is printed in the combo boxes. They all appear on the printout, but are all blank! All other data (text boxes etc) are printed fine.

I've even added a new combo box to the form, and it prints blank too. Yet, if I make a new form in this database with a combo box on, it prints fine, so it must be something "odd" on this form!

We've tried Access 97 & 2000 (don't have any other versions here), different printers. I've tried a few things with the form like making the combo boxes bigger, moving them about etc, but now am a bit stuck for ideas.

Anyone got any clues?

Cheers
Mike
 

A:MS Access - problem printing combo boxes

Read other 9 answers
RELEVANCY SCORE 58

Hello, I am new to writing code so bear with me. I have a db set up to capture one of our business processes. Basically after the user completes the form it goes thru a manual approval process internally. Once approved there is another feild on the form that must be completed. Upon completion of this feild, I want to lock all of the controls for that particular record. I am using the below code and it works fine, except for the controls set up as combo boxes. How can I get the combo boxes to lock too?

Private Sub Form_Current()
Dim ctrl As Control
Dim blnLock As Boolean
If IsNull(Me.OrdNo) Then

For Each ctrl In Me.Controls
If ctrl.Tag = "LockMe" Then
ctrl.Enabled = True
End If
Next ctrl
Else
For Each ctrl In Me.Controls
If ctrl.Tag = "LockMe" Then
ctrl.Enabled = False
End If
Next ctrl
End If
End Sub
 

A:Locking controls and combo boxes after another field is updated

Read other 16 answers
RELEVANCY SCORE 58

Hello,
I'm new to the forum and using Access , and need some help sorting out the finer points of using linked combo boxes. Basically, I have a tabbed form with subtables which allows me to auto-populate successive fields in my main table. I have combo boxes to select each field in order to speed up data entry and avoid errors. The form is for entering patient vital signs, so the tabs successively auto-populate patientID, date, and time. On the third tab's subtable, I can select the vital sign type (VS_Type) and vital sign value (VS_Value). I want to link the combo boxes in the form so it will limit the VS_Value options in the 2nd combo box to those that match the VS_Type selection in the 1st combo box. For example, if I select "heart rate" from VS_Type, the 2nd combo box should only show VS_Values that have "heart rate" as their VS_Type. I've gotten it to work outside of a subtable, but keep getting a pop-up box asking for parameters when I do it in a subtable. Here are the relevant portions of my current setup:
tblMain with fields ID_Main (primary key), patientID, VS_Date, VS_Time, VS_Type, VS_Value
tblVS_Type with fields ID_VS_Type (primary key), VS_Type
tblVS_TypeValue with fields ID_VS_TypeValue (primary key), ID_VS_Type (foreign key), VS_Value
formMain with:
Tab1 selecting patientID via a list box, then auto-populating patientID in Subform1 while selecting VS_Date.
Tab2 auto-populating patientID and VS_Date in Subform2 while se... Read more

A:Access 2007 linked combo boxes in subform

Read other 10 answers
RELEVANCY SCORE 58

I've tried playing with the macro commands in access in order to get combo boxes to display and dissappear at command when thier respective check boxes are clicked and clicked off, I have been unsuccessful at making them work though, they do not dissappear when moving to a new record. Is there anybody that can give me some vb code outside of using macros in order for this to be accomplished?
 

A:Access: Making Combo boxes invisible/visible

Read other 11 answers
RELEVANCY SCORE 58

Hello,

How do I add a combo box to a form that will then populate other fields? It is a combox box containing the SiteID, which will then populate the corresponding address and phone number in the fields directly beneath it. I set up a combo box that has the various SiteIDs, and SiteID is the primary key. I created separate unbound text boxes for the remainder of the fields (addr1, addr2, city, county, state, zip). When the SiteID is selected, I need to have the corresponding addr1, addr2 etc. automatically populated into the text boxes. All of the information is located within a query, called SiteInfo.

Please help me with this and don't scold me because I'm a rank amateur at this coding stuff. I really need your help.
Thank you,

Zoegirl
 

A:Access: Create a combo box/populate text boxes

Read other 6 answers
RELEVANCY SCORE 58

Hi - I have a database with comboboxes, when you select the suburb, it will automatically select the postal code, this works fine on some computers, but when I loaded it onto a netbook I could not see the dropdowns for the comboboxes, it was empty, it looks like there might be data in as the cursur hightlights rows, but there is no data in the dropdowns, or you cannot see it. I uploaded the same database onto a desktop and the fields were fine, can anyone tell me why it would not display on a netbook, but are displayed on my laptop and on my desktop?? .. Please help, this is driving met to milkshakes and chocolates!
 

A:Access 2007 - combo boxes not viewed on some computers?

milkshakes and chocolates sound great, I can't think of any reason why only one computer would not show them.
The only thing that I can think of is to check the row source and the Column Widths.
 

Read other 1 answers
RELEVANCY SCORE 57.6

Hi,

i am very new to access 2010. I need to create a database to manage the experts in our company. So for that i created 5 tables experts, expertise are divided into 3 more tables..... itype, industry and solutions and the 5th table contains the relationship between the expert table and the 3 different tables for expertise.... i

expert table fields:-ID, UserID, FirstName, LastName, Location, Department, PhoneNumber, Email, HeadCountArea,Role,Summary,Keywords, APJ,Americas,EMEA,Global,Date Modified

UserID field is the primary key for the experts table.....and the APJ,Americas,EMEA,Global are the check boxes.

Itype table fields:-

ID Level1 Level2

Industry table fields:-

ID Level1 Level2

solution:-

ID Level1 Level2 Level3

ID is the primary key for all these 3 tables.

rltnship table fields:-

ID UserID Itype industry solution

i already created aform by which i am able to enter the data into the the tables and able to select these itypes industry and solutions.....

now i want to create a search page where i can serach with and keyword and can get the result of the matching words in the profiles....

and also be able to search using the itype,solution and industry.....but for all these 3 there are different levels.......for example while doning the search i want when i select the level1 in itype or solution i should get the information about all the xperts who selected the level one irrelevent of the level 2 they selected...but if they selected the level2 also i sho... Read more

A:creating a multiple dependent combo boxes search form

haritbhasin, welcome to the Forum.
I have discussed this topic on quite a few Threads on the Forum.
The last one is here
http://forums.techguy.org/business-applications/1066947-solved-user-input-form-table-3.html
look at the latter part of the Thread.
 

Read other 1 answers
RELEVANCY SCORE 57.6

Unable to select the dojo filter combo boxes in the application using UFT Like in the application we have to dojo filter combo boxes fields i.e., County and prior carrier. Through Scripting we are able to pass the values to the dojo combo box fields but when we click on save button the dojo filter combo boxes are getting refreshed and throwing error like" One or more fields required"  Request you to do the needfull in this regards..It would be very helpfull if you can resolve this issue at the earliest...

A:Unable to select the dojo filter combo boxes in the applicat...

This is the wrong company for Servers, Storage, Software, and Networking. Please use the Hewlett Packard Enterprise Community:http://community.hpe.com/http://community.hpe.com/t5/Unified-Functional-Testing/bd-p/sws-Fun_TEST_SF

Read other 1 answers
RELEVANCY SCORE 57.6

Hey!

I am working on a school project in Access, but having some problems using VBA. I have an appointment and client table, with a store of addresses in the client table. there are address fields in the appointment table also, and i would like to be able to update these fields with the addresses from the client table based on a selection in a combo box on the appointment form.

I have experimented with some VBA code but have found nothing that works. I am not sure if the code is wrong or if I have it set to the wrong event on the combo box. I tried writing functions to fetch the correct field entry and place in the field on the form but it does not seem to have worked.

This is the code on my combo box (place)
Code:
Private Sub place_BeforeUpdate(Cancel As Integer)

If place.Value = 1 Then
meeting_building_name = GetBuilding
meeting_street_name = GetStreet
meeting_town_city = GetTown
meeting_county = GetCounty
End If

End Sub

This is one of the functions I use (they are all very similar)
Code:
Function GetBuilding() As String

Dim db As Database
Dim Lrs As DAO.Recordset
Dim LSQL As String
Dim LBuilding As String

'Open current database connection
Set db = CurrentDb()

'SQL statement to retrieve building value from table
LSQL = "SELECT clients.building_number FROM clients"

Set Lrs = db.OpenRecordset(LSQL)

'Retrieve value if data is found
If Lrs.EOF = False Then
LBuilding = Lrs("building_number")... Read more

A:Access - Update text boxes based on combo selection?

Read other 6 answers
RELEVANCY SCORE 54.4

I have windowsXP installed on one HD with one partition d: and i have one addiitional hd with one partition c: . I would like to remove another HD, but windows depends on him, it seems this this is labeled as system, or boot disc? How can i remove non Windows disc and boot only from disc where Windows is?

Thanks
 

A:Solved: windows boot depends from another hd

Read other 7 answers
RELEVANCY SCORE 52.8

using vista
may be on wrong site..........but here goes.
used this site for many years to alert me when repititive chores, events, bdays, etc. occur.
suddenly it doesn/t alert me anymore and i get no e-mail replies from the supplier.
can anyone suggest another free application that does the same job???
HELP !!!!!!!!!!!!!!!!!!!!!!!!!!!!
herb
 

A:Solved: memo to me

Read other 6 answers