Search results

I think it's a load of old nonsense, but I'm worried. Worried because there are idiots out there who believe it. Who knows what kind of stupid things they might do?

I've been using Office 2007 every day for over a year now and I still really dislike it. The ribbon menus are just a flawed concept, IMO - they take up a massive wedge of screen real estate, I *still* can't find my way around them and I find the graphical icons pointless and patronising. If I...

So in this case, store the manual override as some kind of offset, zero if no override has been imposed? - and make it part of the calculation?

Except the value the OP is talking about is sometimes the straight calculated value, and sometimes it's overridden by some other value that is not the pure result of the calculation. How should that be handled?

This page has some suggestions that might help: http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

if it's a divide by zero problem, I'm surprised it's not falling over altogether. You could try Iif(B<>0, A/B,0)

Could it be a VBA/Macro trust issue? (Is the text box populated by code?) Do button and other events work OK?

It's a remarkable stroke of luck you were passing by, Mark.

Are there any missing references? I've found that some of the ordinary form controls sometimes don't work (or appear at all) if I switch versions and don't replace a missing reference for something I would have thought quite unconnected to form controls (such as the Outlook library) To check...

Ah. The underlying query was using Nz, but didn't need to - because I do actually want null fields to be blank. I removed the Nz and it works as expected now. (by significant figures, I mean that I was getting currency values such as £28.50 displayed as 28.5) Cheers

I've got a report on which the detail section contains three text boxes with currency values in them - these values are based on a summary query which in turn is based on a table in which the data type is currency for all three fields. When I set the Format property for these text boxes to...

I agree that numbering an alphabetic list of unique items is in many cases redundant, however, what would be redundancy in purely electronic data often becomes a necessity when it has to go out into meatspace. For example, with a printed, non-numbered alphabetic list of names used for...

It sounds like they need to be numbered to comply with some military protocol for sending messages - if that's the case, arguing that the number is redundant is probably about as useful as beating your head with a stick. The messages need to be sent in alphabetical order of name, and they need...

There have been some threads on this board on numbering query results in the past - I can't seem to find them at the moment - but you might like to try searching on terms including numbering, query, autonumber, results...

Is the requirement to number the records one that is imposed by operational protocol, rather than database design?

Power corrupts - so they say, and I see no counterexamples in the world of politics. We're going through a massive media circus here in the UK over politician's expenses. The previous (opposition) government did the same thing, so it's obviously just a case of opportunity bringing out the...

Is it possible to perform the two different joins in separate queries, then use a third query to bring them together?

This. I was victim to it with the switch from ISBN 10 to ISBN 13, on a system someone else had developed, and (along with a bunch of horrendous normalization and other issues) it was so deep and serious a problem, there was no way to fix it. Quoted for truth. When people say "this numbering...

As you're a spammer, I would suggest you solve the problem by climbing to the top of a high mountain and staying there forever.

I try to adhere to naming conventions for tables, fields, forms, reports and variables, but I find it difficult to be bothered to do the same for controls on a form or report. I often write the comments before any code - using them as placeholders and reminders of what each process needs to do...