Recent content by MikeT1941

Fine. I didn't know they were not required. I will try it with them removed.

yes, thanks Pat, that's one reason doing the various mods took so long as there are more ways of doing brackets wrong than there are of doing them right, but I believe these are now correct- they have not been found out yet but I am keeping my eyes open.

Certainly, Gasman; date format as per AB. My financial year is 1st April- 31 March so I believe is correct., but always good to check- thanks.

Well, I said I would update you on what happened, so I will. I have been through a great learning curve in the last few days, although it seems a lifetime! Thanks to Pat, I now know more about VBA. Doc-Man's comment in #6 and Colin's demo triggered something in my mind- was I going the right...

I'm so embarrassed at not having replied: Thanks, Pat for putting me right on the variables I'm looking at a new approach- to do the manipulation in the report rather than worrying about "accruals" or such like. Shouldn't be long now! :confused::confused:

Many thanks CJ- I'll get on with it and report back

CJ Wow- never even used a Union Query. Would be delighted to see an alternative approach but I don't need it tonight. Please don't stay up late for me!! Mike

Hi DocMan Thank you for the tip about closing recordsets- I said I was ignorant. As to the three entries: I add a figure say £350 when it arrives so that has to be reconciled with the bank account. That's record 1 About 42 days before these guys start their holiday I can treat their payment as...

Good evening all This must be very basic, but I am still no better than I ever was at VBA but would like to crack this one with some help. The purpose is to record a payment into the bank as a "Client Deposit" and then use that data to create two ledger entries. The first one deducts the amount...

Well guys you did it. BalTrial: CCur(DSum("CalcTodaysValue","BillsIssuedAndPaidQuery","[keytest]<=" & [keytest] & " And [HistoryID]=" & [HistoryID])) The difference appears to be that the formation of the keytest index, which was the invoice date plus the value of the index of the subform, had...

Single conversion removed- call it brain fade! I tried the new version of BalTrial without CSng but regret that it "was not correct syntax"

My apologies for not being clear. No, it doesn't work. As you suggested, I've removed the HistoryID from the key and transformed it to a number without difficulty this time. Query is sorted by HistoryID and then by Keytest Forget about the syntax- I think I have it now. The new BalTrial wording...

OK- here we go. I made slight alterations to the code for keytest to produce the following key 006951838102000025, being one of the first ones. The key wording is................... keytest: (Format([HistoryID],"00000") & Format([InvoiceDate],"yyyymmdd") & Format([ID],"000000")) This gives me...

Thanks CJ- I was just shutting down so will try that in the morning. Much appreciated. Mike There are 600 pags in the ledger- I've only entered 50 and not entered every detail of them -so there may well be loads and loads! Oh for a quill pen.

Oops!