Recent content by Jbooker

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...