My Database has gone "funny"

[bellevue]

I really hope someone can help please.



I have a database which is quite large; anyway, in some of the form fields, I have formulas that perform calculations.

All of the sudden, the fields that have these formulas in are showing "#Name?" instead of the result of the formula.

I've had a look at the formulae and the fields names are entered correctly (e.g. =[Holiday Cost]+[Weekend Surcharge]+[Minimum Charge]) and the formulas all make sense.

Can anyone help me identify what's gone wrong with the database please ?

I don't know if this is relevant but I have been experimenting with Modules and have changed some of the settings in Tools > References; I think I ticked "Microsoft DAO 3.6 Object Library" and "Microsoft Word 9.0 Object Library"; they are both unticked now, I didn't know if that would make a difference ?

Any help would be very gratefully received.

Thanks

[RuralGuy]

If this is truly resolved, would you care to share your solution with others that read this Forum?

[bellevue]

I had two instances of the same function which confused the database.

Thank you for your prompt action in bringing this matter to my attention; it is reassuring that there is someone "chasing" the many, many, many threads that are marked as solved but fail to contain a solution to help others.

Your reputation will grow as I see these posts altered thus assuring me that your role is effective.

Best wishes

[RuralGuy]

Thank you for posting back with your solution.