Table of contents
TOC
Collapse the table of content
Expand the table of content

Application.GUIDFromString Method (Access)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

The GUIDFromString function converts a string to a GUID, which is an array of type Byte.

Syntax

expression. GUIDFromString( ** String** )

expression A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
StringRequiredVariantA string expression which evaluates to a GUID in string form.

Return Value

Variant

Remarks

The Microsoft Access database engine stores GUIDs as arrays of type Byte. However, Microsoft Access can't return Byte data from a control on a form or report. In order to return the value of a GUID from a control, you must convert it to a string. To convert a GUID to a string, use the StringFromGUID function. To convert a string to a GUID, use the GUIDFromString function.

Example

The following example uses the GUIDFromString function to convert a string to a GUID. The string is a GUID stored in string form in a replicated Employees table. The field, s_GUID, is a hidden field added to every replicated table in a replicated database.

Sub CheckGUIDType() 

 Dim dbsConn As ADODB.Connection 
 Dim rstEmployees As ADODB.Recordset 

 ' Make a connection to the current database. 
 Set dbsConn = Application.CurrentProject.Connection 
 Set rstEmployees = New ADODB.Recordset 
 rstEmployees.Open "Employees", dbsConn, , , adCmdTable 

 ' Print the GUID to the immediate window. 
 Debug.Print rst!s_GUID 
 Debug.Print TypeName(rst!s_GUID) 
 Debug.Print TypeName(GuidFromString(rst!s_GUID)) 

 Set rstEmployees = Nothing 
 Set dbsConn = Nothing 

End Sub

See also

Concepts

Application Object

© 2018 Microsoft