RE: Setting references in runtime application

From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 03/16/04


Date: Tue, 16 Mar 2004 05:51:43 GMT

Hi Jean,

If I understand correctly that you encountered the following error message
when you use Format function in your user's laptop.

"The function you entered can't be used in this expression."

If I have misunderstood, please feel free to let me know.

Based on my experience, this error is always caused by the reference
problem. Please check the reference of the Access database in the laptop.
(In the VBA environment, Tools -> References)
a. Check to see if there is any missing reference.
b. Check to see if there is any strange reference added in the list.

In the meantime, please apply the latest version of MDAC on the laptop.
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.



Relevant Pages

  • Re: Query Problem
    ... Uncheck that reference (or find its location, ... the error message specifically mentions the Format function. ... >> Vanderghast, Access MVP ...
    (microsoft.public.access.queries)
  • Re: Halt screen startling inexperienced users
    ... No, it didn't work, but it did change my error message to ... required to display that Active X control (instead of the ... Objects 2.1 Library Reference and 2.5 Library Reference. ... On opening the report the macro opens the user ...
    (microsoft.public.access.macros)
  • Re: Word Automation printing problem
    ... It doesn't seem to relate to the error message, ... > reference to the Microsoft Word Object Library 10.0 in my 2002 Access; ... > Set appWord = GetObject ... > Set Docs = Nothing ...
    (microsoft.public.word.vba.general)
  • Re: Could not copy temporary files to the output directory
    ... VS.NET it gives an error message and ask me to report this bug.... ... > reference'. ... > the problem is that I randomly get errors that my dll could not been ... > have those problems just after having opened visual studio, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Configuration Error...
    ... An error occurred during the processing of a configuration file ... Parser Error Message: Access is denied: 'WebChart'. ... LOG: DisplayName = WebChart ... LOG: Post-policy reference: WebChart ...
    (microsoft.public.dotnet.framework.aspnet)