Hello, I am having an issue with my synchronized combo boxes and don't know how to fix it.
I have created two boxes and have made the synchronization work (the user clicks on the first box and makes a choice and the second only shows items which are related to the first box's choice).
My problem is that the user can not choose from any of the choices in the second combo... whatever is clicked on the very first item is the only thing that will show up. I have 48 choices in the first box (Tool Types) and 540 choices in my second box (Tool Variations - based off of the first) and would like to not have to show the user the entire list that is why I went with synchronized boxes.
The table names are as below: - tblToolTypeLookup:
-
ToolTypeID: Primary Key
-
ToolType: Text
- tblToolVariationsLookup:
-
ToolVariationID: PrimaryKey
-
ToolVariation: Text
-
ToolTypeID: Int Foreign Key Reference ToolTypeID in TblToolTypeLookup
combo box props are as below:
Combo#1 is: - Name: Tool_Type
-
Control Source: Tool_Type
-
Column Count 2
-
Column Widths: 0";1"
-
Row Source: tblToolTypeLookup
-
Row Source Type: Table/Query
-
Bound column 1
-
After Update: Embedded Macro - Requery -> Tool Variation as Argument
Combo#2 is: - Name: Tool_Variation
-
Control Source: Tool_Variation
-
Column Count: 2
-
Column Widths: 0";2"
-
Row Source Type: Table/Query
-
Bound column: 1
Below you will find my SQL. - SELECT tblToolTypeLookup.ToolTypeID,
-
tblToolVariationsLookup.[Tool Variation]
-
FROM tblToolTypeLookup INNER JOIN
-
tblToolVariationsLookup
-
ON tblToolTypeLookup.ToolTypeID = tblToolVariationsLookup.ToolTypeID
-
WHERE (((tblToolVariationsLookup.[Tool Type])=[forms]![KRDL00057 MIL FORM].[Tool_Type]));
the boxes work... per se... when the user chooses lets say "Wrenches" from the first box the second box when clicked only provides the types of wrenches...just as a synchronized box should do.
My problem is if the user chooses any item (it doesn't matter how far down on the second box) it doesn't "lock" on that item and place it in the record. It will not let the user choose anything but the first item in the list of the second combo box.
I have an embedded macro in the first combo box in the "After Update" that is Tool_Variation. requery so that when the user makes a choice combobox2 will update its listing according to the choice in combobox1.
Please help with any ideas you might have to share.
Wolf
Sep 28 '09
12  2147 
OK. So I am going to try and add as much description so as give a solid view of what I am trying to do (without adding my DB). Below is all the information I can think of to add. If more is needed, please feel free to ask.
Description of Job:
I am trying to make this inventory as easy as possible for the users.. The least amount of typing involved and also a continuity to the item names. Each user had a tendency to give tools "thier own name". Believe me when I first pulled in all of the inventories into EXCEL I had 3,640 lines of tools and was able to break those down, with time, into two tables - one with a "generic" tool type (47 lines) and the other with a more descriptive tool variation (540).
-----------------
Below are the defining columns/attributes for my tables involved in this little adventure (info deliniated by lines):
tblLocationInCK TLookup where the user picks from a drop down for a drawer/shelf/area where the tool is located.
Column Name - Data Type - Description
LocationID - AutoNumber - PK
Location - Text
----------
tblSizesLookup where the user picks from a drop down for a size of the tool.
Column Name - Data Type - Description
SizesID - AutoNumber - PK
Sizes - Text
------------
tblToolTypeLook up listing for a "generic" description that will create a drop down for the tool.(i.e. Wrench)
Column Name - Data Type - Description
TooltypeID - AutoNumber - PK
Tool Type - Text
-------------
tblToolVariatio nLookup listing for a more defining description that will create a drop down for the tool.(i.e. Combination Wrench)
Column Name - Data Type - Description
VariationID - AutoNumber - PK
Tool Variation - Text
TooltypeID - Lookup column - Lookup tied to the tblToolTypeLook up
---------------
tblKRDL00057 where the records are to be stored.
Column Name - Data Type - Description
ID - AutoNumber - PK
Location in CTK - Lookup column - Lookup tied to the tblLocationInCT KLookup
Size - Lookup column - Lookup tied to the tbleSizesLookup
Tool Type - Lookup column - Lookup tied to the tblToolTypeLook up
Tool Variation - Lookup column - Lookup tied to the tblToolVariatio nLookup
Quantity - User enters the quantity of tools - this is used in the reports to create totals.
TMDE# - User information entry area (if needed)
Consumable - User information entry area (if needed)
---------------------------------------------------------------------
To fill in tbleKRDL00057 I have created form KRDL00057 MIL FORM this is a split form with the bottom being the datasheet. The combo boxes/text boxes have the following attributes:
Combobox: Location in CTK: SELECT [tblLocationInCT KLookup].LocationID, [tblLocationInCT KLookup].LOCATION FROM tblLocationInCT KLookup;
Combobox: Size: SELECT [tblSizesLookup].SizeID, [tblSizesLookup].Sizes FROM tblSizesLookup;
Combobox: Tool Type: SELECT tblToolTypeLook up.ToolTypeID, tblToolTypeLook up.[Tool Type]FROM tblToolTypeLook up;
Combobox: Tool Variation: SELECT tblToolTypeLook up.[ToolTypeID], tblToolVariatio nsLookup.[Tool Variation]
FROM tblToolTypeLook up INNER JOIN tblToolVariatio nsLookup ON tblToolTypeLook up.[ToolTypeID] = tblToolVariatio nsLookup.[ToolTypeID]
WHERE (((tblToolTypeL ookup.[ToolTypeID])=[forms]![KRDL00057 MIL FORM].[Tool Type]));
The others are textboxes for user input of information (TMDE, Consumable, Quantity).
-------------------------------------------
All the lookup tables have a one-to-many relationship with the tblKRDL00057.
Within the sQL for the Tool Variation Combo box I was sure to add the brackets around all of the "like" named items so as to allow the program to differentiate between which table/box I am trying to use.
 NeoPa 32,569
Recognized Expert Moderator MVP
I think you've misunderstood my point. I don't want to see the entirety of you project in a post any more than I do in an attached database. That is not how to ask a question. Asking a question is about deciding which information is required and posting that, along with meaningful words explaining what you need help with. This should be of limited scope. For example a request to find and fix problems in a database is of far too broad a scope to be allowed even (let alone find someone prepared to spend the time on). As an administrator I am able to comment on both aspects you understand.
Your ability to include important information in a clearly understandable way is good (clearly - though please remember the CODE tags in future posts). What you need to do now is decide exactly what you want help with and express that as a simple question. We consider ourselves pretty competent in Access and are willing to share our knowledge. We do not consider ourselves as a free resource for finding your problems for you. We can advise there too of course, but that part is your responsibility.
The upshot of this is that, while I do not wish to put you off from posting your questions, I must guide you away from such open-ended questions and help you to understand what we find acceptable on this site. NB. This is intended as guidance and not criticism. As a new poster I'm sure you're merely finding your way and the latter would be of no help. I hope the former proves to be.
Moving on, if you are unable to see where your problem even exists in your project, then may I suggest you look at Debugging in VBA. There are many tried and trusted techniques included which most of us use to help us to identify exactly where our idea of what should be happening differs from the execution of the code itself.
OK...thanks for your input.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Frank |
last post by:
Hi,
In the javadocs regarding many of the java.util classes, it states
that the classes are not synchronized, and suggest using the
Collections.synchronizedX(...) methods for getting synchronized
objects. However, why couldn't one simply declare:
private synchronized LinkedList l;
and have the variable be automatically synchronized, instead of having
|
by: Max Ischenko |
last post by:
Hi,
I wrote simple implementation of the "synchronized" methods (a-la Java),
could you please check if it is OK:
def synchronized(method):
"""
Guards method execution, similar to Java's synchronized keyword.
|
by: Rich Sienkiewicz |
last post by:
Some classes, like Queue and SortedList, have a Synchronized method which gives a thread safe wrapper object for these classes. But the lock() statement does the same thing. Is there any rules as to when to use one and not the other? For instance, if I wanted to remove an item in a SortedList, would it be better to lock() it or do it via the Synchronized wrapper? Why choose one over the other
SortedList sl
lock(sl
sl.Remove(item)
O
|
by: chrisben |
last post by:
Hi
I often use Queue.Synchronized method to create a queue for multithread writing. I also know I could use SyncRoot and lock to write Queue. Could anyone here please explain to me the pros and cons between those two approaches
Thanks a lo
Chris
|
by: norbert.thek |
last post by:
Hi
Can somebody tell me if I'm right or not
The attribute
Is like an lock(this) over the Method where i put this Attribute?!
If I have two methods like:
| | |
by: Edwinah63 |
last post by:
Hi everyone,
Please let there be someone out there who can help.
I have two BOUND combo boxes on a continuous form, the second being
dependent on the first. I have no problem getting the second combo to
change depending on what values the user selects in the first box, it's
just that every time the user changes the first combobox, the second
combobox FOR EVERY RECORD goes blank.
|
by: Miguel |
last post by:
I have synchronized combo boxes linking Account Type with Customer
Names based on the template that Microsoft has in one of its samples
databases. There are the appropriate relationships between the Account
Type Table and the Customer Name Table based on the ID field, so it is
the ID field which is stored in the main table. However, in the form,
the Account Type and Customer Name are displayed because the column
width property has been...
|
by: Miguel |
last post by:
I have an order entry database with two forms. One is for new orders
the other is to update orders. The forms are identical except that one
is strictly order entry. On both forms are three sets of sychronized
combo boxes. When entering test data everything worked perfectly. I
recently migrated 5,000+ records from an Excel file to the database.
The migration was successful and all records were copied over. When I
checked the underlying...
|
by: jmartmem |
last post by:
Greetings,
I have a nagging problem with client-side dynamic dependent list boxes that perhaps someone can help me troubleshoot.
I have a form with a series of dynamic dependent list boxes. Making a selection from list/box A (Qtr) selects a fiscal quarter, which then refreshes the values in list/box B (Mth), which shows the 3 months in that fiscal quarter, which then refreshes the values in list/box C (MthDate), which returns the date...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
