Search results

Putting error handling message in every Function can be a bad idea if the function is being applied to the data. It will throw the error repeatedly if there is a problem. Often it is better to return the error from the function as an out of scope return value. For example, if all expected...

It is still winter in Australia and we are experiencing summer temperatures with many locations having maximums up to 17 degrees Celcius (30 F) above average for this time of year. The snowfields have melted after being blasted by hot winds "like they were coming from a hair dryer". Down on...

I have very broad tastes in music but I cannot stand Luciano Pavarotti. He did a hopeless series of duets with great singers. I thought there might have been so chance of a Eurythmics classic he did with Annie Lennox but he couldn't even do that with any talent.

This is what Pat is talking about. Put this in the Format property of the control or field. You can use the usual formatting instead of the the plain # #;#;; They represent the format for positive, negative, zero and text or null respectively Unlike the clumsy function suggestions above, the...

ID has never been required for elections in Australia and there has never been any evidence of a problem. We have compulsory voting with very small numbers not showing up to vote, so pretending to be someone else to get a second vote would likely raise an error when it is audited. We also hold...

The Brits don't know how to hold an election any more the US. Both use the hopeless first past the post system. In Australia we have preferential voting which makes it possible for minor parties to participate in a real contest, instead of just two huge parties controlling everything.

Meanwhile you are satisfied with anything that matches your prejudices. It is called Confirmation Bias.

Oracle VM VirtualBox is free.

The division by 100 at the end of the calculation suggests to me that the developer may have simulated Decimal data using long integers. Long integers will calculate the result as long Integer so will overflow if any part of the result is > 2^31 - 1. The values could be converted to one of the...

Don't be tempted to do what many inexperienced developers do and process all the dates in the table. It is very inefficient Create a condition: WHERE Callgivendate BETWEEN DateSerial(DatePart("yyyy", DATE()), DatePart("mm", DATE()), 1) AND DateSerial(DatePart("yyyy", DATE()), DatePart("mm"...

Use CurrentDb.Execute with dbFailOnError. It doesn't produce warnings but won't ignore errors. If it is on, which it is by default, renaming objects will propagate to other objects that use them...

Do you have NameAutoCorrect turned off?

So how is your code going to work when you have more than one person with the same FName? Looks like you will only ever see the first one.

Object Dependency doesn't find everything in my expereince but I have not used it for more than a casual check on tables and queries for a very long time. I'm a big fan of VTools Total Search which I have always found reliable.

Clearly you are not paying attention.

Take notice of this solution. It not only does the whole job in a single query, it also allows an index on DateCompleted to be used. This will be massively better performing than any query (including a DSum) that has to apply functions to every record in the table before selecting. It is...

I've never heard anyone call it "Durex" in Australia. Where I have lived it has always been "sticky tape".

I worked with a guy who had been a boilermaker. He said the conversion to metric was the best thing that ever happened, Take a pipe with a flange 48 inches diameter at the holes. The plan requires drill 32 holes so calculate the circumference at the holes. They are 4.71238898 inches apart. That...

Except a mile is 5280 feet so your conversion is well off.

Incorrect. A metric ton (tonne) is 2205 lbs. A ton is 2240 lbs.