Search results

I did a search, but I honestly do not know what I am looking for. I tried to create a macro for OnChange where CmbSenateSubcommittees (the second combo box) would requery CmbCommittees1, but that did not do anything. Is there a built in function to create a cascading combo box? If so where?

I have created a form with the following combo boxes: Senator Name, Committee, SubCommittee, and issue. Within this form the data displayed by the SubCommittee combo box is predicated by what is entered in the Committee box by using the following formula: SELECT SenateSubcommittee.SSC_Name...

Thanks for your help. I didnt think it would be that easy.

Sorry, here is the SQL of one of my queries: SELECT SenateMember.SM_Last, SenateMember.SM_First, SenateMember.SM_MiddleName, SenateMember.SM_Nickname, Location.Committee, Location.SubCommittee, Issues.Issues, Location.Location FROM (Location INNER JOIN SenateMember ON Location.SM_Seat =...

I am creating a database in order to log in the location of certain files based. I began by creating an entry form with fields for "Individual", "Committee", "SubCommittee", "Issue", and "Location". Once entered into the form, the data is stored in a table. While I managed to do this with...

I apologize for the delay in responding to your question. I appreciate your assistance with this little project of mine. In terms of your question, every product section has brackets, such as CABLE TRAY SECTION [05CT], and if there are multiple product sections, they will be broken up by a |...

Thank you for your response. The data is consistent, in that all the product codes appear in brackets, however if there is only one product then a | will not appear. Additionally, if the company did not provide a response, then --NOT Sure-- will appear.

I have created a query showing locations of a company's facilities, and product groups associated with that facility. Unfortunately the the products groups are located in one column and, if the facility produces more than one product, the product group is divided by a |, as shown below: CABLE...

Thanks again for your assistance. To better understand my problem, I have created the tables below. Unfortunately I cannot alter these tables, as I receive weekly updates from an external source, and cannot alter the basic structure. As you can see, these tables are linked, but the key...

Moniker's response was a great way to force data, and it did help out to a certain degree. Unfortunately I am still experiencing problems with 36 of my entries (out of 322). With the remaining Congressmen, the problem essentially involves their status on a committee. For instance, if a Member...

I have created a query based on two akwardly designed tables that ultimately relate a member of Congress to a specific Committee and Subcommittee. Unfortunately I cannot alter the tables, as I receive weekly updates from an external source. This being the case, once I have created the query...