-
VBA code for opening only 1 form while hiding the other.
Using Access 2013 with VBA code, i create a loginPage Form and that when you login you are granted to the main page. These part i coded but how to open only the LoginPage while hiding the other form to prevent user from seeing & changing it before entering the login/password form. ???
I mean when you open the database, you are prompted the Loginform Page and do not see any form/table in the database...
-
Dialog Mode
Set the window mode to dialog.
Example: DoCmd.OpenForm "frmLogin", , , , , acDialo
This will keep the form open before the next one is opened.
-
Yeah, i do it putting it in Dialog form but still any user can bypass the Login Page, i can hide other forms/tables manually but any user can change the options for the Navigation Option.
1. Is there any command to lock the user to stay focus on 1 form then close the form to be granted to the main page, thus preventing the user from accessing other forms/tables.
2. Or using acHidden
??
Last edited by akisch007; 11-19-2013 at 10:29 PM.
-
Never-mind, i finally solve it, with just 2 macro(consist of AutoExec) one macro for opening the form in read-only and dialog Then another macro for hiding the navigation pane.
Work perfectly,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules