Results 1 to 3 of 3

Thread: Access

  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: Access

    The problem is as follows:

    Access 2000 application used within a business department but on certain PC's a particular button click doesn't appear to be executing the code behind it. This button click event works fine on most other PC's except these few. When I login as the same user (who experienced the problem) and step thru the code behind the button event it works fine.

    The problem PC's have a Office SP1 or SP3 installed so I don't think this is the issue.

    If anyone has info on this kind of problem please let me know,
    thanks

  2. #2
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303
    Testing things like this can be a pain.

    Try putting in a msgbox in various parts of the function. Then access the button without debugger and see if 1) the function gests called and 2) move the msgbox around to see how far the code execution goes.

    Are you trapping errors?
    At the beginning of your procedures,

    On error goto ErrorHandler
    .
    .
    code
    .
    .
    goto EndSub 'skip error handler if all is well

    ErrorHandler:
    msgbox "MS Access error:" & err.number & vbCrLf & err.description

    EndSub:
    End Sub
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

  3. #3
    Join Date
    Dec 2003
    Posts
    5
    Thanks jpshay, I put in one message box and it started to work, so I changed the message box to display a "Process starting" message and left it at that. I would love to discover the really reason why this is happening but I don't have the time.
    Thanks for you suggestions, much appreciated

    Dmca

Posting Permissions

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