pyaccesskit.modules¶

pyaccesskit.modules ¶

VBA modules: the db.modules collection (creating and reading code needs Microsoft Access).

Module ¶

Module(session: Session, name: str)

A standard or class module (a live, name-based handle).

name `property` ¶

name: str

The module name.

kind `property` ¶

kind: ModuleKind

Standard or class module.

code `property` `writable` ¶

code: str

The module's VBA source (without Access's class-module header).

rename ¶

rename(new_name: str) -> None

Rename the module.

drop ¶

drop() -> None

Delete the module.

ModuleCollection ¶

ModuleCollection(session: Session)

db.modules: standard and class modules (form/report modules are managed with their object).

names ¶

names() -> list[str]

Module names (read through DAO; does not need Microsoft Access).

create ¶

create(
    name: str,
    code: str,
    *,
    kind: ModuleKind = ModuleKind.STANDARD,
    replace: bool = False,
) -> Module

Create a VBA module from source code.

Option Compare Database is added if missing (as Access does); the code is otherwise stored as given. VBA source uses the Windows ANSI code page: characters outside it raise SpecError.

drop ¶

drop(name: str) -> None

Delete a module.

pyaccesskit.modules¶