Alison Balteramp;#039;s Mastering Microsoft Office Access 1002003 [Electronic resources] نسخه متنی

Importing and Exporting Code Modules

The Access 2003 VBE allows you to import code or form modules into, and export code modules from, a database. To export a form or code module, take the following steps:

When you export a module, it is exported as an ASCII text file. You can import the text file into another Microsoft Access database, into any other Microsoft Office product (for example, Microsoft Excel), or into a Visual Basic project.

NOTE

If you export a Form module from the VBE, Access exports only the Class module behind the form. It does not export any visual aspects of the form.

Just as you can export a text file, you can import a text file. This allows you to add an existing module or form to a project. Access copies the file and imports it into the database. It does not affect the original file. To import a file into your Access database: