Wire Database
Hello - I work at a company that process quite a few wire and ACH transfers a month. I would like to create a database in Access that allows me to have users put together a wire request form that auto-populates the Bank Name, Account and Routing numbers based on selected criteria. Specifically, based on the EntityID and CashType selected, the Bank Name, Account Number and Routing Number would be generated. Unfortunately, this information comes into Access in a couple different tables. Additionally, an Entity can have multiple cash types and not all entities have the same cash types. The Entity ID and Cash Type combination determines the BankID field, which links to the table that has all the pertinent bank account information. I attempted to write a query that pulled all this information together in one place. Below is a screen grab of my Relationships screen. I can get a combo box that a user to select an entity ID and name. But after that, how do I tie the next input box to show a drop down of the available CashTypes associated with that entity? With those pieces of information, I should be able to autofill the BankID figure. Then how can I have that selection fill in the Bank Name, Account Number and Routing number on the form? Thank you for the help!
Excel ComboBox (ActiveX Controls) dropdown not functioning
Hello all, My issue occurs when trying to select the dropdowns for ComboBoxes on this Excel sheet. Everyone else in my department can access and use this sheet without issue. However, when I select any of the ComboBoxes, right-click and left-click cause a phantom dropdown to hover in the cells above the ComboBox without actually opening the dropdown: I discovered that I can edit the selection from the dropdown if I go to Developer tab > Design Mode > Right-click ComboBox > ComboBox Options > Edit: This is an un-optimized, time-consuming solution (to say the least) when I should be able to make these same selections by simply left-clicking the dropdowns when not in Design Mode. I'm guessing that this is an issue with some unknown Excel setting since the ComboBoxes only misbehave this way on my laptop across our office. The sheet is unprotected and creating new ActiveX ComboBoxes results in the same dropdown selection issue. Any help this forum can provide will be greatly appreciated!!
