Syscmd Method Access

What is VBA Access

VBA stands for Visual Basic for Applications (the application being of course Microsoft Access) and is the technology and tools used to program and automate this application.

It’s not only used just within the framework of Microsoft Access Database but other applications too including Microsoft Excel, Microsoft Word, Microsoft Outlook to name a few. It has the power to communicate with other applications beyond the Microsoft range and even the Microsoft Windows operating system across other platforms. Therefore, learning the principles of VBA using Access, as the tool environment will stand you in good stead for the other applications should you wish to program and code them in the future. The only difference between other applications when wanting to use VBA will simply be learning to load and work with different libraries. Typical reasons why you would use Microsoft Access VBA include being able to

.Manage smaller re-usable procedures (globally).

.Create your own defined functions.

.Hold variables in memory (globally).

.Attach code to an event i.e. a button on a form.

.Manage more powerful procedures that an Access macro lacks.

.Communicate with other applications and platforms.

.Gracefully handle errors (when they happen).

You can use the SysCmd method to display a progress meter or optional specified text in the status bar, return information about Microsoft Access and its associated files, or return the state of a specified database object (to indicate whether the object is open, is a new object, or has been changed but not saved). Variant.

Syntax

expression.SysCmd (Action, Argument2, Argument3)

Name	Required/optional	DataType	Description
Action	Required	AcSyscmdAction	An AcSysCmdAction constant that identifies the type of action to take. This set of constants applies to a progress meter. The SysCmd method returns Null if these actions are successful. Otherwise, Access generates a run-time error.
Argument2	Optional	Variant	The text to be displayed left aligned in the status bar. This argument is required when the Action argument
Argument3	Optional	Variant	A numeric expression that controls the display of the progress meter. This argument is required when the Action argument is acSysCmdInitMeter; this argument isn't valid for other Action argument values

Please Watching My Video

Design by Vannak Vannaro