User Profile
ScottLamond
Brass Contributor
Joined Aug 03, 2022
User Widgets
Recent Discussions
VBA Code Slow in Exporting HTML Files
After today's updates (which may have included older patches), every HTML page is taking several seconds to export (using VBA code within the Open Event of a form that is automated to run using a looping Batch Script START command and exports an HTML versions of reports). It may simply be the numerous updates that may be affecting the server CPU. But I'm also wondering if this is a known issue.Solved132Views0likes1CommentRe: Outlook Desktop Notifications Not Working, But Enabled in Outlook and System Settings
Wow, 6 months and no replies? I have the same issue with only two users in a terminal server environment (RDP from PCs to Windows Server 2016 using Outlook via M365). Although I've only tried a couple of your tweaks. I'll try all. Send any news on this topic if available.3.1KViews0likes1CommentRe: Remote Desktop - Local Resources - Drives
Alban1999 By "connecting" I meant connecting to a terminal server session using RDP/RDC from home or from their onsite, local PC and using the Local Resources tab/Drives option to move data between machines. I would assume that group policy would manage both since they are logging into our domain. I'm just not clear on exactly where to find the setting but I'll hunt.12KViews0likes3CommentsRe: Remote Desktop - Local Resources - Drives
Unable to find anything, I searched the Internet and found this but will wait for some confirmation: In "Server Manager", go to "Remote Desktop Services" tab, then "Collections", then "QuickSessionCollections" and in the Properties of the collections click in the "TASKS" drop-down. Select "Edit Properties" and then "Client Settings".12KViews0likes2CommentsRe: IF formula not correctly displaying
The issue I sometimes experience is if I enter data into a cell that was not in the original range selection. I'm now in the habit of making sure I insert a row between the top and bottom cells, since the software is designed to assume that I want it in the total.1KViews0likes2CommentsRe: IF formula not correctly displaying
My first thought was to check that the 4500 in B2:4500 is entered as a number and not text. This happens to me sometimes when I copy numbers from another source. Should be no leading apostrophe ('), no spaces, etc. Also, highlight all the cells and explicitly define them as a number.1.2KViews0likes5CommentsRe: Runtime Error With No ID
Call off the dogs. The update fix is KB5002248. The one that broke things is KB5002112. It arrived yesterday and installing it stopped the runtime error. Uninstalling KB5002112 had fixed our VBA code exporting of html and txt files, but had not fixed the runtime error.1.8KViews0likes0CommentsRuntime Error With No ID
We use the ChempaxVB business system that uses Microsoft Access as the database. As of Monday this week, four users see a "Runtime Error" with no ID code and cannot open their "Reports Window". This is the ChempaxVB interface with the reports.mdb that contains all queries, forms and reports. So, they can use the software but cannot print. When they run ChempaxVB a temporary copy of chempax.mdb is created in their server Users\username\AppData\Local\Temp folder. We are in a terminal server/RDP environment running Windows Server 2016. I fixed this issue for one user by removing them from AD, deleting their profile and recreating them as if a new user. But the same process failed for two others. This morning I've also tried creating a new test employee from scratch and get the same error. I've also reviewed the user's Access Options for macro and ActiveX security giving them the most trusted settings, including adding the ChempaxVB folder and even their server User folder to Trusted Locations. We have seen some reports of a similar known issue in which VBA code cannot output to html or txt files; and that Microsoft is releasing an update, supposedly yesterday, August 2. But I would expect, if it is known issue, that Datacor, the ChempaxVB supplier, would have other customers reporting the same issue. I am aware that Microsoft is making security changes related to macro security and wonder if this is related. This may not be related but I forced the error, noted the time and then checked the Event Logs: 'The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {8D8F4F83-3594-4F07-8369-FC3C3CAE4919} and APPID {F72671A9-012C-4725-9D2F-2A4D32D65169} to the user NT AUTHORITY\SYSTEM SID (S-1-5-18) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool."Solved1.8KViews1like3Comments
Recent Blog Articles
No content to show