Recent content by CJ_London

would have thought creating a grouped query on qryJson would be effective dim rsq1 as dao.recordset dim sqlstr as string sqlstr="SELECT" & _ " sum(TaxableValue*TaxClassA] = 'A') as AmtA," & _ " sum(TaxableValue*TaxClassA] = 'B') as AmtB," & _ " sum(TaxableValue*TaxClassA] = 'C1') as AmtC1 ...

You start the transaction when the user clicks the save button

Yes - in the example it uses transactions and creates dummy pk & fk values to maintain the main form/ sub form relationship - typical example would be invoice or order header/rows Temp tables is another option but you would still need to manage the temp tables. A benefit of ado is it is all in...

I did a presentation recently about ado recordsets which included an example of transactions using disconnected recordsets https://www.access-programmers.co.uk/forums/threads/access-europe-user-group-wed-4-mar-using-ado-recordsets-in-access-chris-arnold.335235/

are both machines using the same version and bitness of access and what are they?

Don’t understand the question - doesn’t help that your code returns the same value regardless of true or false

In vba all numeric types (Boolean is numeric) have a default of 0 on declaration, strings a default of “”. For Booleans, 0=false, -1=true - so you can use them in calculations if you want Dates are null, variants and objects are nothing Not declaring a type defaults to variant

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