Edit

Reference.Major property (Access)

  • Article

The Major property of a Reference object returns a read-only Long value indicating the major version number of an application to which you have set a reference.

Syntax

expression.Major

expression A variable that represents a Reference object.

Remarks

The Major property returns the value to the left of the decimal point in a version number. For example, if you've set a reference to an application whose version number is 2.5, the Major property returns 2.

Example

The following example displays a message with information about all the references in the current project.

Dim r As Reference 
Dim strInfo As String 
 
For Each r In Application.References 
 strInfo = strInfo & r.Name & " " & r.Major & "." & r.Minor & vbCrLf 
Next 
 
 
MsgBox "Current References: " & vbCrLf & strInfo

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.