Access Datasheet Conditions

The Visual Basic 6 code-fragments below are included in the Code-VB fragments library. Fragments are snippets of code you can insert in your procedures. Each item between braces correspond to a variable of the given type. They are replaced with the new or existing variables by Fragment Builder in Code-VB tools.

Datasheet Is Open

Attribute VB_Name = "Module2"
(SysCmd(acSysCmdGetObjectState, AcForm, {STRING:strForm}) > 0)


Delete Record Allowed Datsheet

{FORM}.AllowDeletions


Edit Record Allowed Datasheet

{FORM}.RecordsetType <> 2 AND {FORM}.AllowEdits = True


Filters Allowed Datasheet

{FORM}.AllowFilters


Is in Designmode Datasheet

{FORM}.CurrentView = 0


New Record Allowed Datasheet

{FORM}.AllowAdditions


Access Datasheet Conditions New Record Allowed Datasheet