Recent content by CJ_London

Bit confused - the thread title is 'Joining a table', the body about searching for a postcode. I see plenty of suggestions for searching. If it is about joining you can use a non standard join as suggested by Doc. Assuming it is about joining, your can use Like in the join e.g. SELECT * FROM...

Another option - since your main form is single move the subform in the detail to the footer and hide the detail section. Or move the footer controls to the detail section and hide the footer section

It is a form footer so appears at the bottom of the form, not just below the detail section Not clear whether you have a single or continuous form but providing you are using overlapping windows or popup you can use code to set the height of the form. Not at my computer but for a single form...

I will continue to watch this thread with amusement but will no longer take part. It's taken nearly 30 posts and a lot of wasted effort by responders for their suggestions, all rejected or ignored for one reason or another. My final suggestion is to dump the data into excel or csv file - or xml...

see post #9 for an example logic to identify records that could be moved or deleted But if deleted, there is no way to recover them If you have moved them to another archive table, use a union query to combine back with the current archive. Must admit, your question is lacking in detail. You...

About 20 years ago I had a client with a similar question. The issue was one of identifying records because using something like ‘everything before a certain date’ could remove records which although old, were still being referenced. The solution was to include a ‘last referenced date’ field...

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