Fast way to cut a long string

[sonic8]

The Expression builder includes VBA functions as well as direct SQL and directly convertible VBA functions.

I explicitly mean the Expression Builder for calculated columns in tables.
In that context the Expression Builder only offers a very restricted list of functions, which I believe are those built-in to the ACE-Engine.

 

[sonic8]

[...]Word mail merge, [...] In other words, only those queries that Jet/ACE can execute all by itself because the scope of the language is known.

I'm not so sure about that. I think Word Mail Merge also includes queries with built-in VBA functions, which are not built-into the database engine. To be really sure, one must use an application for verification that has no access to VBA at all.

 

[Gasman]

From word/Excel, you can't see action queries or any queries that use UDF or that reference a form or anything not available in Word/Excel.

I seem to recall I had that issue when trying to mailmerge from Excel, but cannot remember the exact details, sorry.

 

[sonic8]

From word/Excel, you can't see action queries or any queries that use UDF or that reference a form or anything not available in Word/Excel.

Can you still get external Data into Excel without using Power Query? If not, the above (the "anything not available"-part) is not true for Excel.
Power Query (in Excel) will at least list some queries containing functions, which are not available. If such a query is selected, it will display an error message and not show any data.

 

[NauticalGent]

Fast way to cut a long string.

Scissors, carton cutter, bread knife....

But don't make any snap decisions....

I was restraining myself from replying in the same way, good to know I'm not the only kid in the room...