How to Create Tile-Style Buttons on MS Access Forms?
Hello everyone, I have come across a user interface in MS Access that features tile-style buttons, as shown in the attached image. These buttons have icons, labels, and a modern appearance, which makes the form look more professional and user-friendly. I would like to implement a similar button style in my MS Access application. However, I am unsure about the best approach to achieve this. Could anyone please share their insights or experience on the following: What control type should be used to create these buttons? How can I add icons or images to the buttons while keeping them responsive? Is there a way to apply custom styling, such as rounded corners and background colors? Are there any VBA techniques or third-party tools that can help with designing such buttons? Any guidance, sample code, or references to tutorials would be greatly appreciated! Thanks in advance.
Using a form to find and edit a record
It's been a while since I've used Microsoft access so I'm a bit rusty. What I am looking to do is search up a quote by the number in a form and show me the details of the record corresponding to it so I can then quickly update it to see where it is in the sales pipeline.
Problem Updating Field from External Table
I have a form name [Jobs] which has subform [JobDetails subform] connected. The subform has a field [EquipmentID] which displays the names of electronic equipment which is set to run an update query AfterUpdate, to pull in the price of that equipment in the [Equipment] table with matching [EquipmentID]. In order that only this record gets updated, I add to the update query the autonumber field [ID] in the [JobDetails] table where the associated [ID] on [JobDetails subform] matches. When the query is run however, I get the prompt asking me to enter the value for that field even though an ID number is displayed. As I want to be able to change the value of the price that is populated, I need for only the current records price to be updated after I select the name of the equipment.# Any help on this would be greatly appreciated.
Subform for Subform
I have 2 tables I would like to create a data entry form for, but I'm not sure of the best way to go about this. I thought I would be able to have a Master Form with a Subform and a button on the Subform that opens another form, but the information entered in the secondary form doesn't save. Is there a better way to go about this that would not require me to get into SQL coding? The forms I have are: Container PO Item Container_ID is the primary key for the Container table that links to the PO table. PO_ID is the primary key for the PO table that links to the Item table. Item_ID is the primary for the Item table, but that doesn't link anything. I included the Container_ID on the Item table because I thought it might be necessary. However, I can't use that as a link to the Container table because the items are determined by the PO and there could be multiple PO numbers on a single container. Hopefully that makes sense. So I had tried to make a Container Master form with a PO subform and a button on the subform that opened an Items form where the items could be entered depending upon the PO. As I said that didn't work out. I also thought about have a linked form from the subform, but I don't know how to make those outside of the Form Wizard.
Forms Get Stuck in Refresh Upon Clicking on Editable Fields (Windows 10 issue but works fine in 7)
Background Info: I have a main form with subforms inside. A combo box is in the main form whose control is a query on two tables. The other subforms are based on two text boxes that hold GUIDs that are on the main form and are binded to the main form combo box. It should be noted that the subforms are tabular as well. Problem: Every time I click an editable field (text box or combo box) for a record in one of the subforms, the cursor has the blue circle spinning endlessly like Access is refreshing the forms. Once the spinning starts, it does not stop and makes it near impossible to interact with the forms. Somewhat of a Solution: I disabled ctfmon.exe within services of Windows 10, and this fixed the problem in Access. However, disabling ctfmon.exe also caused searching in Windows 10 search bar to not work. This is not something I want to have happen... What I Have Tried: - Adjusted various properties on the subforms - Disabled ctfmon.exe Please let me know if you have any ideas. Thank you!