Search results

It is often assumed that every sub or function needs an error handler but this is not the case. Upon encountering an error Access will work its way back up the calling stack until it reaches an error handler. Only when this process is exhausted, will it throw and unhandled error. If the code is...

AI is already being poisoned by vast quantities of misinformation pages being generated by AI. It could already be a war between AIs trying to wreck its competitors. We won't know when AI takes over because AI will be manipulating the information we see. Even those who think they are...

You don't understand how AI is built.

It isn't hard to write a sub to read the VBA to list all the functions in a project and write them to a table. The parameter names and their datatypes could be included as fields. Every Access developer should get the free V-tools plugin. Total Deep Search is incredibly useful an has a Replace...

Sounds like a job for a stored procedure. BTW I once said on here that a CTE was run just once at the beginning but I have since been told that a CTE is simply a quick way to repeat the code and it runs separately for each instance it is used.

Just a correction to your terminology. A Refresh of a form updates the values on changed records but does not show new records. For that you need a Requery. Incorrect terminology can lead to bewildering behaviour on this.

I Googled the price of low background steel today and AI gave me an answer of $5 billion per kilogram. I have a couple hundred kilograms of it under my house so I'm going to sell it tomorrow and retire to live in luxury for the rest of my life.;)

You forgot to say that you are stating your opinion. You said it as though you were stating a fact.

Every post is an opinion.

I would hazard a guess that the Australian term, "skull", meaning to down a whole drink in one action, came from the same root.

I did not title myself "super-moderator". I have no idea who applied that term to my profile. The religious of any flavour are often offended when someone points out the reality about their delusional beliefs.

The full story is complex and discussed at length on this page. https://stackoverflow.com/questions/2300983/is-vb-really-case-insensitive

ODBC drivers I have looked into connect to online resources via their API. I thought that was the case with Devart and Salesforce but I don't know about Shopify. I don't have any direct experience but some ODBC drivers to online resources will download the whole table when selecting one record...

One does not normally store calculated values in tables. Use the query like arnelgp explained.

What is the extension type of the file?

I don't know how well PATINDEX() would perform compared to this SQL that uses the set processing strengths of the engine. Performance can be quite counter intuitive and isn't always the simplest code that wins. I would be very interested in the comparative speeds. This query does a Cartesian...

Assuming you want a return value, create a Public function with two parameters in a Standard module.

Putting error handling message in every Function can be a bad idea if the function is being applied to the data. It will throw the error repeatedly if there is a problem. Often it is better to return the error from the function as an out of scope return value. For example, if all expected...

I have very broad tastes in music but I cannot stand Luciano Pavarotti. He did a hopeless series of duets with great singers. I thought there might have been so chance of a Eurythmics classic he did with Annie Lennox but he couldn't even do that with any talent.

This is what Pat is talking about. Put this in the Format property of the control or field. You can use the usual formatting instead of the the plain # #;#;; They represent the format for positive, negative, zero and text or null respectively Unlike the clumsy function suggestions above, the...