• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Setting Project Properties

By default, Access assigns the same name to the project containing your VBA modules and procedures as your database's name. You can change the project's name to make it more descriptive. You can also password-protect your VBA project to keep other users from accessing and changing your procedures.

Set Project Properties

Open the Visual Basic Editor by pressing and holding Alt while pressing F11.

Select your project from the list of projects in Project Explorer.

Click the Tools menu, and then click ProjectName Properties, where ProjectName is the current name of your project.

Click the General tab.

Enter a new name for your project, if necessary.

Enter a description of your VBA project.

Click the Protection tab.

Click the Lock Project For Viewing check box if you want to keep others from viewing your project's source code.

Enter a password to unlock the project for viewing.

Confirm the unlocking password.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint