WindoПочему



- не работает, в то же время если вызвать функцию summ(A) из модуля, то все в порядке?
Ошибка method or data member not found.

А вы вообще хэлп, хотя бы примеры кода, смотрите? Или полагаетесь на свою опытность...
Или там всё ясно, но также сделать не выходит?
Summ - это что? Член этого модуля?
Заодно, когда разберётесь, следите ещё, чтобы одинаковых названий не было.
А то вы так именуете, что субботний вечер занят...

contains all open Module objects, regardless of their type. Modules in the Modules collection can be compiled or uncompiled.

To return a reference to a particular standard or class Module object in the Modules collection, use any of the following syntax forms.

' Syntax Description
Modules!modulename The modulename argument is the name of the Module object.
Modules("modulename") The modulename argument is the name of the Module object.
Modules(index) The index argument is the numeric position of the object within the collection.

' The following example returns a reference to a standard Module object and assigns it to an object variable:




Note that the brackets enclosing the name of the Module object are necessary only if the name of the Module includes spaces.

The next example returns a reference to a form Module object and assigns it to an object variable:



To refer to a specific form or report module, you can also use the Form or Report object's Module property:


The following example also returns a reference to the Module object associated with an Employees form and assigns it to an object variable:




Once you've returned a reference to a Module object, you can set or read its properties and apply its methods.
авторModule Property
See AlsoApplies ToExampleSpecificsYou can use the Module property to specify a form module or report module. Read-only Module object.



expression Required. An expression that returns one of the objects in the Applies To list.


The Module property is available only by using Visual Basic and is read-only in all views.

The Module property also returns a reference to a specified Module object.

Use the Module property to access the properties and methods of a Module object associated with a Form or Report object.

The setting of the HasModule property of a form or report determines whether it has an associated module. If the HasModule property is False, the form or report does not have an associated module. When you refer to the Module property of that form or report while in design view, Microsoft Access creates the associated module and sets the HasModule property to True. If you refer to the Module property of a form or report at run-time and the object has its HasModule property set to False, an error will occur.

You could use this property with any of the properties and methods of the module object.

Example
The following example uses the Module property to insert the Beep method in a form's Open event.



See AlsoApplies ToExampleSpecificsShowType property as it applies to the AccessObject object.

Returns the value of an AccessObject object type. Read-only AcObjectType.

AcObjectType can be one of these AcObjectType constants.





expression Required. An expression that returns an AccessObject object.

ShowType property as it applies to the FormatCondition object.

Returns the value of a FormatCondition object type. Read-only AcFormatConditionType.

' AcFormatConditionType can be one of these AcFormatConditionType constants.





' expression Required. An expression that returns a FormatCondition object.

ShowType property as it applies to the Module object.

' Indicates whether a module is a standard module or a class module. Read-only AcModuleType.

' AcModuleType can be one of these AcModuleType constants.





expression Required. An expression that returns a Module object.

' Example
' ShowAs it applies to the Module object.

' The following example determines whether a Module object represents a standard module or a class module:

Создайте новый модуль (Insert- Module)
и попробуйте так: