Recent content by CJ_London

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

And where and what is the back end?

not tested, but if you want to set the filter in the open event, try setting the filteronload property to true (shouldn't need filteron=true). At the time of the open event, there is no data to filter, that only becomes available in the load event

How do you verify that? By hovering over the rs!age in the vba? and why when you said this?