Visual Basic 6 and VBA code fragments for 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
• Delete Record Allowed Datsheet
• Edit Record Allowed Datasheet
• Filters Allowed Datasheet
• Is in Designmode Datasheet
• New Record Allowed Datasheet

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