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

graphics/1_icon.jpg

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

graphics/2_icon.jpg

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

graphics/3_icon.jpg

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

graphics/4_icon.jpg

Click the General tab.

graphics/5_icon.jpg

Enter a new name for your project, if necessary.

graphics/6_icon.jpg

Enter a description of your VBA project.

graphics/7_icon.jpg

Click the Protection tab.

graphics/8_icon.jpg

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

graphics/9_icon.jpg

Enter a password to unlock the project for viewing.

graphics/10_icon.jpg

Confirm the unlocking password.

graphics/11_icon.jpg

Click OK.

graphics/14inf10.jpg

Did You Know?

You need to remember your project password . Save your password. If you lose it, you will not be able to open your code to edit it later.




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net