Search results

The trainee aircraft pilot had as his final test the object of flying a tin a paint to a destination following a complicated route. I can report that the trainee passed with flying colors.

I also use macro recording and customize. Then set a stop point in your code and step through to check that your code is doing what you want.

Pope visits US. Has a limo allocated with a black female driver. Pope wants to go on a road trip, and decides he wants to drive, they swap places. Highway patrol pulls over the limo for going too fast. Looks at the driver, then the passenger. Immediately contacts station sergeant saying he...

Embelish this. Floods, minister is on the roof, dinghy comes by and offers to take the minister who says "God will save me" and turns down the offer, similarly with an emergency services boat, then a chopper. All the time water is rising and when the inevitable happens, the minister asks God...

And SuperStar which I think was the spreadsheet equivalent is said to have brought the PC to the business world out of the typing pools.

I've never had to use Repaint after a label caption change. But you are right on a belts and braces basis.

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