Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Valentine, New South Wales, Australia
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding forms for good (Access XP)

    Does anyone know of a method for hiding a form for good so it cannot be unhiden. I need to execute certain checks and set various setting after a certain lenght of time so I want to open a form with a timer. However, I do not want the user to see or be able to unhide the form and make changes to the code on that one form only. I do not want to create mde file or set security but I do want to hide a timer form from everyone (including me). If I need to work on that form I will work on the Work in Progress database and then hide the form before giving it to user. Can this be done...

    Thanks to all

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

    Re: Hiding forms for good (Access XP)

    I don't think you can make the form completely inaccessible if you don't want to implement user-level security or make an .mde. You can secure the code in the database with a password (select Tools | <project> Properties in the Visual Basic Editor, Security tab).

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Hiding forms for good (Access XP)

    You could change the name so that it starts with "Usys". This isn't foolproof, but it will remove it from the database window.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Hiding forms for good (Access XP)

    As Mark notes, you can make it not visible in the database container (as long as the view system objects is not checked), but you don't really want users working in the database container window anyhow. You really should reconsider activating user security - it's not very difficult and will make a host of other things possible. In addition, you probably want to create a custom menu so users can't do a Window/Unhide command.
    Wendell

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding forms for good (Access XP)

    How about running a macro on your timer event.

    You can use the macro to open a form in hidden mode, that way your users won't see the form but you'll know it's there.

  6. #6
    New Lounger
    Join Date
    Sep 2002
    Location
    Valentine, New South Wales, Australia
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding forms for good (Access XP)

    Thanks to everyone for you feedback.
    May have to look for another solution or inforce security.

Posting Permissions

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