Hiding forms for good (Access XP)

Topic

New Reply

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

Reply | Quote

Replies

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 | Properties in the Visual Basic Editor, Security tab).

Reply | Quote

You could change the name so that it starts with “Usys”. This isn’t foolproof, but it will remove it from the database window.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote