Forum Discussion
TRYING TO BUILD A LOGIN BUTTON/PASSWORD
Hi there, I hope you will be able to help me. I am very new to access and managed to build a small database for my work, mainly from watching you tube videos and reading google information however, I...
Hi,
If you "automatically" get such an embedded macro every time you create a button, then the control wizard is activated, which for many years has only created macros instead of VBA. To deactivate it:
Open a form in design view and in the ribbon go to the Form Design tab, in the Controls group, click the little down button to the right of the group and deselect Use Control Wizards .
From then on when you choose Build Event in the control shortcut menu or when you click on the elipsis on an event property line in the property window a little dialog window will open that let's you choose to build a macro, VBA code or an expression. Gerrit already described how to get rid of this dialog and always land in the VBA editor.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
Hi there, brilliant thank you for this I think I have cracked it now. As mentioned I am trying to build a simple code
to be able to make my form a user log in form. I have tried watching some videos to create the code but keep getting errors. I have the following setup;
Table called: UserTable with fields UserID , Username , Password
Form called: LoginForm with username, password boxes and two buttons, logon and cancel
***************************
Is this going to be something too complex for me to do myself as a newbe to access?
Thanks again,
Andy
