Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password Protected Form (Access 2002)

    I am using a procedure defined in Microsoft Knowledge Base Article-Q209871, (How to Create a Password Protected Form or Report). The form that I applied this code to is the Switchboard. The Code runs okay and opens up the Main Switchboard Page after the correct password is entered. Now that the Switchboard is open the problem I am having is as follows:

    When an item on the Switchboard is selected which was defined using the Switchboard Manager to open a form or run a report , the form will open or the report will run. However when an item is selected on the main Switchboard Page that was defined using the Switchboard Manager to go to another Switchboard Page nothing happens. The Switchboard page will not open.

    Just wondering if anyone has run into this problem or am I just overlooking something, I sure would appreciate if anyone has a solution to this problem.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Password Protected Form (Access 2002)

    It works OK in Access 97. I don't have XP, so I can't check what's going on, but I suspect it may be caused by confusion between DAO and ADO. The code from the MSKB article uses DAO, whereas the code behind the switchboard in XP uses ADO.

    In Access 97, the routine handling button clicks was a function named HandleButtonClick. I don't know if this is the same in XP. You might set a breakpoint at the start of this function or its equivalent, open the Switchboard, click a button and then single-step through the code. Try to find out what happens.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protected Form (Access 2002)

    You could also try this simple test:

    Put a message box in the on open property of the form just before the block of code that runs the password test.

    Now when you use your switchboard see if this message box pops up on other occasions than just the on open.

    It should only pop-up once, when you first open the switchboard.

  4. #4
    New Lounger
    Join Date
    Jun 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protected Form (Access 2002)

    Thanks for the help on this problems. Your suggestions lead me to look at the code. What I found is, that when I converted the 2000 database to 2002 some of the code was not carried over. When I put the code back in. everything begin to work as it should.

Posting Permissions

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