To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Delphi Delphi Prism Java JavaScript ObjectPAL Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics -OOP Details Abstraction Class Helper Code Contract Constructor Destructor Inheritance-Multiple Interface Overriding Partial Class Polymorphism Prevent Derivation Static Member

	Access VBA Guides
Access VBA To/From Conversion Guides Access VBA and ASP Classic Access VBA and C# Access VBA and C++ Access VBA and C++/CLI Access VBA and Delphi Access VBA and Delphi Prism Access VBA and Java Access VBA and JavaScript Access VBA and Perl Access VBA and PHP Access VBA and VB Classic Access VBA and VB.Net

Cross Ref Guide

ACCESS VBALANGUAGE

Access VBA

ACCESS VBAANDOBJECTPALTOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

Custom Routines◄╣

+Data Structures

Array

+Statements

+Operators

+Commands

+OOP Basics

-OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► Access VBA ► OOP Details

Custom Routines (Cross Ref > OOP Details)

By Mike Prestwood

Access VBA versus ObjectPAL: A side by side comparison between Access VBA and ObjectPAL.

Language Details

Language Details is kind of a catch all for stuff that didn't make it into language basics nor any other category.

Custom Routines

[Other Languages]

Languages Focus

For non-OOP languages, a custom routine is a function, procedure, or subroutine and for pure OOP languages, a custom routine is a class method. Hybrid languages (both non-OOP and OOP) combine both.

Access VBA: Sub, Function

Access VBA is a non-OOP language with some OOP features. It offers both Subs and Functions. A Sub does not return a value while a Function does. When Subs and Functions are used in a class module, they become the methods of the class.

Syntax Example:

Sub SayHello(ByVal pName As String)

  MsgBox ("Hello " & pName)

End Sub

Function Add(pN1 As Integer, pN2 As Integer) As Integer

  Add = pN1 + pN2

End Function

Access VBA Custom Routines (Sub, Function)

ObjectPAL: method, procedure

ObjectPAL is a non-OOP language (an object-based language) that offers custom methods and custom procedures. When you create a custom method, you associate it with an existing object like a button, form, or library.

When calling a custom method or procedure that has a by reference parameter (uses var), then you cannot use a literal value. this is different than in many other languages which do allow you to pass literals by reference.

Syntax Example:

method sayHello(var pName String)
 msgInfo("", "Hello " + pName)
endMethod

method add(p1 Number, p2 Number) Number
 Return p1 + p2
endMethod

ObjectPAL Custom Routines (method, procedure) 1 certification question.