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!
Adding a ComboBox to a MS Project Ribbon
Currently, I am using Project 2019. I created a custom ribbon using VBA code that creates an XML string and is activated using the following code: ActiveProject.SetCustomUI (ribbonXml) I tried to add a ComboBox to the ribbon using the following code: ribbonXml = ribbonXml + " <mso:group id=""grpLabel"" label=""Quick Labels"" autoScale=""true"">" ribbonXml = ribbonXml + " <comboBox id=""cboLabels"" label=""Labels"" onChange=""TestRibbon"">" ribbonXml = ribbonXml + " <item id=""lblAdd"" label=""Add"" />" ribbonXml = ribbonXml + " <item id=""lblDel"" label=""Delete"" />" ribbonXml = ribbonXml + " <item id=""lblChg"" label=""Change"" />" ribbonXml = ribbonXml + " </comboBox>" ribbonXml = ribbonXml + " </mso:group>" The ribbon works fine before adding this code. Once this code is added, the ribbon fails to load. I thought adding the onAction property was causing this but that did not change anything. The code above was just to get the combo box to appear. I would add the rest of the properties later. What am I doing wrong? Is Microsoft going to do anything to make this easier? Creating custom UIs should not be this hard to do. Thank you in advance!
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!!PowerShell: GUI programming - Combo boxes
Hi All, i am trying to build a simple GUI where users selects one of the two options from a drop down menu and click launch button. I have two PowerShell scripts. Scripts 1 and Script 2. Based on the option select by the user from the drop down menu, it launch runs script 1 or script 2: how to connect my two PowerShell scripts to these two drop down menu options? any tutorial links will be greatly appreciated. Thanks in advance everyone.
