ShowHyperlinkParameters Method

Data typeValueDescription adArray819When combined with another data type, indicates an array of the other data type. adBigInt20Indicates an 8-byte signed integer. adBinary128Indicates a binary value. adBoolean11Indicates a Boolean value. adBSTR8Indicates a null-terminated character string. adChapter136Indicates a 4-byte chapter value that identifies rows in a child row set. adChar129Indicates a string value. adCurrency6Indicates a currency value. Currency is a fixed-point number with four digits to the right of the decimal point and is stored in an eight-byte signed integer. adDate7Indicates a date value. A date value is stored as a double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day. adDBDate133Indicates a date value (yyyymmdd). adDBTime134Indicates a time value (hhmmss). adDBTimeStamp135Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths). adDecimal14Indicates an exact numeric value with a fixed precision and scale. adDouble5Indicates a double-precision floating-point value. adEmpty0Indicates no value. adError10Indicates a 32-bit error code. adFileTime64Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601. adGUID72Indicates a globally unique identifier (GUID). adIDispatch9Indicates a pointer to an IDispatch interface on a COM object. (ADO does not currently support this data type. Usage may cause unpredictable results.) adInteger3Indicates a 4-byte signed integer. adIUnknown13Indicates a pointer to an IUknown interface on a COM object. (ADO does not currently support this data type. Usage may cause unpredictable results.) adLongVarBinary205Indicates a long binary value. adLongVarChar201Indicates a long string value. adLongVarWChar203Indicates a long null-terminated Unicode value. adNumeric131Indicates an exact numeric value with a fixed precision and scale. adPropVariant138Indicates an Automation PROPVARIANT. adSingle4Indicates a single-precision floating point. adSmallInt2Indicates a 2-byte signed integer. adTinyInt16Indicates a 1-byte signed integer. adUnsignedBigInt21Indicates an 8-byte unsigned integer. adUnsignedInt19Indicates a 4-byte unsigned integer. adUnsignedSmallInt18Indicates a 2-byte unsigned integer. adUnsignedTinyInt17Indicates a 1-byte unsigned integer. adUserDefined132Indicates a user-defined variable. adVarBinary204Indicates a binary value. adVarChar200Indicates a string value. adVariant12Indicates an Automation Variant. (ADO does not currently support this data type. Usage may cause unpredictable results.) adVarNumeric139Indicates a numeric value. adVarWChar202Indicates a null-terminated Unicode character string. adWChar130Indicates a null-terminated Unicode character string.

For more information on ActiveX data types, see ActiveX Data Object (ADO) on the Microsoft Developer Network (MSDN) Web site.

Example

The following example displays the Hyperlink Parameter dialog box with the following URL and settings.

Application.ShowHyperlinkParameters "http://www.fourthcoffee.com/coffee.asp", _
    "type=black", "CategoryID,CategoryName,Description", "3,202,202"