Search results

that's exactly my point. Trying to get users to understand this when all they want in a button to open the FE so they can do the work. We be like: the work is done in the email - why open FE?

Its true the need for dirty = false is rare. I use it within a db that’s used as a library db. In that case you have to wrap all the docmd methods in public functions within CodeDb in order to call them from the CurrentDb. can we all agree that both options are better than? DoCmd.DoMenuItem...

Shoulda bought that dogecoin an hour ago. 1 tweet + 1 hour = 25% bump.

Same same. Meanwhile users just want it to open the FE and we be like...why exactly? This will be the state of affairs for a long while for many companies. Let's hope this paradigm and momentum remains long enough for adoption to catch up.

You can display most Adaptive Card info in Outlook Email Body as well. There are all kinds of Samples and a designer at adaptivecards.io

As others have said, post the SQL so we can help. There are cases when executing 2 queries make sense often if only to simplify the code usually WITH clause is your friend in such cases as it creates common table expression without any need for temp tables or disk io.

Check out Adaptive Cards and Actionable Emails if you want great looking emails from which recipients can efficiently perform useful actions.

Concurrent run count is a nice setting to know. You can quickly run out of runs in your license with the recurring trigger. Another good one - especially if you must use recurring trigger - also hidden in trigger settings are trigger conditions. There you can use expressions similar to the...

Has little to do with energy use. Check $btc price chart yesterday. 1 tweet + 1 hour = 10% discount. New Influence Metric Unlocked.

Correct. So like: Private Sub Form_Open(Cancel As Integer) If IsODBCConnected("tblCustomer") = False Then MsgBox "SQL Server is NOT available" & vbCrLf & _ "Unable to relink tables" & vbCrLf & _ "Cancelling Form Open", vbInformation, "SQL server not...

I suppose it's initially incumbent upon critics of an existing system to propose a better one in order to have profitable engageent on the matter.

If the main form that calls this also has databound controls that query SQL Server then you're not going to prevent the SQL delay. You need to call this Form_Load and cancel the form load or call it from a non-databound form such as a menu.

The basic building blocks are: import from Excel into a temp table using docmd.transferspreadsheet (you can specify a saved import spec to refine the data here too) Execute update queries to delete, replace unwanted strings and 'AddSpaces' using docmd.openquery or docmd.runsql Now do whatever...

I think it's more about the control itself is coded with a reasonable limit. Much like, as you point out the ShortText datatype has limits around indexing and such - but not specifically because of those limits per-se. They have to draw the line somewhere and consider the perf vs. resources...

Havn't bothered with the runtime for a while but believe your only option is indeed to use the OfficeCustomizationTool and OfficeDeploymentTool with AccessRuntimeRetail Product ID specified in the config file similar to this: <Configuration ID="b6696c97-fb24-42a8-bb1a-d253ae3092ad"> <Add...

Except when the drive maps don't exist on some random workstation which always happens. Just one more layer to manage. UNC paths and done. That is if you link over LAN at all. 5+ users critical app - always use rdp. Now paths are local - never a network issue.

With DoCmd.RunCommand acCmdSaveRecord Access will save the form that has focus while using Me.Dirty = False you're explicitly saving the form represented by the Me object. For that reason Dirty = False can be preferred. On the other hand, the error message leaves a lot to be desired in the...

You can stop waiting and proceed to learn and build with your own individual environment like so: Visual Studio Dev Essentials which has everything you'd need including PowerApps Community Plan ...still check out Radzen as PA is great but not limitless. ugh links don't work on this site.

Access over SharePoint data is much improved in recent versions - Office365 (Access 2016+) and SharePoint Online. You have to want SharePoint features for this to make sense in my opinion. The best solution to using Access as a client-server is don't. Instead run on an RDP server with BE on...

UNC paths are better than Mapped drives and if your workstations are Win 10 v1803+ check 'disable leasing' as suggested as there is a known issue with server-side fix required. For some reason I can't post links on here but theres an article on support.microsoft.com titled Access reports that...