Search results

Unless you are certain that the number of images will never be more than a handfull, store and load a link to the file which is stored outside Access. Otherwise you will find your accdb growing too much.

Me.Repaint is not necessary

I think for all of us it's not if but when. I've had a couple of close calls. In March I was in a car with 4 others - one of them was diagnosed with Covid 3 days later. Even closer was last month when I travelled interstate to go to a lunch with my brother. At the lunch he went off to the...

Why variables? Hold the range values in a lookup table.

My grandson who is 12 is coming up to his birthday. I'll ask him the old chestnut about what did Cinderella turn into after 12 and expect the answer of pumpkin. And I'll say no, a teenager.

The Tory MPs will elect a new Parliamentary leader and that person will become PM. From what I've read, there is no outstanding person and this may lead to a time of instability in the Tories as there is a jostling for power.

Looks like BoJo is about to stand down, although he might continue in a care taker role in the interim. Better someone British comment on the Tories prospects for the next election. But they have been remarkably quiet on this topic so far. Maybe too polite to comment on their own politics...

In the UK government system, as with Commonwealth countries (Australia, New Zealand), the country is divided into electorates of approximately equal size of voters. Whoever gets the majority of votes in each electorate wins. The political party which has won the most number of electorates...

You could have at least prepared an input form . Why do you include 300M and 600M in your table NewEvent when they are not catered for? And this table should be Events. I earn my living from developing Access systems. I don't mind helping to solve problems but you've just banged something...

Validation is confirming data to be input conforms with your system's business rules which we don't know. One example is that a numeric value cannot be negative. Validation test would be value > 0

The WHERE in the query Forms]![Frmsub_Races]![genderID] should be Forms]![Frmsub_Races]!Form![genderID]] You got it right in the control source of txtRace in the header of the main form

CJ has it right Try changing MidStr = Len(LeftStr) to MidStr = -Len(LeftStr) 'negative

Use separate fields for Contract No, Invoice Date and Period covered. You can combine these in any printed invoice, or I'd just put the data on the invoice so there does have to be any interpretation.

Nowadays, only stars I want to see at night are the 4 or 5 stars on the motel sign out the front

My son is 95 days into walking the Pacific Crest Trail which runs from the Mexican border to the Canadian border through CA, OR, WA, total of 2653 miles. Buys food every so often at various towns on or near trail and has to carry several days water through some areas. Currently having to...

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...