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

A phobia is an irrational fear. There is plenty for rational people to fear of any group insisting their primitive misogynistic culture is the model for a way of life that everyone should follow. Fundamental Judaism and Christianity have the same kind of attitudes and more of those edicts...

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

Some people forget that economics is designed around a substantial proportion of the workforce being unemployed to keep down competition for workers and hence wage inflation. Four percent unemployment is often referred to as "full employment" and central banks generally start dampening the...

Just as is the case with Republicans when the Democrats win. Isn't that how politics works these days?

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.