Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

DoCmd Examples - Access VBA
Open Form DoCmd

Docmd Macro VBA Example






DoCmd AddMenu
DoCmd ApplyFilter
DoCmd CancelEvent
DoCmd Close
DoCmd CopyObject
DoCmd DeleteObject
DoCmd FindRecord
DoCmd FindNext
DoCmd GotoControl
DoCmd HourGlass
DoCmd Min/Max/Restore
DoCmd OpenForm
DoCmd OpenQuery
DoCmd OpenReport
DoCmd OutputTo
DoCmd RunSQL
DoCmd SendObject
DoCmd TransferDatabase
DoCmd TransferText

Create Export Specs

 

Microsoft Office:
  MS Access 2003
  Access 2007
  Access 2010
  Access 2013


Microsoft Access Docmd.OpenForm Example

access openform example
(the command line is continued below)
openform command in Microsoft Access

The arguments for the Open Form method are as follows:
FormName - A string or string variable that contains the name of the form to be opened.

View - The presentation format of the form to be opened.  The view argument has the following options:



Are you just starting out on your quest for a database? Need some advice or someone to bounce ideas off of? We are here and will be happy to chat with you on the phone and discuss options to your situation. Visit our contact page and give us a call.

Are you looking for an MS Access template database? We have many for sale in our Access Template and Examples Software section.


acDesign
acFormDS    (datasheet view)
acFormPivotChart
acFormPivotTable
acNormal     (default. Opens the form in Form view.)
acPreview    (print preview)

FilterName - A string expression or variable that is a name of a query in the current database.

WhereCondition - A string expression containing an SQL WHERE clause without the word WHERE.  Such as, "Order_ID=" & Me.Order_ID

DataMode - The data entry mode for the form. This only applies to forms in Form view (default) or Datasheet view.  The DataMode argument has the following options:

New! Download a running example of the Docmd.OpenForm Method

acFormAdd - The user can add new records but can not edit existing records.
acFormEdit - The user can edit existing records and add new records.
acFormPropertySettings - (default - uses form's property settings)
acFormReadOnly - The user can only view records.

WindowMode - The window mode in which the form opens.  Window Mode can have the following values:

acDialog - The form's Modal and PopUp properties are set to Yes.
acHidden - The form is hidden.
acIcon - The form opens minimized in the Windows taskbar.
acWindowNormal - (default) Used the forms mode settings.

OpenArgs - A string expression used to set the form's OpenArgs property. The OpenArgs string can then be used by code in a form module, such as the On Open event procedure to perform actions based on the open arguments value.

More Open Form examples:







Microsoft Office:
MS Access 2003
Access 2007
Access 2010
Access 2013



A Blue Claw Software Design Template:

Corporate Document Control Solution
 










A Blue Claw Database Design Article:

Why Choose Microsoft Access
 









Blue Claw Database Design Downloadable Tutorial:
How To Program Continuous-Continuous Master/Detail Forms  



Contact Information

Copyright 2000-2017 Blue Claw Database Design