Search results

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.

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

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.

The first thing to do when confronted by denormalized data coming from somewhere you have no control is to normalize it.

Instead of a PT, use an ADODB command to run the SP and Set the Form Recordset property to the returned recordset if all is well. Use TRY...CATCH in the SP and have it write any error to an output recordset. Multiple recordsets can returned from a SP to VBA via ADODB. One could be used for the...

Power factor is generally caused by the current lagging behind the voltage due to the inductance of the load. Current can also lead the voltage in capacitive loads. Either way it results in the product of the current and voltage being higher than the real power. Domestic electricity meters...

The sloping quotes are also called Smart Quotes in MS Office. They are automatically inserted into Word documents when you simply type the normal quotes on the keyboard and are a PITA when they creep into code.

The status of a record should not be determined by coping records from one table to another. The tables are the same so they should be one table. If you can be sure that only two approvers would even be needed then you could add two columns. The "approved" data are the records where both those...

Access doesn't have a problem inserting records with the value for the Autonumber column predefined, as long as it is not a duplicate of an existing value. This will also reset the sequential autonumber seed, so can be a problem waiting to happen if a record is inserted with a value less than...

Another alternative might be an Input Mask. https://support.microsoft.com/en-au/office/control-data-entry-formats-with-input-masks-e125997a-7791-49e5-8672-4a47832de8da