Recent content by CJ_London

Many years ago I was European Controller for an American training company. They had many packages containing training manuals and videos. It fell to me to get these translated into French, German, Italian and Spanish. The manuals not a problem but the videos, oh boy. Trying to replace the spoken...

A great guy and will be sorely missed

What I have done in the past is create two or more subform controls. Lets say you want 20 rows. You only need the one subform, but apply to multiple subform controls Depends on how you determine which 20 to appear in each subform (might use the TOP predicate or a filter) but as an example in...

What happens if you remove the where clause? The sql structure doesn’t look right to me but perhaps it is valid when constructed in word?

Why? I have had clients with a single user who as an organisation had an on prem sql server with dba’s who managed the server - maintenance, backup, security, etc. it was the organisations requirement that all databases resided in the server and they managed who had access to what data and when

Have you put together a security document to identify what you want to protect? from who? By doing what? That may be dictated by existing customer requirements or your own requirements. If so, that should identify where you need to focus your efforts. It may well be access is not the way to go.

I find place name pronunciation interesting- there is a town in England called Ashby-de-la- Zouch, pronounced ‘zoosh’ a few miles away from there is a village called Zouch, pronounced ‘zotch’ I was in my thirties when my pronunciation of Arkansas was corrected from ‘ar Kansas’ to ‘ark in saw’...

We used it many years ago for stock management - company provided training and assessment materials (manuals and the like) and simplistically a piece of paper would be placed in the ‘pile’ of manuals at the reorder level. When it became exposed as manuals were despatched it was passed to stock...

using win11 MS 365 64bit variety of monitors I get split line on popup but not with a normal form As a theory, I suspect because a popup is not a child window of the access window

Are you using tabbed documents?

That question was asked - energy saving are after cost of running AI which is hosted on in-house servers. The cost of their energy management app was £10k to install. With regards the initial development cost of the various algorithms, yes in the millions, but they are in the process of...

I went to a very interesting presentation yesterday on the subject. The focus of the talk was on creating a digital twin of Blenheim Palace. The concept is to digitise every aspect of the palace, gardens and other properties, the estate (circa 12500 acres), power consumption, type and quality...

Perhaps you have selected more than one control when trying to change the name? Since you appear to have already tried the other suggestions, I think need to describe exactly what you are doing to create the control and then rename it. Perhaps you are not in design view for example

cross posted here with responses https://www.accessforums.net/showthread.php?t=91338&p=537190#post537190

I don’t use one drive but to ensure the file cannot be used when in the wrong location I have some code that runs on open to check currentproject.path - if it doesn’t match the required path, it closes without warning