ShowHyperlinkParameters Method
Displays the Hyperlink Parameter dialog box and returns a String that represents the hyperlink plus the parameters, separated by a question mark.
expression.ShowHyperlinkParameters(bstrPath, bstrQuery, bstrColumns, bstrColTypes)
*expression * Required. An expression that returns one of the objects in the Applies To list.
bstrPath Required String. Specifies the Web address for the hyperlink.
bstrQuery Required String. Specifies the query string to pass in when opening the linked page.
bstrColumns Required String. Specifies a comma-delimited String that contains the names of the database columns that are available for use in the URL.
bstrColTypes Required String. Specifies a comma-delimited String that represents the data type values of the database columns.
Remarks
The values for the bstrColTypes parameter include the following.
| Data type | Value | Description |
|---|---|---|
| adArray | 819 | When combined with another data type, indicates an array of the other data type. |
| adBigInt | 20 | Indicates an 8-byte signed integer. |
| adBinary | 128 | Indicates a binary value. |
| adBoolean | 11 | Indicates a Boolean value. |
| adBSTR | 8 | Indicates a null-terminated character string. |
| adChapter | 136 | Indicates a 4-byte chapter value that identifies rows in a child row set. |
| adChar | 129 | Indicates a string value. |
| adCurrency | 6 | Indicates 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. |
| adDate | 7 | Indicates 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. |
| adDBDate | 133 | Indicates a date value (yyyymmdd). |
| adDBTime | 134 | Indicates a time value (hhmmss). |
| adDBTimeStamp | 135 | Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths). |
| adDecimal | 14 | Indicates an exact numeric value with a fixed precision and scale. |
| adDouble | 5 | Indicates a double-precision floating-point value. |
| adEmpty | 0 | Indicates no value. |
| adError | 10 | Indicates a 32-bit error code. |
| adFileTime | 64 | Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601. |
| adGUID | 72 | Indicates a globally unique identifier (GUID). |
| adIDispatch | 9 | Indicates a pointer to an IDispatch interface on a COM object. (ADO does not currently support this data type. Usage may cause unpredictable results.) |
| adInteger | 3 | Indicates a 4-byte signed integer. |
| adIUnknown | 13 | Indicates a pointer to an IUknown interface on a COM object. (ADO does not currently support this data type. Usage may cause unpredictable results.) |
| adLongVarBinary | 205 | Indicates a long binary value. |
| adLongVarChar | 201 | Indicates a long string value. |
| adLongVarWChar | 203 | Indicates a long null-terminated Unicode value. |
| adNumeric | 131 | Indicates an exact numeric value with a fixed precision and scale. |
| adPropVariant | 138 | Indicates an Automation PROPVARIANT. |
| adSingle | 4 | Indicates a single-precision floating point. |
| adSmallInt | 2 | Indicates a 2-byte signed integer. |
| adTinyInt | 16 | Indicates a 1-byte signed integer. |
| adUnsignedBigInt | 21 | Indicates an 8-byte unsigned integer. |
| adUnsignedInt | 19 | Indicates a 4-byte unsigned integer. |
| adUnsignedSmallInt | 18 | Indicates a 2-byte unsigned integer. |
| adUnsignedTinyInt | 17 | Indicates a 1-byte unsigned integer. |
| adUserDefined | 132 | Indicates a user-defined variable. |
| adVarBinary | 204 | Indicates a binary value. |
| adVarChar | 200 | Indicates a string value. |
| adVariant | 12 | Indicates an Automation Variant. (ADO does not currently support this data type. Usage may cause unpredictable results.) |
| adVarNumeric | 139 | Indicates a numeric value. |
| adVarWChar | 202 | Indicates a null-terminated Unicode character string. |
| adWChar | 130 | Indicates 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"
Applies to | Application Object