Results 1 to 1 of 1

Thread: Access No Longer Reading Modules [RESOLVED]

Threaded View

  1. #1

    Thread Starter
    Addicted Member MethadoneBoy's Avatar
    Join Date
    Oct 2001
    Location
    Preferably somewhere between Keira Knightley and Diane Kruger but I'm not fussy
    Posts
    180

    Access No Longer Reading Modules [RESOLVED]

    Hi guys,

    This is a very frustrating problem. An Access Query that I've written that accesses a method in a module has stopped working, for no apparent reason. Previously, it was working just fine - I haven't changed any of the parameters or values being placed into the methods. Now, whenever I try to run it, I get the message "Compile error in query expression".

    Does anyone know what might be causing this? Has anyone here had a problem like this before?

    Thanks


    EDIT: Problem solved - I was assigning a value to a variable outside one of the methods - D'oh!
    Last edited by MethadoneBoy; Jul 15th, 2005 at 06:33 AM. Reason: [RESOLVED]
    "'Oh, hello Mr. Crick! What do you think of Jeffrey Archer?' Clip-clip-clip! Oh, come on! Who are you kidding? You wait til I'm mayor, you'll see how tough I am! Christ almighty...."

Posting Permissions

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



Click Here to Expand Forum to Full Width