Remove hyperlinks in Excel

Scenario (Applies to MS Excel) When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel automatically creates a hyperlink: • http://     • www.      • ftp://     • mailto:      • file://     • news:       • \\ Excel also creates a hyperlink when you type an e-mail address in the following […]

Quick Search Function

Scenario (Applies to MS Access) I have a main form (frmSearch) with a subform (sfrmNamesList) by which its data source is a query (qrySearchNames). In a query, I added a Search field concatenating the fields that are included in the search (Search:[LastName] & ” ” & [FirstName] & ” ” & [Employee ID]). I set a criteria for the Search field as : […]