Post reply

Error message:Undefined Fuction "Format"

  • August 27, 2009 at 6:28 am

    #72867

    IIf(Format(Date(),"DDDD")="Monday",Date()-3,Date()-1), when I write the following code, I get Error message:Undefined Fuction "Format", what I am doing wrong.Thank you

  • August 27, 2009 at 8:28 am

    #1045571

    the following is quoted from an alternate web site, but appeared to be pertinent to this post:

    This appears to be the very common References bug. Open any module in design view, or open the VBA editor by typing Ctrl-G. Select Tools... References from the menu. One of the ..DLL files required by Access will probably be marked MISSING. Uncheck it, recheck it, close and open Access.

    If none are MISSING, check any reference; close and open Access; then uncheck it again. This will force Access to relink the libraries.

    John W. Vinson[MVP]

    Come for live chats every Tuesday and Thursday

    http://go.compuserve.com/msdevapps?loc=us&access=public

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply