Save


Saves the design, layout, or structure of a database object.

Syntax

expression.Save [ObjectType][, ObjectName] 

with the following parameters:

ObjectType

A constant of the AcObjectType enumeration specifying the type of database object to save. Possible values are acDataAccessPage, acDefault (the active object; this is the default value), acDiagram, acForm, acFunction (a user-defined function for SQL Server), acMacro, acModule, acQuery, acReport, acServerView, acStoredProcedure, or acTable.

ObjectName

A String specifying the name of the database object to be saved.

Comments

  • The Save method corresponds to the File | Save As menu option. That is, it typically saves such things as the state of an object’s design, layout, and structure, rather than the state of its data.

  • If you specify an ObjectType, you must also specify an existing object name in the ObjectName argument.

  • If you omit both ObjectType and ObjectName, Access saves the active object.

  • If you omit ObjectType but provide an ObjectName argument, Access saves the object using ObjectName, even if this amounts to a renaming operation. In this case, if SetWarnings is True and ObjectName already exists, Access will prompt you to confirm that you want to overwrite the file.




Access VBA Programming
Microsoft Access VBA Programming for the Absolute Beginner
ISBN: 1598633937
EAN: 2147483647
Year: 2006
Pages: 214
Authors: Michael Vine

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