Search results

I was working with collections for the first time yesterday and came across a couple of oddities. I was adding 7 objects, each with a unique string key. The first five objects were added fine, the last two were silently ignored. These had keys with square brackets like "[key6]" and "[key7]". Not...

If I enter an expression with optional criteria as the Default value for a control, so the first criterion is missing and the second isn’t, I get the following error: This doesn’t happen in code. e.g. using Allen Browne’s ELookup function (ELookup(Expr, Domain, [Criteria], [OrderClause]) I...

Hi everybody. I've developed solutions in Access on and off since 1996. Default forms definitely look better now than the horrid dark green of then. I'm entirely self-taught in Access, but have formal qualifications in computing and informatics. Because my use of Access is on and off I tend to...