Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    56

    Question Unanswered: Unusual form error in ACC 97

    Hi, not sure if anyone has run into this. I am creating an administration database to help manage the 300+ Access databases this organization currently uses. Unfortunately, I have had to develop this in Access97. Anyway, I have code in a particular form in a 97 database that acts rather odd.

    The command button calls a function that performs a modification to the .properties("description") of any given table in the named database correctly. However, if the command button is clicked again after the command button action completes, the form goes into hide mode. I have to manually unhide the form.

    I have turned debugging on, and that has not provided any information. I have also included code to ensure that the form is in a visible state, but that has had no effect.

    The form is not bound, as I execute all SQL within the form or from modules. Curious if anyone else has run across this issue and if they were able to resolve it.

    Thanks,

    John

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    What does your code look like for opening and closing database objects? I am thinking it might be how you 'cleanup' your database object(s). Does the code execute properly the second time? I would try, temporarily, commenting out the code that cleans up database objects and see if the problem goes away.

  3. #3
    Join Date
    Feb 2006
    Posts
    56
    fixed it. thanks my friend. it was a wierd error related to an activeX control.

  4. #4
    Join Date
    Jun 2004
    Posts
    50
    Please post the fix.
    Monk
    The person who confesses ignorance shows it once; the person who conceals it shows it many times.

Posting Permissions

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