developer
1929 TopicsMsgbox or Modal window Crash on PC Sleep
This has been an issue for a couple of years, but I haven't spent too much time trying to solve it because I thought it would eventually go away. It hasn't and it is becoming worse as I develop other parts of my application. Situation: When a msgbox (or modal window) is open and the PC sleeps, the application hangs upon PC awake. There's no way to get out it with ending the process. To replicate: Create and save blank database Create one module with a single public test function Enter msgbox "Hang Test", vbOkOnly Hit F5 to run the code. The message box pops up. Leave it. Put PC to sleep manually with windows | power | sleep Awaken PC, Access is now frozen. GPT provides a lot of explanations for this behavior, but it doesn't make sense and must be something that can be addressed. Windows 11, Version 2606 (Build 20131.20126 Click-to-Run)48Views0likes3CommentsDeveloper Scroll Bars Suddenly Became Erratic!
Hello, I have a very unusual problem related to developer form control Scroll Bars! I had previously enjoyed my highly reliable Scroll Bars and Spin Buttons that I had created for months (if not more than a year). Suddenly, (a few days ago) the Scroll Bars are simply no longer reliable, while only the upper button of Spin Buttons is highlighted, even if the lower one is clicked! This occurred without my tweaking! By unrealiable Scroll Bars I mean you can sometimes slide the scrolls and sometimes not. Usually, the first few work more reliably, while the later ones than freeze! It behaves erratically like that. It can help sliding previous bars and returning to the later ones, zooming in and out, and manually inserting the number and then re-fixing the Scroll Bar. Neither copy/pasting an upper working Scroll Bar, nor inserting a brand new one helps with the erratic behavior! The same applies to the Spin Buttons. Sometimes, you can click the lower button and the values will go low as expected. However, once the problem settles in, you can continue clicking the lower button, but the upper one will be selected and applied. The same temporary fixes as with the Scroll Bar (and copy/paste and recreation non-solutions) apply! I have the Excel file ready and wish to upload it here for you to see if you can produce the problem on your end! This has never happened to me before!7.7KViews0likes26CommentsWord/PowerPoint are not suitable replacements for Publisher
I’m writing following the guidance that Word and PowerPoint can be used as replacements for Publisher. This feedback is based on completing a real production document, not theoretical use Having just completed a fairly complex, layout-heavy technical document, I thought it only fair to share how that works in practice. In theory, I can see the logic: Word handles documents PowerPoint handles layouts Therefore, between the two, everything should be covered Unfortunately, in reality, this appears to be more of a theoretical exercise than a practical solution. Publisher was clearly designed for: Fixed, page-based layouts Precise positioning of objects Efficient alignment of mixed content (text, images, tables) Producing consistent, professional multi-page documents By comparison: Word is admirably committed to reminding you that it would prefer everything to flow freely, regardless of whether you want it to or not PowerPoint, while better behaved, does seem to assume every page is a standalone slide rather than part of a structured document Both tools can, with enough persistence, be persuaded into doing the job. However, this involves a level of manual intervention, workaround, and general negotiation with the software that feels somewhat at odds with modern productivity software. To put it simply: They are not replacements in any meaningful, real-world sense. The end result can be achieved, but the process is unnecessarily time-consuming, fragile, and prone to unexpected layout changes—particularly when precision actually matters. Replacing a purpose-built publishing tool with two applications that were never designed for that role gives the impression that this use case has been… optimistically simplified. I would strongly encourage Microsoft to either: Provide a genuine page-layout solution within the Office suite, or Enhance existing applications so they can support fixed-layout publishing without constant workarounds At present, the gap left by Publisher is very noticeable for anyone producing structured documents beyond basic text. I appreciate the direction of Microsoft 365 overall, but in this particular area, the experience feels less like an evolution and more like working around a missing tool. Regards Andy100Views1like2CommentsCan anyone help me with this SWITCH function
Hello Everyone, This SWITCH function is used to produce a number that then I can use to sort workers and their functions. =SWITCH(TRUE, IF(AND(ISNUMBER(J2)=TRUE,M2="Working")=TRUE,5,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Working")=TRUE,500,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project")=TRUE,15,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project")=TRUE,515,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Stand By")=TRUE,20,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Stand By")=TRUE,520,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project UFN")=TRUE,25,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project UFN")=TRUE,525,0), 50 ) In Column J I have their Start Time, from the Kronos System, and in Column K I have their End Time. In Column M I have Tasks names that would indicate what each Team member is doing. Each component does evaluate correctly but the function always return 50? What am I missing here? Thanks in Advance! GiGi100Views0likes3CommentsExcel Macros Spreadsheets Not Loading
I've spent some time with Microsoft Support (almost 3 hours, including uninstalling my MS 365 and reinstalling it), but I'm having an issue with my Excel Macro spreadsheets not loading at all. This is what I get each time. Also having an issue with non-Macro spreadsheets that I'm unable to use the Bold, Italic, and Underline functions (get the spinning wheel and then Excel Not Responding), as well as not able to use the Format function (get the same spinning wheel and then Excel Not Responding). I've been using these same Excel Macro Spreadsheets for over 15 years. Please help!240Views1like2CommentsA Personal Note to the Access Community
Today is my last day at Microsoft. After many wonderful years, I have accepted Microsoft's Voluntary Retirement Program (VRP) and am beginning a new chapter. It feels a little surreal to write those words. For much of my career, I've had the privilege of working with products, communities, and people I deeply care about. In recent years, that has included serving as Program Manager for Microsoft Access, one of the most passionate, knowledgeable, and dedicated communities in technology. Before I go, there is one message I want to leave you with: Access is alive, well, and continuing to evolve. One of the most common questions I hear is, "Is Access going away?" The answer remains the same as it has always been: No. Access continues to ship with Microsoft 365 and Office, continues to receive engineering investment, continues to receive bug fixes, security updates, accessibility improvements, and yes, new features. In fact, we've released multiple new capabilities recently, including improvements such as enhanced zooming support, larger form and report design capabilities, and new developer-focused functionality, with additional features already in various stages of development and rollout. Over the last few years, I've had the opportunity to work alongside an incredibly talented engineering team that genuinely cares about Access and the customers who depend on it every day. I've seen firsthand the discussions, the prioritization meetings, the customer feedback reviews, the accessibility work, the bug triage sessions, and the long hours spent making sure Access continues to serve businesses, governments, schools, non-profits, and developers around the world. Access remains an important part of Microsoft's productivity ecosystem, and the team remains committed to keeping it relevant, reliable, and useful for years to come. I know many of you closely follow the public roadmap and occasionally worry when it's quiet. What doesn't always make it into public announcements is the steady stream of work happening behind the scenes: security investments, compliance work, accessibility improvements, bug fixes, customer-requested enhancements, and the engineering work required to keep a 30-plus-year-old product healthy in a rapidly changing technology landscape. As for what comes next, I don't yet know who the next Access PM will be or when that transition will occur. What I do know is that Access deserves thoughtful stewardship, active engagement with the community, and a clear understanding of why this product continues to matter. I am hopeful that whoever steps into that role will bring fresh ideas, curiosity, and a commitment to listening to the customers, MVPs, partners, and developers who make this community so special. To our MVPs: thank you for your advocacy, your feedback, and your willingness to tell us what we're doing right and what we're doing wrong. Many of the features we've delivered started as customer requests, conference conversations, forum discussions, and MVP feedback. Your voices matter, and they have made the product better. To the Access developers around the world: thank you for continuing to build solutions that solve real problems. Every time someone says Access is only a relic of the past, I inevitably hear from another organization running a mission-critical application, supporting a small business, managing a research project, tracking inventory, or helping people get work done. The creativity and ingenuity of this community never cease to amaze me. And finally, thank you for letting me be part of your journey. It's been an honor to help tell the story of Access, share new features, write documentation, engage with the community, and occasionally fight to get your favorite feature request prioritized. While I'm retiring from Microsoft, I'll always be rooting for Access and the people who use it. The future of Access belongs to all of you, and I believe that future is bright. Thank you for your support, your passion, and your trust. See you around, Linda Cannon Former Program Manager, Microsoft Access944Views10likes5CommentsDoes CSPP Support Microsoft Copilot
We are working on an integration with Microsoft's Cloud Storage Partner Program and already started getting questions on Copilot support. Does CSPP support using copilot in the Microsoft for the web editors? I wasn't able to find anything mentioning it in the documentation for CSPP or CSPP+.36Views0likes1CommentIs it really impossible to break workbook protection?
Hi, I process personal data and need strict protection (GDPR). My raw data from a survey is copied to several worksheets in a workbook and the processed anonymous data (dashboards) is in other worksheets in the same workbook. Before sending the whole workbook with the visible dashboards to my customers I delete some of the raw data worksheets and hide others. After that I protect the structure of the workbook with a code. Now only the worksheets with the dashboards are visible. Will it at all be possible for my customers to break the protection and get access to the sensitive raw personal data or am I completely safe? Thanks in advance to your reply! Best regards PerSolved6KViews14likes27CommentsGetting data from Snowflake to Excel
Hello I have multiple no technical users and am trying to find a way to setup a snowflake query for them and then let them refresh it whenever they want or on a schedule, but I couldn't find a good solution this what i found so far: ODBC (Not great for non technical users needs setup on each user desktop) Power Automate (Needs Power Automate Premium which we don't have) Third Party tools (Expensive pricing models) Through Power BI (We want to separate this process from power bi) Any suggested solution please!Solved118Views0likes3Comments