Strange Error Message when using Domain Functions

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David C. Holley (DavidCHolley_at_netscape.net)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 11:12:25 -0500

I just upgraded to Office 2003 and have discovered that the following
error message is returned when an invalid field is included in a domain
function (DCOUNT(), DLOOKUP(), etc.)...

'YOU CANCELED THE PREVIOUS ACTION.'

Previously, the message was a bit clearer indicating that the WHERE
statement was invlaid or that the field wasn't found.

Why?

When I first opened Access, I did select the security open to restrict
certain functions to only operating within VBA code. Would this be part
of the result of that?

David H

Relevant Pages

  • Strange Error Message when using Domain Functions]
    ... error message is returned when an invalid field is included in a domain ... statement was invlaid or that the field wasn't found. ... When I first opened Access, I did select the security open to restrict ...
    (microsoft.public.access.modulesdaovba)
  • Re: Crystal parameters
    ... But based on the error message ... Invalid field name, I think there might be something wrong with the ... "This posting is provided "AS IS" with no warranties, and confers no ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Dynamic numerical structure filed name
    ... Stéphane Bourgeois wrote: ... > I tried various things but I always get an error message (like ??? ... > Invalid field name: '1'). ... You may consider using array or cell array instead ...
    (comp.soft-sys.matlab)
  • Parameters in MS Access
    ... I'm getting an error message 'Jet database does not recognize as an ... invalid field name or expression' for the following code. ... value [yID] is invalid for some reason. ...
    (borland.public.delphi.database.ado)