Search results

Indeed I agree that a hard drive reformat would be a serious step that may not even help, so that should be absolute last resort! Did you find anything to help you elsewhere yet?

Ah okay, well I hope you find it quickly, these sorts of things can be a nightmare!

I'd say a difference exists between your psots, probably because you used the term 'Ice Age', which implies changes more extreme than just greater seasonal variations.

The circular reference must mean that in some way the formula have made is referring to something that itself refers to the formula you are currently writing. E.g. [Result1] = [Symbol] & [Field2] [Field2]= [Symbol] & [Result1] To know Result1 I must know Field2, but to know Field2 I must know...

For it not to work in such a simple case my first guess would indeed be something fundamentally wrong with Access, especially if it just started happening randomly. If the repair didn't solve it as it did for JHB then perhaps a complete uninstall and reinstall would get it back up and running...

Absolutely correct. Hard to explicitly prove in a forum debate, but suffice to say the proofs exist in detail and are attested to by the body of experts concerned. Since this issue has a powerful scientific consensus, one of the strongest ever demonstrated, it is hard to argue that the...

Simply because global warming is a long term trend, one of the effects of which is increased occurrence of extreme weather events, which can include unusual short-term cold periods. So it's extremely cold for a few months here and there (and extremely hot just as often if not more), but the...

What have you tried? I'm sure if you right click or double click on the legend you can open a format menu for it to decide these sorts of things. If not, perhaps check your general Excel options to make sure you haven't set the Indian numbers as a default format for charts!

Believe it or not, the people who work on this sort of thing DO know about these issues and have taken them into account, however the evidence for short-term human influences being the main cause of the recent changes is overwhelming compared to the slow and more minor (on short-scale) natural...

I think you can do something like Format([Amount],##.00) if I remember correctly. Might need quotes around the format choice, like "'##.00". In fact I think you will need those quotes so try Format([Amount], "##.00").

Glad to be of service!

The '&' symbol is used to join things from different sources together in a single field. So someting along the lines of [field] = [CurrencySymbol] & [Amount] where amount is just the number. And and if you wanted a space between the symbol and the amount, then you can add in a space via a...

One day, VBA will be cool...

I suspect that instead of having the control on the report be 'currency' format you can make it not try to fit any format to the data and just literally pull it through, then if your stuff is already in the right format hopefully it won't have changed anything. Perhaps format the control as...

You will need to check to see if you are on the last record in the code and if so not have it move to the next one. For example: If Me.CurrentRecord < Me.Recordset.RecordCount Then DoCmd.GoToRecord , , acNext Else '[If the condition is not true, then we are on the last record, so don't...

Very sneaky! That does sound quite possible to me; if you made some queries that only returned people with TrainingTime>8 hours then you'd have a list of people to certify for example. Similar for the alert, you could have query of people for whom Now-StartDate > 10 months And TrainingTime < 8...

Never seen that happen. I suspect you'll need to post more specific details about what you were trying to put on the report for us to have any idea of the cause.

Bit late to ask this question considering this happened 3.5 years ago now!

If its the value not always being input that is a problem you might want to play with Nz functions. Like have Nz(Me.PhysicalExpires,Date(Now())) which means if Me.PhysicalExpires is null, just use the current date.

That's what google claims your question is in English! As for the problem, I'm surprised it can't be removed. Have you tried deleting the entire record, or did you just try to delete the piece of data that was an error?