Results 1 to 12 of 12
  1. #1
    Join Date
    May 2013
    Posts
    56

    Unanswered: Undefined Function

    I have queries that were working perfectly and now I get the error message that the Format function is undefined. Help, where are the systems functions stored and I can recover them?


  2. #2
    Join Date
    May 2013
    Posts
    56
    I have queries that were working perfectly and now I get the error message that the Format function is undefined. Help, where are the systems functions stored and I can recover them?
    I am using Access 2013

  3. #3
    Join Date
    May 2013
    Posts
    56
    One additional thing that I noticed. I use the Date() and Time() functions on my Home Page and I don't see that date or time displayed......just NAME?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    in a code window check the project references
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    May 2013
    Posts
    56
    I looked at the project references and there are 4 checked but I don't know which ones I need

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I would expect at least one to be prefixed 'missing'
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    May 2013
    Posts
    56
    When I went to look I went through the create and Module 1 was created. When I tried to remove it I got an error message Microsoft Visual Basic for Applications -- File not found. But I see it on the list. I am very confused. The first time I looked yesterday there were other projects above the application that I created. I don't remember the names but there were just letters not actual words (sounds crazy, but I don't remember) could they have been deleted?

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you may well have an Access file corruption

    first off take a copy of the file
    compile the code, fix any errors

    try a compact and reapir

    if all else fails create a new blank access file
    then import all objects from the old file

    is your database split into a separate front & back end
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    May 2013
    Posts
    56
    I am trying a compile and the first error I get is Expected: Identifier

    It is a form and the only statement in the code is Private? I created most of the application without VBA code. SO I am lost

  10. #10
    Join Date
    May 2013
    Posts
    56
    Yes, my database is split and I create a runtime version for users to update.

  11. #11
    Join Date
    May 2013
    Posts
    56
    I did a compile, did not fix error, did a compact and repair. The time and date now appear, but I still get the error on an embedded macro for using the FORMAT$ function

  12. #12
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Given everything you've said, I suspect that healdem's guess on corruption is probably right! Given that, his advice

    Quote Originally Posted by healdem View Post

    ...if all else fails create a new blank access file then import all objects from the old file...
    is probably the next thing that you should try.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •