Search results

Doc, happens everywhere just that in civil service it's easy to survive in that state longer. Peter Principle reigns supreme - one rises to their level of incompetence (or above).

Certainly a lot of energy. I couldn't compare drummers but reminds me when John Lennon was asked about Ringo Starr's drumming skilled, he replied that there were plenty of better drummers and Ringo wasn't even the best drummer in the Beatles.

The getting of the OP's business rules has been like drawing teeth. In formulation heats, I expect there will also be restrictions on gender, category (eg Under 16) and event type (eg 100m, 200m)

With the last example, instead of 5 heats of 8 and 1 heat of 4, wouldn't you prefer 4 heats of 7 and 2 heats of 8 Algorithm is divide number of contestants (C) by 8, round up to next whole number (N). Remainder (R) is N*8 - C Have R heats of 7 and (N-R) heats of 8

The 2022 Strategic Investment Conference of big finance/corporate currently being held for top finance/investment people. This is from the notes of one of the attendees. One of the speakers, Dr. Frank Luntzy said to think of the US population as one big family. Well, one big dysfunctional...

I can walk from my house to my favorite watering hole in 7 minutes. The walk from my favorite watering hole to my house is over 20 minutes. The difference is staggering.

Or forward thinking by the Russian military?

I had a top and end checkup during the week - colonoscopy and gastroscopy. I've reached an age where medical advice is for routine checks - annually for gastroscopy and three yearly for colonoscopy. I've had polyps removed from both ends in the past. Preparation for the gastroscopy is easy -...

And, not understanding the language, your point is?

Too easy to slip on that sort of thing. Me too. Important thing is that the information is right.

I think 2 should be 2. Form bound to Program, subform bound to Program_trainer with a combobox to select trainer

To me, a quarter (timewise) means a specific quarter of the year eg Q3 2021 or Q2 2022. Is the real question, the number of quarters between two dates. So if the start date was in Q3 2021 and end date was in Q2 2022, then the number of quarters would be 3

But not test the code by debug.print GoSub xxx

Instead of recreating the tables with the consequent bloat, you could try to change the field names. If this process is being done daily, there would only be one field to change name.

I've not come across an .MER file before, certainly not in an Access context. From what I can determine by searching, an MER file is a complied MED file created by RSView, and has something to do with controlling factory software.

I have a goto in most procedures On Error Goto ... :)

Depending on your data, the recordset returned from your query could have none, one or many records. Because you have selected a number of fields in your query, each record that exists in the recordset would have the contents of the the fields selected in that recordset. For example, the first...

Try Private Sub chkShowRetired_Click() If chkShowRetired.Value = True Then Me.filter = "[AssetCondition] = 'Retired'" ' <<<<Missing Me.FilterOn = True Else Me.Filter = "[AssetCondition] <> 'Retired'" Me.FilterOn = True End If End Sub

Fine if there is say only two addresses (Billing and Shipping) but what about the case where a customer has multiple depots to here orders are to be dispatched.

I now wish I had not used the example of yearly prices as a date range related price. I did come back to your example of a pricing table which defined for any date range, the price applicable. Negative returns can be handled by finding the price applicable to the order in the pricing table and...