Results 1 to 5 of 5
  1. #1
    Cheshire101 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    42

    Question F11 deactivate

    Is there a way to stop soemone from using F11 and alt F11 to access the navigation pane and code?



    Also, is there a way to stop the code from going into a debug option if it encounters an error?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    to stop code interruption, use error handlers. you should be using them anyway.

    to stop F11, and Alt F11, try unticking the "use special keys" box in the access options of that file. Or...deploy a runtime version of the app.

    for code protection, you can always password protect the vba project via the menus. I don't believe that prevents code execution....just openly viewing the code.

  3. #3
    Cheshire101 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    42
    Can you help me with the password portion? I know how to create a password for the database but not a password for just viewing the code in the background.
    I did set the "use special keys" function.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    vba editor > tools menu > properties > protection tab

  5. #5
    Cheshire101 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    42
    worked like a charm..
    Thank you

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums