Ensure that passwords are never sent across the network in plain-text form. Step #5 the mini window to enter password will pop up and require a password to open the Microsoft Visual Basic for Application to change/edit the VBA coding. Passwords protect access to the database. Step #4 Open Access file again and open the form design view then click on the Event Procedure to open the VBA code. Save and Close the MS Visual Basic for Application. Step #3 After the Project Properties window open, click check mark on Lock project for viewing and enter a password then confirm password. Step #2 Under the VB Application, click on Tools on menu bar then select file properties. Or using shortcut to open Microsoft Visual Basic for Application by pressing Alt + F11 Step #1 Open your MS Access file and open the form design view and go to the form property.Ĭlick on any event and select the Event Procedure to open the VBA program. You can protect it with the password under the MS Visual Basic for Application (VBA). Sometime you don’t want to share your code to anyone or your co-worker. The VBA coding that comes out from your knowledge and put in under the button or On Load event procedure of form (shown below) in your Access program is your property.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |