Examples of hyperlink addresses

The following table shows examples of hyperlink addresses. Note that URLs use slash marks and UNC paths use backslashes.

Hyperlink address	Description
Microsoft Corporation#http://www.microsoft.com#	The Microsoft home page on the Web. Displayed as "Microsoft Corporation."
#http://www.microsoft.com#	The Microsoft home page on the Web.
#http://www.microsoft.com#sample#	The Name tag called "sample" in the .html document for the Microsoft home page.
#\\northwind\public\products.doc##List of discounted products	A Microsoft Word file called Products.doc in the public shared directory on the Northwind server. The ScreenTip is "List of discounted products."
Resume#c:\windows\personal \resume.doc#	A Word file called Resume.doc located in the \Windows\Personal folder. Displayed as "Resume."
#c:\windows\personal\resume.doc#	The Resume.doc file that is located in the \Windows\Personal folder. The path name will be displayed, because there’s no display text.
#c:\windows\personal\resume.doc#Qualifications	The bookmark called "Qualifications" in the Resume.doc file.
#c:\windows\personal\ northwind.mdb#Form Suppliers	The Suppliers form in the Northwind database, located in the \Windows\Personal folder.
Suppliers##Form Suppliers#Click to view and edit supplier information	The Suppliers form in the current database. Displayed as "Suppliers," with the ScreenTip "Click to view and edit supplier information."
#c:\windows\personal\1996 Sales.ppt#13	Slide 13 in the 1996 Sales PowerPoint presentation in the \Windows\Personal folder.
#c:\windows\personal\budget. xls#Sheet1!A2	Cell A2 in Sheet1 of the budget.xls Excel file, located in the \Windows\Personal folder.

To make it easier to enter a hyperlink address, Microsoft Access allows you to omit certain parts of an address. For example:

If you type http://example.microsoft.com, Microsoft Access recognizes the "http:" protocol and translates the address to #http://example.microsoft.com#. (You don't have to enter the number signs (#) yourself.)
If you want to point to a Microsoft Access object in the current database, you can specify just the object name that you want to link to — you don't have to specify a UNC path. If there are multiple objects with the same name, Microsoft Access uses the following order to determine which one to reference: forms, reports, queries, tables, data access pages, macros, modules, views, schemas, stored procedures, SQL linked tables, linked tables, and triggers. If, for example, there is both an Orders form and an Orders table, Microsoft Access assumes that the reference is to the Orders form. You can specify a particular object type by entering object type object name. So to refer to the Orders table instead of the Orders form, enter Table Orders as the subaddress. For object types with multiple words, omit the spaces between words; for example, enter dataaccesspage Orders.
If the text that you enter doesn't include a number sign (#), a protocol (such as "http:"), or a reference to an object in the current database, Microsoft Access assumes the text entered is display text and appends "http://" to the same text for the address. For example, if you type example.microsoft.com, Microsoft Access translates the address as example.microsoft.com#http://example.microsoft.com#.