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 Prism Access VBA and Java Access VBA and JavaScript Access VBA and ObjectPAL 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 VBAANDDELPHITOC

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 Delphi: A side by side comparison between Access VBA and Delphi.

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)

Delphi: procedure, function

Delphi is a hybrid language so you can create either class methods (functions and procedures) or you can create global functions and procedures. When a function or procedure is part of a class, it is a class method.

[function/procedure] RoutineName : ReturnType;

As with C++, your custom routine must come before it's first usage or you have to prototype it in the Interface section.

Note: Contrast Delphi with Delphi Prism which is an OOP language (everything is within a class). Both Delphi and Delphi Prism are based on Object Pascal but implement OOP features differently and have some syntax differences too.

Syntax Example:

procedure SayHello(pName: String);
begin
  ShowMessage('Hello ' + pName);
end;

function Add(p1, p2 : Double): Double;
begin
  Result := p1 + p2;
end;

Delphi Custom Routines (procedure, function)