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 Exception Trapping If Statement +Operators +Commands +Database +OOP Basics +OOP Details

	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 ObjectPAL Access VBA and Perl Access VBA and PHP Access VBA and VB.Net

Cross Ref Guide

ACCESS VBALANGUAGE

Access VBA

ACCESS VBAANDVB CLASSICTOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

Parameters◄╣

+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 ► Statements

Parameters (Cross Ref > Statements)

By Mike Prestwood

Access VBA versus VB Classic: A side by side comparison between Access VBA and VB Classic.

Language Details

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

Parameters

[Other Languages]

Access VBA: ByRef, ByVal

By Reference or Value
For parameters, you can optionally specify ByVal or ByRef. ByRef is the default if you don't specify.

Syntax Example: 1 certification question.

Function SomeRoutine(ByRef pPerson, ByVal pName, Age)

VB Classic: ByRef, ByVal

By Reference or Value
For parameters, you can optionally specify ByVal or ByRef. ByRef is the default if you don't specify.

Syntax Example: 1 certification question.

Function SomeRoutine(ByRef pPerson, ByVal pName, Age)