Search results

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

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

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!

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?

You could also try adding custom database properties that could be used as the record source for a 'Settings Menu' form, which is a bit clunkier but stops you needed a dedicated table.

Cool, thanks. So in that case ignoring all errors in the process may indeed cause an infinite loop.

Some of you may have encountered this piece of code before from Ron De Bruin's website that lets you zip up some files. Sub Zip_All_Files_in_Folder() Dim FileNameZip, FolderName Dim strDate As String, DefPath As String Dim oApp As Object DefPath = Application.DefaultFilePath...

Good day all, Just a quick introductory post for the sake of politeness. I'm a newly starting database developer for Software-Matters in the UK, so regularly encounter Access so have signed up to share any questions I might have and wisdom I might glean. See you on the boards!